Retrieve columns: patient_id, attending_doctor_id and diagnosis for admissions meeting one of the following two criteria: A. patient_id is odd and attending_doctor_id is 1, 5 or 19. B. attending_doctor_id contains the digit 2 and patient_id has 3 digits.
Expected Output
Query Editor
User Output Ready
Execute a query or press Ctrl+Enter to view results...
Databases & Questions
Hint
Two separate criteria joined by OR. Numbers must be cast to text before string functions can be used on them.