Solution-Rewrite the sql statement to make it correct.

Rewrite the sql statement to make it correct.

Assignment Help Programming Languages

Reference no: EM13930338

Consider the following tables:

Customers

CustomerID LastName FirstName State

1 Cohen Mike CO

2 Highley Michelle MI

3 Cohen Margot MI

Orders

OrderID CustomerID Ordered_Item Date_Ordered

1 3 DVD Movie 1/1/2009

2 1 Computer Book 3/1/2009

3 2 Music CD 2/1/2009

Write an SQL statement that will return the following result:

Name Location Item Date

Margot Cohen OH DVD Movie 1/1/2009

Michelle Cohen GA Music CD 2/1/2009

Mike Cohen CO Computer Book 3/1/2009

Using the two tables from #8, write an SQL statement that uses a SUB QUERY and the IN keyword to return the First Name of

the customers who live in the state of MI.

Tell why the following SQL statement is incorrect. Rewrite the SQL statement to make it correct. (Hint: The fields of the table

are StudentName, Assignment, Grade. A student's name can be in the table more than once since they could have several

assignments.)

SELECT StudentName, AVG(Grade)

FROM GradeBookTable

Attachment:- sql.doc

Reference no: EM13930338

Questions Cloud

Analysing the professional attributes and scope of practice : Write a 1000 word essay discussing and analysing the professional attributes and scope of practice that differentiates the specialty nurse in your elective.

What two items are most responsible for the difference : What two items are most responsible for the difference between Target's net income and its cash flow from operating activities in 2010?

Determine the range of weights : Compute the force P required to slide the door at a steady speed if wheel A becomes "frozen" and does not turn in its bearing.

Study of individual behaviour-individual industry : Micro economics- study of individual behaviour -individual industry like education, meat industry, tourism and agriculture. Choose any one industry from Australia and discuss the reforms been done in that industry.

Rewrite the sql statement to make it correct. : Tell why the following SQL statement is incorrect

Explain how gdp is measured in your country : Explain how GDP is measured in your country (Nepal). Provide real life examples.

Develop a specific plan to address the problem : Cameron is conducting a study that addresses the differences in achievement scores between schools that use block scheduling and schools that use a traditional scheduling format. He has accessed average achievement scores for 1200 schools and now ..

This chapter explained that many companies : Based only on the information in the statements of cash flows, does Sirius XM appear to be growing the capacity of its business? Explain.

Number of non-current assets : AGES controls a number of non-current assets. To make things simple, the owner decided all non-current assets should be depreciated using the straight line depreciation method*. Details relating to assets controlled by AGES are shown below:

User Account

All Pages

Rewrite the sql statement to make it correct.

Reference no: EM13930338

Reference no: EM13930338

Questions Cloud

Reviews

Write a Review

Programming Languages Questions & Answers

Write a haskell program to calculates a balanced partition

Create an application to run in the amazon ec2 service

Explain the process to develop a web page locally

Write functions

Programming assignment

Write a prolog program using swi proglog

Create a custom application using eclipse

Create a application using the mvc architecture

Develops bespoke solutions for the rubber industry

Design a program that models the worms behavior

Writing a class

Design a program that assigns seats on an airplane

Assured A++ Grade

Academics

Major Subjects

Majors

Get In Touch

TERMS & POLICIES

HELP & SUPPORT