Query Help above my knowledge

1

I am still in the basics and have a problem. I have table Patients.

I need to display the following based on patient.birthdate, patient.sex
if the patient is 16yo or older and Male then = 1
if the patient is 16yo or older and female = 2
if the patient is less than 16yo and male = M
if patient is less than 16 yo and Female = F
as sex

thank you
sb

2 
SELECT *, CASE Sex
WHEN 'Male' THEN CASE
	WHEN DATEADD(YEAR, 16, birthdate)>=CAST(GETDATE() AS date) 
		THEN 'M' ELSE '1' END
WHEN 'Female' THEN CASE
	WHEN DATEADD(YEAR, 16, birthdate)>=CAST(GETDATE() AS date) 
		THEN 'F' ELSE '2' END
END AS Sex
FROM patients
1 Like
3

Thank you so much.