if you are unsure, you could copy paste the _analytics documentation part of the database, and ask chatgpt to give you an SQL of what you want. that works suprisingly well