EXISTS Subquery for Conditional Filtering
Hard
subqueries
Capital One
PayPal
JPMorgan
Write a query using EXISTS to find all customers who have placed at least one order worth more than 500. Return customer_name, ordered alphabetically.
Expected Output: Customers with at least one high-value order.
Tables
Hints (3 available)
SQL Editor
Output
Click "Run" to see results...