Choose your SQL: SELECT wisely

Description:
There are many ways you can write SQL to answer your questions. For example, do you use:

- PIVOT or FILTER ( WHERE … ) to convert rows to columns?
- MATCH_RECOGNIZE or SESSIONS to sessionize data?
- CREATE VIEW or CREATE MACRO to define reusable SQL?

In this interactive session we discussed the pros and cons of each of these and took attendees votes on which features to use.
Watch to see what others thought and which approaches came out on top. Highlights include:

02:15 - SQL Wordsearch
04:00 - Yesterday's data date logic
11:30 - Pivot hourly counts to columns
18:45 - Sessionizing data
28:45 - Defining reusable queries
40:00 - Date logic demo
45:50 - Pivot demo
49:30 - 30 minute sessions demo
52:00 - Macro demo
55:52 - Recap & Chris's choices