SQL Practice Set in PostgreSQL

Table of contents

1. 1. Warm up: Selecting from one table

   0/9

   Review the fundamentals of SQL. Practice using SELECT and WHERE to filter data.

   List of exercises Start now
   1. Introduction
      1. Introduction
      2. Get to know the cat table
   2. Exercises
      1. Kittens
      2. Young and old Ragdoll cats
      3. Which cats like to play with balls?
      4. The most bored cat
      5. Elder cats have some fun
      6. Adult cats that love teaser toys
      7. Congratulations

2. 2. Aggregation and grouping

   0/11

   Test your knowledge of GROUP BY and ORDER BY clauses.

   List of exercises Start now
   1. Introduction
      1. Introduction
      2. Get to know the games table
   2. Exercises
      1. Cost-effective games
      2. Average production cost of good games
      3. Revenue for recent good shooters
      4. Game production statistics by year
      5. Profitable games by type
      6. Gross profit by company
      7. Productions statistics
      8. Identify good games
      9. Congratulations

3. 3. JOINs

   0/32

   Practice using JOIN, LEFT JOIN, and non-equi JOIN. Check your skills of working with multiple tables.

   List of exercises Start now
   1. Introduction
      1. Introduction
   2. Exercises with artists, museums and their pieces of art
      1. Get to know the artist table
      2. Get to know the museum table
      3. Get to know the piece_of_art table
      4. Placement of pieces of art
      5. Works of artists from 19th century and later
      6. List all pieces of art
      7. Legacy of unknown artists
      8. Artists' productivity
   3. Exercises with the band members table
      1. Get to know the band_members table
      2. Bands' members and their leaders
      3. How many members does each band have?
   4. Exercises with tables of Japanese 100 Yen store
      1. Get to know the categories table
      2. Get to know the products table
      3. Tallying the products in each category
      4. Get to know the clients table
      5. Get to know the orders table
      6. All orders
      7. Get to know the order_items table
      8. Check a certain order
      9. Revenue for each order
      10. How much money did each client spend per category?
      11. Ranking categories by sales
      12. Who repurchased products?
   5. Exercises with employees, salaries and benefits
      1. Get to know the employee table
      2. Get to know the salgrade table
      3. Get to know the benefits table
      4. From rags to riches
      5. Salary category for each employee
      6. Benefits of one employee
      7. Benefit usage count
      8. Congratulations

4. 4. Subqueries

   0/15

   Verify your knowledge of subqueries. Practice simple and correlated subqueries.

   List of exercises Start now
   1. Introduction
      1. Introduction
      2. Get to know the orchestras table
      3. Get to know the concerts table
      4. Get to know the members table
   2. Exercises
      1. Good orchestras that are newer than the Chamber Orchestra
      2. Orchestras from cities visited in 2013
      3. Same number of members as the Musical Orchestra
      4. The average number of members in orchestra
      5. The biggest orchestras
   3. Correlated Subqueries
      1. Orchestras that played at home in 2003
      2. The wealthiest musicians
      3. The most experienced musicians
      4. Members who earn more than violinists
      5. German orchestras in Ukraine
      6. Congratulations

5. 5. SQL Challenge

   0/21

   Practice your SQL skills. Write SQL queries which combine SELECT, WHERE, JOIN, GROUP BY, HAVING, ORDER BY and subqueries.

   List of exercises Start now
   1. Introduction
      1. Introduction
   2. Challenge with artists
      1. Get to know the artist table
      2. Get to know the museum table
      3. Get to know the piece_of_art table
      4. Get to know the museum_loan table
      5. Pieces in American and Italian museums
      6. How many pieces does each museum have?
      7. National legacy of artists
      8. The most productive artist
      9. Museum loans
      10. Where are the works of each artist located?
   3. Challenge with orchestras
      1. Get to know the orchestras table
      2. Get to know the concerts table
      3. Get to know the members table
      4. Get to know the instruments table
      5. Instruments are expensive...
      6. Average ratings per country
      7. Best concerts for each orchestra
      8. Collecting specific information about instruments
      9. Usage of instruments
      10. Congratulations

Get the Certificate of Competency in SQL

This certificate will confirm your practical SQL problem-solving skills

Obtain the Certificate Learn more