0

I made this query with reference to this blogI am getting an error while using this query in MySQL.

The query logic is correct but I'm getting an error when running this in MySQL.

I looked at previous questions on StackOverflow, but didn't find something to help me.

Here is the query:

SELECT
COUNT(Button) AS Button,
COUNT(BurgetMenu) AS BurgerMenu,
COUNT(Tabs) AS Tabs,
SUM(CASE WHEN Button <= BurgerMenu THEN 1 ELSE 0 END) AS conversion_1_2,
SUM(CASE WHEN Button <= BurgerMenu AND BurgerMenu <= Tabs THEN 1 ELSE 0 END) 
AS conversion_2_3

FROM (SELECT 
     user_id,
     MAX(CASE WHEN `event_type` = 'Button' THEN first_occurance ELSE NULL END) AS Button,
     MAX(CASE WHEN `event_type` = 'BurgerMenu' THEN first_occurance ELSE NULL END) AS BurgerMenu,
     MAX(CASE WHEN `event_type` = 'Tabs' THEN first_occurance ELSE NULL END)AS Tabs

  FROM (SELECT deviceid, `event_type`, `date_time` AS first_occurance
        FROM events
        WHERE `date_time` BETWEEN '2017-10-30' AND '2017-11-06'
           AND `event_type` IN('Button','BurgerMenu','Tabs')
           AND deviceid IS NOT NULL
        GROUP BY `deviceid`, `event_type`) a

  GROUP BY `deviceid`)

I know that Stackoverflow has many answers for same error , but do please help with my query, i have referred with previous answers

White Rose
  • 11
  • 7

0 Answers0