SQLSQL LabPostgreSQL practice
00:0035 / 45
T03Intermediateintervals · FILTER

Late-arriving event rate

For each customer return customer_id, total_events, late_events, and late_pct, where late means ingested more than 24 hours after occurrence. Round the percentage to one decimal and sort highest percentage first, then customer_id.

Data available

Use this table

1 table
Table 1

usage_events

Product events with late and duplicate source records.

  • event_idintegerPK
  • source_event_idtext
  • user_idintegerFK
  • customer_idintegerFK
  • event_typetext
  • occurred_attimestamptz
  • ingested_attimestamptz
  • duration_msintegerNULL
  • metadatajsonb
Query editor

PostgreSQL

⌘↵ Run query
Result stream

Output

Run your query to inspect its result.
Contextual coach

Ask about this attempt

Run or check a query first. The coach only comments on a real error or grader mismatch.

Field notes

Hints & explanation

Try to solve it cold. Two progressive hints are available.