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"

Answer rating: 100% (QA)

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 the full answer