List the customers (name) and the total amount of all their orders.

Q. List the customers (name) and the total amount of all their orders.

Consider  this table --

You can understand by seeing this video ---

Answer =

SELECT NAME , SUM (QUANTITY * PRICE) FROM ORDERS , PARTS WHERE ORDERS.PARTNUM = PARTS.PARTNUM  GROUP BY NAME ;