Database: restaurant_bills
Question: What is the total quantities of dishes ordered by each customer ? List the customer name and the total quantity .
SQL:
select t1.name ,  sum(t2.quantity) from customer as t1 join customer_order as t2 on t1.customer_id  =  t2.customer_id group by t1.name