Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close
Medical Center database
Non primary-foreign key JOINs
Non-equi JOINs
Non-equi self JOINs
Summary
28. Exercise 3

Instruction

Here comes the last one!

Exercise

For each buyer with funds less than 8000, show their name together with the names of all paintings and sculptures that are outside of their price range.

Stuck? Here's a hint!

Type:

SELECT
  Buyer.Name,
  Item.Name
FROM Item
JOIN Buyer
  ON Item.Price > Buyer.Funds
  AND Buyer.Funds < 8000
  AND Item.Type IN ('sculpture', 'painting')