PostgreSQL JOINs

6/21 JOIN and filtering

Good start! Of course, in JOIN queries we can use WHERE to filter results as in other queries.

SELECT
  full_name,
  name
FROM position
JOIN employee
  ON position.id = employee.position_id
WHERE employee.start_year > 2016

Here we select full name and position name of employees who were hired after 2016.

Show the name of each author together with the title of the book they wrote and the year in which that book was published.

Show only books published after 2005.

Type:

SELECT
  name,
  title,
  publish_year
FROM author
JOIN book
  ON author.id = book.author_id
WHERE publish_year > 2005

Instruction