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.