040.sql

/* Q: Display patient's full name, height in the units feet rounded to 1 decimal, weight in the unit pounds rounded to 0 decimals, birth_date, gender non abbreviated.

Convert CM to feet by dividing by 30.48.
Convert KG to pounds by multiplying by 2.205.

Table Info: patients

+--------------+----------+
| Column Name  | Type     |
+--------------+----------+
| patient_id   | INT      |
| first_name   | TEXT     |
| last_name    | TEXT     |
| gender       | CHAR(1)  |
| birth_date   | DATE     |
| city         | TEXT     |
| province_id  | CHAR(2)  |
| allergies    | TEXT     |
| height       | INT      |
| weight       | INT      |
+--------------+----------+

*/

-- SOLUTION:

select 
	concat(first_name, ' ', last_name) as patient_name,
    round(height/30.48,1) as 'height "Feet"',
    round(weight*2.205,0) as 'weight "Pounds"',
    birth_date,
    case
    	when gender = 'M' then 'MALE'
    	else 'FEMALE'
    end as gender_type
from patients;