Quiz on SQL Basics
This quiz will test your knowledge on some key topics related to SQL basics, including queries, joins, indexes, and more.
We'll cover the following...
Missing Cards - Horizontal
1. Complete the SQL query below to select the first 10 rows from the "Sales" table.
All Cards
1
2
3
4
Missing Cards
(Drag and drop the cards in the blank spaces)
Missing Cards - Horizontal
2. Complete the SQL query below to sort the results of a query in ascending order.
All Cards
1
2
3
4
Missing Cards
(Drag and drop the cards in the blank spaces)
Missing Cards - Horizontal
3. Complete the SQL query below to sort the rows in the "Employee" table in descending order of their salary.
All Cards
1
2
3
4
Missing Cards
(Drag and drop the cards in the blank spaces)
Missing Cards - Horizontal
4. Complete the SQL query below to find the names from the "Employee" table containing the letter 'A.'
All Cards
1
2
3
4
Missing Cards
(Drag and drop the cards in the blank spaces)
Missing Cards - Horizontal
5. Complete the SQL query below to count the rows in the "Product" table.
All Cards
1
2
3
4
Missing Cards
(Drag and drop the cards in the blank spaces)
Missing Cards - Horizontal
6. Complete the SQL query below to select unique values for the "salary" column in the "Employee" table.
All Cards
1
2
3
4
Missing Cards
(Drag and drop the cards in the blank spaces)
Missing Cards - Horizontal
7. Complete the SQL query below to insert a row into the "Sales" table.
All Cards
1
2
3
4
Missing Cards
(Drag and drop the cards in the blank spaces)
Missing Cards - Horizontal
8. Complete the SQL query below to delete products from the "Product" table with prices greater than 100.
All Cards
1
2
3
Missing Cards
(Drag and drop the cards in the blank spaces)
...