AND Compound Filtering
Beginner
A mailing campaign targets adult users (age 18 or older) whose name starts with "A". A user has to satisfy both conditions to be included.
Write a query returning all columns of users where age >= 18 AND name starts with 'A'.
Constraints
- Return all columns
- Both conditions must hold:
age >= 18and the name starts with A - Row order does not matter
Hints
Hint 1
Combine the conditions with AND.
Hint 2
LIKE 'A%' matches text that starts with A (% stands for any run of characters).
Keywords
db
SQL
Run your code to see results
No results yet
Run your code to check it against the examples, or submit to run every test.