SQL Query Generator

Describe the result you want in English; add optional table definitions for more accurate SQL.