🎙 Free live masterclass · Sun, 29 Nov, 7:00 pm IST · Java Full Stack roadmap Register free →
Skills101
← Quiz: SQL for Data Analysis: all 9 questions

Quiz: SQL for Data Analysis · Question 3 of 9

In the CASE-based pivot, how many CASE expressions do you need?

In the CASE-based pivot, how many CASE expressions do you need?

  1. A.One for the whole query
  2. B.One for each output column you want
  3. C.One for each row in the table
  4. D.One for each GROUP BY column
Answer & explanation

Correct answer: One for each output column you want

Each CASE picks the rows for one column, such as books or clothes.

Can you get the rest right without peeking?

Take the timed Quiz: SQL for Data Analysis quiz free. Pass it to earn XP and count towards your certificate.

Start the quiz →