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

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

JOINs in MS SQL Server

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')