Kickstart 2020 with new opportunities! - 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

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,
• couple_name – the name of a given couple (consists of the names of both partners),
• min_price – the minimum starting price of the apartment that a given couple wants to take a look at.
• max_price – the maximum price the couple is willing to pay for an apartment, and
• pref_location – the location a given couple would be most interested in.

### Stuck? Here's a hint!

Type:

SELECT
*
FROM couples