Medical Center database
4. Get to know the treatment table
Non primary-foreign key JOINs
Non-equi JOINs
Non-equi self JOINs
Summary

## Instruction

Great! Here comes the last table for now. Let's get to know some treatment types.

## Exercise

Select all data from the treatment table. As you can see, it has only four columns:

• id – the ID of a given treatment,
• name – the name of a given treatment,
• price – the price of a given treatment, and
• type – the type of a given treatment.

### Stuck? Here's a hint!

Type:

SELECT
*
FROM treatment


Code editor

TableConsole