In Progress

Small Database Project

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

Skills: SQL

See more: small database project, small project database, small project sql, database small project, project small database, small sql project, sql project small, sql small project, small project data database, small project html database, sql database small project, small database project report, small project database sql, show sql query customer favorite channel, customer table minimum customers, small database project html, develop queries support reports required smith expected, small sql database project, small project html, sql small database

About the Employer:
( 8 reviews ) Hidden, United States

Project ID: #775737

Awarded to:

PerfectSquare

Please see the PM

$30 USD in 0 days
(8 Reviews)
3.3

12 freelancers are bidding on average $54 for this job

eperfections

Please see PMB

$30 USD in 1 day
(65 Reviews)
5.9
mastersoft1

hi. I know very good SQL language. Will be an easy job. thanks !

$30 USD in 1 day
(3 Reviews)
2.1
sasinlondon

Hi there I am happy to do the job but for $ 28 with in 1 hour. regards

$30 USD in 1 day
(0 Reviews)
0.0
Imranlaldin

Hi, I have vast experience in creating MS Access Databases. I can fulfill your requirement. Regards

$30 USD in 2 days
(0 Reviews)
0.0
vlopes777

Hi there I can do this with no problem and for 20$ I'm a programmer with more than 12 years using VB6, SQL, PL-SQL, Crystal Reports and also more than 2 years using VB.NET Hope to hear from you soon

$30 USD in 1 day
(0 Reviews)
0.0
anjeko

Hello, Will be done today, Regards Jerry Melbourne

$30 USD in 1 day
(0 Reviews)
0.0
abraunschweig

Please refer to PM as it contains relevant data, thanks

$30 USD in 1 day
(0 Reviews)
0.0
adnanjavedkhan

Hi! I go through with your project requirements and I am highly interested in your project. I want to apply my copmuter development skills to a challenging environment where my skills will make a significant impact on More

$250 USD in 4 days
(0 Reviews)
0.0
mom77

LONG EXPERIENCE .. 20$ ..

$30 USD in 1 day
(0 Reviews)
0.0
CoreITSolution

We are a team of DBAs with 20+ years of experience in IT Field. We are into database consultancy to support of database. We want to start outsource market, we will show you the quality we can deliver. For Info refer: More

$30 USD in 1 day
(0 Reviews)
0.0
kashifzubair

Hi, very much interested for this project as i am very much familiar with SQL query generation

$100 USD in 5 days
(0 Reviews)
0.0