PostgreSQL DISTINCT ON Quiz: Latest Rows and Deterministic Ordering

PostgreSQL DISTINCT ON Quiz: Latest Rows and Deterministic Ordering

Choose one answer. Each attempt draws 10 of 20 questions; the practice pass mark is 8/10. Original topic practice, not an official exam. Select one row per group with explicit ordering, tie-breakers and NULL placement.
1 of 10
For DISTINCT ON (region, customer_id), what defines a group?