Practice Summary Table (5) - SQL for Business Analysts

Practise this section

10 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
4 questions · about 3 min · pass mark 70%. Hints available.
Sign up to start the quiz

6 sample questions

Question 1.
What SQL command would you use to select all columns from the 'products' table?
Show hintHide hint
Remember, `*` means all columns.
Question 2.
How would you filter orders that are pending?
Show hintHide hint
Think about adding a WHERE clause.
3Question 3.
What SQL command retrieves data from a table?
- UPDATE
- SELECT
- DELETE
Show hintHide hint
Think about the purpose of the command.
4Question 4.
True or False: The WHERE clause is used to filter results.
- True
- False
Show hintHide hint
Recall what WHERE does in a query.
Question 5.
Write a query that retrieves the total number of orders and groups them by customer ID, then filter so only customers with more than 2 orders are shown.
Show hintHide hint
Combine COUNT with GROUP BY and HAVING.
Question 6.
Construct a SQL statement to find product IDs and their associated sales, including those with zero sales using appropriate joins.
Show hintHide hint
Use a LEFT JOIN to include all products.

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