Question: Use the ERD below and write SQL statements to find: 1- TotalAmount for Year 2004 and ProductName = 1934 Ford V8 Coupe 2- TotalAmount for

Use the ERD below and write SQL statements to find:


1- TotalAmount for Year 2004 and ProductName = "1934 Ford V8 Coupe"
2- TotalAmount for State "MA" 

3- TotalAmount  for Country Australia and Territory APAC

4- Total Amount for Year 2005  and Product Line "Ships" 

5- TotalAmount for City "Glendale" 

6- TotalAmount  for Year  2004 and Product Line 'Planes' 

7- TotalAmount for UK and Territory EMEA

8- TotalAmount for city "Cambridge"

9- TotalAmount for State "NY"

10- TotalAmount for State "CA"

11- TotalAmount for Office 4

12- TotalAmount for Office 7

13- TotalAmount for City "Barcelona"  

14- TotalAmount for Year 2003 and ProductLine "Classic Cars"

Step by Step Solution

3.49 Rating (172 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

Please note that you should adapt the table and column names based on your specific database schema 1 TotalAmount for Year 2004 and ProductName 1934 Ford V8 Coupe sql SELECT SUMOrderDetailsAmount AS T... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!