SQL Basics

Preview — 3 of 10 questions

Which query retrieves all columns from a users table?

javascript

-- Which of these is correct?

AFETCH * FROM users

BSELECT * FROM users

CSELECT ALL users

DGET * FROM users

Which query returns all users whose age is greater than 25?

javascript

SELECT * FROM users WHERE ???

AWHERE age >> 25

BWHERE age GREATER 25

CWHERE age > 25

DWHERE age => 25

How do you retrieve users sorted by last_name in alphabetical (ascending) order?

javascript

SELECT * FROM users
ORDER BY last_name ASC;   -- alphabetical order

-- ASC is default, so this is equivalent:
SELECT * FROM users
ORDER BY last_name;

ASELECT * FROM users SORT BY last_name

BSELECT * FROM users ORDER BY last_name DESC

CSELECT * FROM users ORDER BY last_name ASC

DSELECT * FROM users ORDER last_name

Answer all 10 questions (7 more), see explanations for every answer, and track your score.