Practice Identify Top-selling Products (4.1)

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 SQL command is used to select data from a database?
Show hintHide hint
It's the first keyword in a SQL query.
Question 2.
How would you limit results to only show 10 items?
Show hintHide hint
This clause comes at the end of your query.
3Question 3.
What is the purpose of the COUNT function in SQL?
- Count sales
- Count rows
- Count products
Show hintHide hint
Think about what you'd want to summarize when querying a database.
4Question 4.
True or False: The ORDER BY clause is optional in a SQL query.
- True
- False
Show hintHide hint
Consider if you always want sorted results.
Question 5.
Given a table with product sales data, write a query to find products that sold more than 100 units, displaying the product ID and the total sold.
Show hintHide hint
You'll need to use COUNT and GROUP BY while filtering the results.
Question 6.
Create a SQL query to determine how many different products were sold, considering only those with sales data in the last quarter.
Show hintHide hint
Focus on distinct counts and the date range filter.

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