Welcome to PostgreSQL Exercises! This site was born when I noticed that there's a load of material out there to help people learn about SQL, but not a great deal to make it easy to learn by doing. PGExercises provides a series of questions and explanations built on a single, simple dataset.

PostgreSQL questions and answers on a single dataset - GitHub - ozencb/postgresql-exercises: PostgreSQL questions and answers on a single dataset

October 30, 2025 - The best way to learn PostgreSQL is through practice. This section is for beginners to intermediate users to enhance their SQL skills with exercises.

This is a compilation of all the questions and answers on Alisdair Owen's PostgreSQL Exercises. Keep in mind that actually solving these problems will make you go further than just skimming through this guide, so make sure to pay PostgreSQL Exercises a visit. ... Produce a timestamp for 1 a.m. on the 31st of August 2012 ... It's pretty simple to get going with ...

Provide the delete statement as answer for this exercise. Validation - Get count of all published courses by author and make sure output is sorted in descending order by count. SELECT course_author, count(1) AS course_count FROM courses WHERE course_status= 'published' GROUP BY course_author · Here are some of the exercises for which you can write SQL queries to self evaluate.

The exercises are a mix of "multiple choice" and "fill in the blanks" questions. There are between 3 and 9 questions in each category. The answer can be found in the corresponding tutorial chapter.

We have gathered a variety of PostgreSQL exercises (with answers) for each PostgreSQL Chapter.

July 23, 2025 - This collection of 50 PostgreSQL exercises offers a comprehensive set of questions designed to challenge and enhance our SQL skills. Covering a wide range of topics, from basic queries to advanced database management techniques, these exercises ...

How can you output a list of all members, including the individual who recommended them (if any), without using any joins? Ensure that there are no duplicates in the list, and that each firstname + surname pairing is formatted as a column and ordered. SELECT DISTINCT mems.firstname || ' ' || mems.surname as member, ( SELECT recs.firstname || ' ' || recs.surname as recommender FROM cd.members recs WHERE recs.memid = mems.recommendedby ) FROM cd.members mems ORDER BY member; The Produce a list of costly bookings exercise contained some messy logic: we had to calculate the booking cost in both the WHERE clause and the CASE statement.

Improve your SQL database programming skills with 18 PostgreSQL practice exercises for beginners.

My answer to PostgreSQL Exercises (https://pgexercises.com/) Raw · PostgreSQL-Exercises.md · PostgreSQL Exercises · CREATE TABLE bookings ( bookid integer NOT NULL, facid integer NOT NULL, memid integer NOT NULL, starttime timestamp without time zone NOT NULL, slots integer NOT NULL ); CREATE TABLE facilities ( facid integer NOT NULL, name character varying(100) NOT NULL, membercost numeric NOT NULL, guestcost numeric NOT NULL, initialoutlay numeric NOT NULL, monthlymaintenance numeric NOT NULL ); CREATE TABLE members ( memid integer NOT NULL, surname character varying(200) NOT NULL, firstname character varying(200) NOT NULL, address character varying(300) NOT NULL, zipcode integer NOT NULL, telephone character varying(20) NOT NULL, recommendedby integer, joindate timestamp without time zone NOT NULL ); How can you retrieve all the information from the cd.facilities table?

PostgreSQL questions and answers on a single dataset - postgresql-exercises/README.md at master · ozencb/postgresql-exercises

Sample solutions to exercises can be found here: https://gist.github.com/kjs222/5169a292d87d1774832b7160f7ba2b49

Solidify your knowledge of using PostgreSQL queries! This online practice set is dedicated to users who know SQL basics.

Improve your SQL database programming skills with 18 PostgreSQL practice exercises for beginners. ... Prepare for your SQL job interview by reviewing GROUP BY questions and how to answer them.

Copyright © 1996-2026 The PostgreSQL Global Development Group

This online practice set consists of 88 interactive exercises. You will practice using simple statements and clauses, like SELECT or JOIN, as well as more advanced concepts, such as subqueries. 4.73 ★★★★★ ★★★★★ (1578 ratings) ... Use SELECT and WHERE to filter data. Aggregate and group data using clauses. Join multiple tables. Work with complicated subqueries. Use PostgreSQL functions in practice.

Solutions to the PostgreSQL Exercises. This project aims to be consistent with the Mozilla SQL Style Guide.

🌟 Here, you'll find my solutions to a series of SQL challenges designed to sharpen my skills in relational databases and PostgreSQL. These exercises are taken from PGExercises, a fantastic platform to practice and improve SQL proficiency through real-world datasets. ... ✅ Solutions to SQL queries, from basic SELECT and WHERE clauses to advanced concepts like JOINs, WINDOW functions, aggregations, and recursive queries. 🗂️ Well-structured queries that adhere to industry standards and are optimized for performance. 🧠 Insightful comments within each query file, explaining the logic and approach.