← Quiz: SQL for Data Analysis: all 9 questions
Quiz: SQL for Data Analysis · Question 8 of 9
The first month in a LAG-based growth query shows NULL. What does that mean?
The first month in a LAG-based growth query shows NULL. What does that mean?
- A.Growth was 0%
- B.The query is wrong
- C.Revenue was 0
- D.There is no previous month to compare with, so growth is unknown
Answer & explanation
Correct answer: There is no previous month to compare with, so growth is unknown
LAG returns NULL for the first row, and any arithmetic with NULL is NULL.
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 →