I will describe a data query I need in plain English. Your task is to write a standard SQL query to retrieve that data. Assume a standard table schema and use best practices for efficiency and readability.