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

Instruction

Good! How about filtering our query?

Exercise

For every buyer that has funds greater than 10 000, show the name of the buyer and the names of the items they can afford that are not of the 'painting' type.

Stuck? Here's a hint!

Type:

SELECT
  B.Name,
  I.Name
FROM Item I
JOIN Buyer B
  ON I.Price <= B.Funds
WHERE I.Type != 'painting'
  AND B.Funds > 10000