Warby Parker project problem

Hi

I’m working through the Warby Parker project and am stuck trying out one of the video solutions. I can not find where the issue is, the query does not return anything even though I’ve pretty much copied the code. Am I missing something obvious here?

WITH base_table AS (
 SELECT DISTINCT q.user_id,
   h.user_id IS NOT NULL AS 'is_home_try',
   h.number_of_pairs AS 'AB_Variant',
   p.user_id IS NOT NULL AS 'is_purchase'
 FROM quiz q
 LEFT JOIN home_try_on h
   ON q.user_id = h.user_id
 LEFT JOIN purchase p
   ON q.user_id = p.user_id)
    
SELECT AB_Variant,
  SUM (CASE 
      WHEN is_home_try = 1 THEN 1
      ELSE 0
      END) AS 'Tried on',
  SUM (CASE WHEN is_purchase = 1 THEN 1
      ELSE 0
      END) AS 'Bought'
  FROM base_table
  GROUP ON AB_Variant;

https://www.codecademy.com/paths/data-science/tracks/analyze-data-sql-analyze-real-data/modules/analyze-data-sql-usage-funnels/projects/analyze-data-sql-usage-funnels-with-warby-parker

Thx

Hello, @cloudplayer73598.

Welcome to the forums.

GROUP ON?