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...
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)
...