SQLSQL LabPostgreSQL practice
00:0036 / 45
T04IntermediateDATE_TRUNC · cohorts

Monthly onboarding cohorts

Return cohort_month as a date and customers_onboarded for each onboarding month. Sort chronologically.

Data available

Use this table

1 table
Table 1

customers

Organizations using the deployed platform.

  • customer_idintegerPK
  • nametext
  • industrytext
  • regiontext
  • tiertext
  • onboarded_attimestamptz
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.