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