-- Beef Brisket
-- This lists all the products that cost
-- more than a given price.

USE modena;
SELECT  ROUND(SUM(taste),2) AS total_taste,  
ROUND(SUM(texture),2) AS total_texture,  
ROUND(SUM(appearance),2) AS total_appearance,
ROUND(SUM(creativity),2) AS total_creativity,
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="Brisket" 
GROUP BY team
ORDER BY weighed_grand_total DESC, total_taste DESC, total_texture DESC, total_appearance DESC, total_creativity DESC