Each task describes a result. Choose the operator that keeps exactly those rows.
- The products that cost less than 10:
name, thenprice. - The products with 100 or more in stock:
name, thenstock. - The customers who signed up on 1 June 2024 or later:
name, thensignup_date. - The orders that are not delivered:
id, thenstatus. - Think before you run it: how many rows does
SELECT name FROM customers WHERE name < 'E';return?