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

Instruction

Okay, let's try some exercises!

Exercise

For every couple that wants an apartment, show their name together with the IDs of all apartments within their price range.

Stuck? Here's a hint!

Type: 

SELECT
  Couples.CoupleName,
  Apartments.Id
FROM Couples
JOIN Apartments
  ON Apartments.Price BETWEEN Couples.MinPrice AND Couples.MaxPrice