SQL Quiz
10 questions · no time limit
0:00
SQL FOR ANALYTICS AND REPORTING
Question 1 of 10
No time limit
Current
Answered
Flagged
Not seen
PASSAGE
A report calculates customer conversion using this structure:
FROM customers AS c
JOIN sessions AS s
ON s.customer_id = c.customer_id
AND s.started_at >= :month_start
AND s.started_at < :next_month
LEFT JOIN purchases AS p
ON p.customer_id = c.customer_id
AND p.purchased_at >= :month_start
AND p.purchased_at < :next_month
The numerator counts distinct customers with a purchase, and the denominator counts distinct joined customers.Which description should accompany the conversion rate?
YOUR PROGRESS
10
QUESTIONS
Ready when you are
Answer in any order. Your progress shows here as you go.
QUESTIONS
KEYBOARD
Pick an answer ABCD
Next question ↵→
Previous ←
Flag for review F
Answers save as you go · flagged questions come back at the end