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...
1. Complete the SQL query below to select the first 10 rows from the "Sales" table.

Drag and drop the cards in the blank spaces.

2. Complete the SQL query below to sort the results of a query in ascending order.

Drag and drop the cards in the blank spaces.

3. Complete the SQL query below to sort the rows in the "Employee" table in descending order of their salary.

Drag and drop the cards in the blank spaces.

4. Complete the SQL query below to find the names from the "Employee" table containing the letter 'A.'

Drag and drop the cards in the blank spaces.

5. Complete the SQL query below to count the rows in the "Product" table.

Drag and drop the cards in the blank spaces.

6. Complete the SQL query below to select unique values for the "salary" column in the "Employee" table.

Drag and drop the cards in the blank spaces.

7. Complete the SQL query below to insert a row into the "Sales" table.

Drag and drop the cards in the blank spaces.

8. Complete the SQL query below to delete products from the "Product" table with prices greater than 100.

Drag and drop the cards in the blank spaces.

...