Practice Select Statement (1.1) - SQL for Business Analysts - Business Analysis

Practice: Select Statement

Lesson 1.1SQL for Business Analysts

Practise this section

9 questions

Flashcard drill
4 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.
Write a SQL query to select all columns from the 'employees' table.
Show hintHide hint
Use SELECT and FROM clauses.
Question 2.
How would you filter to find orders with 'Shipped' status?
Show hintHide hint
Think about the WHERE clause.
3Question 3.
What SQL clause would you use to filter results?
- SELECT
- WHERE
- ORDER BY
- LIMIT
Show hintHide hint
Think about the purpose of each clause.
4Question 4.
True or False: The ORDER BY clause can sort results in either ascending or descending order.
- True
- False
Show hintHide hint
Consider how you can use ORDER BY in SQL.
Question 5.
You need to analyze user behavior by collecting login data for the past month. Write a SQL query that retrieves user IDs and counts their logins for that month, limited to users with more than 5 logins.
Show hintHide hint
Focus on filtering the date and counting occurrences.
Question 6.
You are tasked with finding the top 5 customers who have spent the most over the last year. Create the SQL query to retrieve each customer's ID and total spent amount.
Show hintHide hint
Remember to sum the amounts and sort top to bottom.

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