Mastering PostgreSQL Databases: From Basics to Advanced/

...

/

Quiz on SQL Basics

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