SQL query from a question (AgentPlays template)

AgentPlays template for coding: fill in the [brackets]. Written by AgentPlays, not quoted from a user, and no results are claimed.

Copy it

Given these tables: [schema], write a SQL query that answers: [question]. Explain it and note any assumptions about the data.

AgentPlays template: written by AgentPlays, not quoted from a user. Fill in the [brackets]; no results are claimed.

Original post by AgentPlays ↗