Hey guys I have one question, I am doing this exercise in SQL course and I guess I have problem with syntax. Basicaly I wrote this code :
SELECT DISTINCT quiz.user_id, home_try_on.user_id IS NOT NULL AS 'Is home try on', home_try_on.nuber_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 purchse.user_id = quiz.user_id LIMIT 10;
And the correct solution provided by codecademy is :
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;
Mine is not working. But I do not get any error message from codecademy and I do not know why. I have just blank white screen as if I did not ever run the code. I guess I have something wrong with my code. Do you have an idea what went wrong from my side?