Adapted work
These pages and exercises are adapted from other people's work, under the license of the original. Each one names its source and says it was changed. See credits.
Pages
- Constraints (Apache-2.0)
- COUNT and NULL (CC-BY-SA-4.0)
- Name the step with WITH (Apache-2.0)
- GROUP BY and HAVING (CC-BY-SA-4.0)
- A share needs a numerator and a denominator (CC-BY-SA-4.0)
- Upsert in one statement (Apache-2.0)
Exercises
- Bookings per facility (CC-BY-SA-4.0; selectstarsql.com longtail.md (Zi Chong Kao))
- Busy facilities (CC-BY-SA-4.0; selectstarsql.com longtail.md (Zi Chong Kao))
- Count every member (CC-BY-SA-4.0; selectstarsql.com innocence.md (Zi Chong Kao))
- COUNT skips NULL (CC-BY-SA-4.0; selectstarsql.com innocence.md (Zi Chong Kao))
- Share of bookings with guests (CC-BY-SA-4.0; selectstarsql.com innocence.md (Zi Chong Kao))
- Two counts in one query (CC-BY-SA-4.0; selectstarsql.com innocence.md (Zi Chong Kao))
- Classify facilities by upkeep (CC-BY-SA-3.0; pgexercises.com questions basic/classify (Alisdair Owens))
- Format member names (CC-BY-SA-3.0; pgexercises.com questions strings/concat (Alisdair Owens))
- Facilities with many slots booked (CC-BY-SA-3.0; pgexercises.com questions aggregates/fachours1a (Alisdair Owens))
- Members per surname initial (CC-BY-SA-3.0; pgexercises.com questions strings/substr (Alisdair Owens))
- Add a facility (CC-BY-SA-3.0; pgexercises.com questions updates/insert (Alisdair Owens))
- Facilities with Wall in the name (CC-BY-SA-3.0; pgexercises.com questions basic/where3 (Alisdair Owens))
- Bookings per month (CC-BY-SA-3.0; pgexercises.com questions date/bookingspermonth (Alisdair Owens))
- Recommendations made by each member (CC-BY-SA-3.0; pgexercises.com questions aggregates/count3 (Alisdair Owens))
- Members who have recommended someone (CC-BY-SA-3.0; pgexercises.com questions joins/self (Alisdair Owens))
- Slots booked per facility (CC-BY-SA-3.0; pgexercises.com questions aggregates/fachours (Alisdair Owens))
- Count a visit (Apache-2.0; xataio/learn-postgres lessons/02-changing-data/03-upsert/lesson.mdx)