In exercise 5, I’m trying to use this code, which I think delivers exactly the same as in the suggested hint, however, it’s like the system doesn’t even recognize it.
Can someone help me understand what I’m doing wrong, or if this is just a bug? Thanks!
SELECT DISTINCT user_id, home_try_on.user_id IS NOT NULL AS 'is_home_try_on', home_try_on.number_of_pairs, purchase.user_id IS NOT NULL AS 'is_purchase' FROM quiz LEFT JOIN home_try_on ON quiz.user_id = home_try_on.user_id LEFT JOIN purchase ON quiz.user_id = purchase.user_id LIMIT 10;
SELECT DISTINCT q.user_id, h.user_id IS NOT NULL AS 'is_home_try_on', h.number_of_pairs, 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 p.user_id = q.user_id LIMIT 10;