1. Select All
Easy

A quick introduction to how SELECT * can be used to query all the data from a table.

Solve
2. Select One
Easy

A quick introduction on how to project a particular attribute using the SELECT syntax.

Solve
3. Find Biology Teacher
Easy

A quick introduction on how to filter results using the WHERE clause.

Solve
4. Find Same Name
Easy

A quick introduction on how to use JOIN to combine multiple tables.

Solve
5. Average Teacher Age
Easy

A quick introduction to aggregation functionality.

Solve
6. Average Age in Departments
Easy

A quick introduction to GROUP BY functionality.

Solve
7. Student Teacher Union
Easy

A quick introduction to set operations.

Solve
8. Add New Student
Easy

A quick introduction to INSERT syntax.

Solve
9. Retiring Teacher
Easy

A quick introduction to DELETE syntax.

Solve