Save up to $499! Grab all Python courses for $49 or all online courses we’ve ever launched for only $169. Only Feb 11-16. Happy Valentine's!
Medical Center database
Non primary-foreign key JOINs
Non-equi JOINs
Non-equi self JOINs
Summary

Instruction

Okay, let's start with something simple.

Exercise

Show the name of every buyer together with the name of every item that they can afford.

Stuck? Here's a hint!

Type:

SELECT
  buyer.name,
  item.name
FROM item
JOIN buyer
  ON item.price <= buyer.funds