Trying to find all of whiskey sales from a certain store -SQL-

Question

I want to find the total sales of Whiskeys at a certain store in the dataset

Here's my code (Using PopSql connected to bigquery)

SELECT DISTINCT category_name, ROUND(SUM(sale_dollars)) AS Total_Revenue FROM Liquor_Sales.Iowa WHERE store_name = 'HY-VEE #3 / BDI / DES MOINES' AND category_name LIKE '%WHISK%' GROUP BY category_name ORDER BY Total_Revenue DESC;

This code gives me every category that contains 'Whisk' (I.E. Canadian whiskey, Tennessee whiskey, ETC) and their total sales but I want them to be lumped into one 'Whiskey' category with the Total revenue

score 1 · Accepted Answer · answered Mar 02 '23 at 18:47

1

Then you simply remove the category grouping:

SELECT
    'Whiskey' AS Category_Name,
    ROUND(SUM(sale_dollars)) AS Total_Revenue
FROM
    Liquor_Sales.Iowa
WHERE
    store_name = 'HY-VEE #3 / BDI / DES MOINES'
    AND 
    category_name LIKE '%WHISK%'

answered Mar 02 '23 at 18:47

Kurt

1,708
1
3
11

1

Thank you very much! I am fairly new to SQL and this helps a lot! – Caleb Pool Mar 02 '23 at 19:37
@CalebPool Please consider marking the Accept Answer flag so that others know this question is resolved. – Isolated Mar 02 '23 at 20:13

Trying to find all of whiskey sales from a certain store -SQL-

1 Answers1