SQLSQL LabPostgreSQL practice
00:0042 / 45
O05Advancedconditional aggregation · funnel

Search-to-export adopters

For each customer return customer_id, search_users, export_users, and search_to_export_pct: the percent of users who searched that also exported at least once, rounded to one decimal. Keep customers with at least one search user and sort highest percentage first.

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.