Top 7 Ingredients

WITH cte AS (
    SELECT 
        i.Ingredient,
        COUNT(cont.Ingredient_ID) AS Ingredient_Count
    FROM
        ingredients i
    INNER JOIN 
        main_contents cont ON 
        i.Ingredient_ID = cont.Ingredient_ID
    GROUP BY 
        i.Ingredient
)

SELECT 
    Ingredient, 
    Ingredient_Count,
    (Ingredient_Count / 
        SUM(Ingredient_Count) OVER ()) * 100 
        AS Percentage
FROM 
    cte
ORDER BY 
    Percentage DESC
LIMIT 7;
        

📋 Copy SQL Code