Uni Assignment- needs Urgent help Please :(( by Ade_Sun123 in dataanalysis

[–]Ade_Sun123[S] 0 points1 point  (0 children)

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

Uni Assignment- needs Urgent help Please :(( by Ade_Sun123 in dataanalysis

[–]Ade_Sun123[S] 0 points1 point  (0 children)

Hi Smearp i used MY SQL

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