Display all users who created an account

1. Navigate back to the Query Editor.
2. Open a new tab by clicking on the + sign:
Query Editor
3. In order to see who created an account, we’ll use the CustomerInformation collection.
Action Item: In the new empty editor, paste this code.
SQL code
Major SQL code highlights:
  • We added lines 1-6 we are selecting all the information and ordering it by _event_time in descending order.
4. Go ahead and run the query:
Query editor
NOTE: You can find us on the Rockset Community if you have questions or comments about the workshop.