Generate Database Queries

I need [SQL/ORM queries] for [database type].

Use case: [what you're trying to accomplish]

Tables involved:
[Paste schema or describe structure]

Queries needed:
1. [Description of first query]
2. [Description of second query]
3. [Description of third query]

Requirements:
- Must be [performant/secure/paginated]
- Should handle [edge cases]
- Return format: [describe expected results]