Skills101
← All practice quizzes

Quiz: Filtering and Sorting

5 questionsNo time limitPass: 60%+10 XP on first pass

Get exactly the rows you need: ORDER BY, LIMIT, DISTINCT, LIKE patterns, IN, BETWEEN, IS NULL, CASE expressions and common functions — on one sample company database.

Log in to take the quiz

Free account · see your score, answers and explanations, earn XP

  1. Question 1

    Which finds names that START with "R"?

  2. Question 2

    What does WHERE dept_id = NULL return?

  3. Question 3

    salary BETWEEN 40000 AND 60000 includes a salary of 60000?

  4. Question 4

    Which removes duplicate values from the result?

  5. Question 5

    In WHERE city = 'Pune' OR city = 'Delhi' AND salary > 50000, which is evaluated first?