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
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
Get step-by-step solutions from verified subject matter experts
