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

Cool! We have a list of nice and cozy apartments. Let's take a look at the table that contains information about the lovely couples who want to rent one!

Exercise

Select all data from the Couples table.

As you can see, it has five columns:

  • Id – the ID of a given couple,
  • CoupleName – the name of a given couple (consists of the names of both partners),
  • MinPrice – the minimum starting price of the apartment that a given couple wants to take a look at.
  • MaxPrice – the maximum price the couple is willing to pay for an apartment, and
  • PrefLocation – the location a given couple would be most interested in.

Stuck? Here's a hint!

Type: 

SELECT
  *
FROM Couples