Write and explain a SQL query

Gives you the query plus what it assumes about your data.

Write a SQL query for [POSTGRES / MYSQL / SQLITE / BIGQUERY].

Schema:
[PASTE CREATE TABLE STATEMENTS OR COLUMN LISTS]

Question to answer: [WHAT I WANT TO KNOW]

Return:
1. The query, formatted readably.
2. What the query assumes about the data (nulls, duplicates, time zones, soft deletes).
3. How it will behave as the tables grow, and which index would help.
4. One way the result could be misleading.