Develop the queries to support each of the reports that are required by Ms Smith. It is expected that the information returned by the queries is adequate to be used in the reporting process. Make sure your output contains enough information! The following is a recommendation and the MINIMUM amount of data you should have access to:
* Customer Table: A minimum of 12 customers (this will allow several channels to have more than one customer selecting it as a favorite channel)
* Billing Table: Records to support the above customers
* Program Table: A minimum of 25 programs (your program guide should have enough programs for various channels to support the program guide report)
* Other tables: A sufficient amount of data to support the above when reports are run
Show each query and its output in your submission (you will have a minimum of six queries).
To submit this task, create a heading REPORTING STATEMENTS in the SQL document and create a spooled or HTML output of your queries and the result set for each.
Attached are the Tables and insert statements
Budget: $20 USD
30 freelancers are bidding on average $139 for this job
My name is Manh from Vietnam. I read your project details and I am sure I can complete your [url removed, login to view] we can chat/discuss further on your project?
Hello, I am interested in your project. I am a software engineer and I have professional experience with SQL. Could you please send me more details about your project? Thank you, Best regards, David
Please review my profile. [url removed, login to view] I have 4 years experience in SSRS, SSIS and 6.9 years experience in SQL. Please let me know more details and when will we start. Skype: jikenjd
I have an experience of 12 years in Oracle, SQL database with reporting tools like Business Objects, crystal reports . I have also worked as a database Architecture. I think i can give full justice to your projects.