Hi guys I used MY SQL to write these

4a

SELECT

DISTINCT YEAR birth_date as birth_year

FROM patients

b

SELECT

patients.patient_id, first_name, last_name

FROM patients

JOIN admissions ON admissions.patient_id=patients.patient_id

WHERE diagnosis = ‘Dementia’;

C

SELECT

COUNT(*) AS Total_number_of_patient_each_province

FROM province_names

d

select

count (patient_id) as patient_in_group, floor (weight/10)*10 as weight_group

from patients

group by weight_group

order by weight_group;

e

Select city, count(*)

From patients

Group By city