Matomo SQL Queries

Hi there, does anyone have any handy SQL queries they can share that aid in data reporting directly from the Matomo database?

I am new to Matomo and trying to learn the schema but any handy queries would be a great help.

Specifically, I am trying to determine where a user visited one page and also another specific page in the same session.

Thank you for any help.


You can enable query logging to see the queries Matomo does: