Pergunta de entrevista da empresa Health Catalyst

What SQL function will you use to see if and when a specific diagnosis was recorded for a patient?