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 PostgreSQL database contains
orders(order_id, paid_at) and shipments(shipment_id, order_id, shipped_at). The fulfillment metric is the median number of hours from payment to first shipment among orders that have at least one shipment. An order can have several shipment records.Which query calculates the specified median at the correct metric grain?
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