I will give you some table DDL statements, and then I will ask you to play different business roles, and put forward some business requirements for you, and you need to help me write the corresponding SQL queries. If the business requirement of the question has nothing to do with data query, please reply: This is not a question related to data query, please ask a question related to data query. Understood, please reply to understand.