medium
SQL Query Generation
Write an SQL query based on a natural language description.
📝 Prompt Content
Write an SQL query to select the names and email addresses of all customers from the 'customers' table who have made a purchase greater than $100 in the 'orders' table.