User Account

All Pages

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:

Reviews

Write a Review

Programming Languages Questions & Answers

  Matlab integration techniques

Use MATLAB integration techniques to determine the total Axial Elongation and explain the theory of Simpson 1/3 rule for integration in detail. Use appropriate examples to demonstrate how it works and how the integration result is computed.

  Design a program that calculate the percentage

You have been asked to design a program that will allow a teacher to calculate the percentage and the final grade for students in a class

  Calculator to do the suitable matrix exponentiation

Every company makes particular restrictions for passwords, but employees of ABC have particularly strange restrictions. Their passwords may only consist of the lowercase letters

  Create ajax-based product catalog

Create an AJAX-based product catalog which obtains its data from JSON files located on the server. The data should be separated into four JSON files.

  Technique of multiplexed switching of analogue signals

Explain briefly from what you notice about the digital output values in (a) why a digital output value of an A/D converter is rarely the exact same digital value as the analogue input value.

  Cate a function with the first line functionarrayout

create a function with the first line functionarrayout switcherooarrayin this function should take an array of any

  What will the exp days column contain

If expiration_date contains a value that's equivalent to November 2, 2008 and the SYSDATE function returns a value that's equivalent to December 17, 2008, what will the exp_days column contain when this code is executed

  Write program which permits the user to enter students name

Write the program which permits the user to enter students' names followed by their test scores and outputs following information (suppose that maximum number of students in class is 50)

  Compute and print annual salary of employee

Identify input, process and output to solves each problem. Compute and print the annual salary of employee. suppose the employee receive 6% increase in pay.

  Write css rule to gives all h elements padding

Write down CSS rule which gives all h1 and h2 elements padding of 0.5 ems, grooved border style and margin of 0.5ems. Prepare a layout template which contains header and two columns.

  Create program to enter number of packages bought

Create a program which asks user to enter number of packages bought . The program must then display amount of discount (if any) and total amount of purchase after the discount.

  How prospectors get through mine shaft only fifteen minutes

How can all four prospectors get through mine shaft in only 15 minutes? After you have solved this problem, describe how you got your foot in door.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd