Practice Filtering With Where (1.2) - SQL for Business Analysts

Practise this section

9 questions

Flashcard drill
3 cards from this section. Quick, good the night before a test.
Exercise
6 questions · about 4 min · pass mark 70%. Hints available.
Sign up to start the exercise
Quiz
3 questions · about 2 min · pass mark 70%. Hints available.
Sign up to start the quiz

6 sample questions

Question 1.
What does the WHERE clause do in SQL?
Show hintHide hint
Think about how it modifies the results of a query.
Question 2.
Write a SQL command to get all orders where order_status is 'Pending'.
Show hintHide hint
Remember the format of a basic SQL query.
3Question 3.
What does the WHERE clause do in a SQL query?
- A. It indicates which table to query.
- B. It filters records based on specified conditions.
- C. It sorts the resulting records.
Show hintHide hint
Think about what filtering means in data retrieval.
4Question 4.
True or False: The WHERE clause can only use the '=' operator.
- True
- False
Show hintHide hint
Consider the different ways we can compare values.
Question 5.
Create a SQL query that returns orders placed in 2023 that are either 'Pending' or 'Shipped' and have a total over $500.
Show hintHide hint
Combine multiple conditions and consider using BETWEEN for date ranges.
Question 6.
How would you retrieve a list of users who registered last year and have logged in more than 5 times?
Show hintHide hint
Combine date checks with a count condition.

5 more questions in this section. Enroll free to practise them all.