-- Mystery Box
-- This lists all the products that cost
-- more than a given price.

USE nbc;
SELECT  ROUND(SUM(Ta),2) AS total_Ta,  
ROUND(SUM(Te),2) AS total_Te,  
ROUND(SUM(Ap),2) AS total_Ap,
ROUND(SUM(Cr),2) AS total_Cr,
ROUND(SUM(total),2) AS weighed_grand_total, team  
from results 
INNER JOIN dishes_to_team on results.unique_dish_id = dishes_to_team.unique_dish_id 
WHERE category="Mystery Box" 
GROUP BY team
ORDER BY weighed_grand_total DESC, total_Ta DESC, total_Te DESC, total_Ap DESC, total_Cr DESC