Encerrado

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

Habilidades: SQL

Ver mais: java database small project, java small project database, sql database small project, query project database, small project database sql, database small project, database small project access, query ms project database, asp net small project database, small project database, show query results website, project database hotel, real estate project database, php mysql simple project database, project database online quiz

Acerca do Empregador:
( 0 comentários ) United States

ID do Projeto: #11738153

30 freelancers estão ofertando em média $139 para este trabalho

manhpham

My name is Manh from Vietnam. I read your project details and I am sure I can complete your project.Can we can chat/discuss further on your project?

$30 USD em 1 dia
(37 Comentários)
5.4
it2051229

Hi there, I would like to do this project if given the opportunity. Let me know if you are interested so I can have further details. Thanks.

$30 USD em 1 dia
(46 Comentários)
4.9
jagdishbhatt38

I am having more than 7 years of experience in IT industry.I have worked on .net(c#,asp,asp.net,mvc) with sql server 2005/2008/2012 and oracle(pl/sql). I can provide you better solution by utilizing my knowledge and Mais

$250 USD in 5 dias
(4 Comentários)
3.7
davedcb

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

$150 USD in 5 dias
(15 Comentários)
3.9
shahzaib121

Hi Dear I have a lot of experience in DataBases ,Data Warehous,DB2 , Teradata etc . I am DataBases + Warehouse certified from Oracle,postgresSQL,SQL SERVER , Access. I have done many work in Requirements analysis , Da Mais

$155 USD in 3 dias
(9 Comentários)
4.1
vinaysinghh

I am sql expert certified by Oracle corporation

$55 USD em 1 dia
(18 Comentários)
4.1
vw7590795vw

Please review my profile. https://www.freelancer.com/u/vw7590795vw.html 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

$30 USD in 0 dias
(6 Comentários)
2.8
$300 USD in 10 dias
(1 Comentário)
3.0
umairmalik10

Hi, I've over viewed the details of the project provided by you and I am please to declare myself the right candidate for this project as I've completed many successful projects in PHP and it's frameworks like laravell Mais

$194 USD in 3 dias
(2 Comentários)
2.2
$155 USD in 3 dias
(4 Comentários)
2.0
utkarshkatiyar19

I can do.

$120 USD in 5 dias
(1 Comentário)
1.2
rastoginimit

Playing with SQL is my day to day work.

$88 USD in 2 dias
(0 Comentários)
0.0
amitarai

Hello My name is Pranav I have checked the details shared by you will do done exactly what you want Please consider my bid and we can discuss more so that i can assist you in better way our services always with Mais

$155 USD in 7 dias
(1 Comentário)
0.0
gopinathpadhi

Good experience in SQL. Certified database administrator. Experience in query optimization, performance tuning .

$166 USD in 5 dias
(0 Comentários)
0.0
koppuravuriraghu

I am Microsoft SQL Programmer and i have very good real time experience and i am very good at ->Designing and deploying data table structures, forms, reports, and queries. ->Identifying inefficiencies in current da Mais

$103 USD in 4 dias
(0 Comentários)
0.0
psvr007

Hi Madam/Sir, I am expert in SQL. I have been working databases -Oracle/Teradata/DB2/Sybase/MYSQL/Vertica. Let us have detailed discussion and plan to ensure smooth delivery of the project. Thanks and Regards, Mais

$235 USD in 5 dias
(0 Comentários)
0.0
$166 USD in 3 dias
(0 Comentários)
0.0
geetumishra76

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.

$155 USD in 3 dias
(0 Comentários)
0.0
$155 USD in 3 dias
(0 Comentários)
0.0
tutraduccion2010

Hello, I'm a systems engineer and have been working as a database administrator for over six years, I can help you with your project. You said in the project description that you had attached the tables and insert s Mais

$125 USD in 5 dias
(0 Comentários)
0.0