PostgreSQL JOINs

What you get?

Fully interactive online courses. Just you, SQL, Python, R and the web browser.

Instant access to lessons. You decide when and how long you want to learn.

Hundreds of SQL, Python, R exercises to master Your skills.

Course completion certificate to show the world that you really can!

Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

20/21 Exercise 3

1. Introduction

2. Get to know the author table

3. Get to know the book table

4. Get to know the adaptation table

5. JOINs – recap

6. JOIN and filtering

7. JOINS – ambiguous columns

13. Filtering with JOINs

14. Filtering with JOINS – continued

15. ON and WHERE conditions

Amazing! Only one more to go. Keep it up!

Show all information only for those items that weren't auctioned off.

Type:

SELECT *
FROM auction_item
LEFT JOIN bidder
  ON auction_item.id = bidder.bought_item_id
WHERE bidder.bought_item_id IS NULL

Our website uses cookies. By using this website, you agree to their use in accordance with the browser settings.You can modify your browser settings on your own. For more information see our Privacy Policy.

Instruction

Exercise

Stuck? Here's a hint!

Need assistance?

login:
password:
Remember me on this computer

Recipient's Name:
Recipient's Email:
Your Message (Optional):

Create a free accountand start learning now!

What you get?

Sign upand join a company account!

Log in

Your registration has been successfully finished

Wrap course as a gift

Instruction

Exercise

Stuck? Here's a hint!

Need assistance?