...
We explored some more advanced concepts like independent subqueries and closed things out with a discussion of some of the less common query bases.
2:00 independent subquery example: next event happening near student address
5:30 filter for date within the next month (today + 30)
13:20 comparing first source to whether or not there is an application
15:30 existence export to determine if there is an application
21:00 reminders abut most recent versus any
22:00 other query bases
form query: one row per event
form response: one row per registration
message: one row per email received
message track: one row per click/open
27:05 system: lookup tables, list of fields/prompts
count of times a particular prompt value is selected within records
Reporting Concepts I & II
Nov 11
Nov 18