SQL Transpose Rows as Columns
Use: SELECT r.user_id, MAX(CASE WHEN r.question_id = 1 THEN r.body ELSE NULL END) AS “Do you like apples?”, MAX(CASE WHEN r.question_id = 2 THEN r.body ELSE NULL END) AS “Do you like oranges?”, MAX(CASE WHEN r.question_id = 3 THEN r.body ELSE NULL END) AS “Do you like carrots?” FROM RESPONSES r JOIN QUESTIONS q ON … Read more