Skip to main content
All Problems
medium0% acceptance

Doctors Who Treated Every Blood Type

Find doctors who have treated patients of every blood type. Return the doctor's first name, last name, and the number of distinct blood types treated. Only include doctors whose distinct blood type count equals the total number of distinct blood types in the patients table.

Schema

🔑idINT
first_nameTEXT
last_nameTEXT
date_of_birthTEXT
genderTEXT
emailTEXT
phoneTEXTNULL
blood_typeTEXT
cityTEXT
stateTEXT
🔗insurance_idINTNULL
created_atTIMESTAMP
postgresql

Run your query to see results

Press Ctrl + Enter to execute