Skip to main content
All Problems
medium0% acceptance

Patients with Visits but No Lab Results

Find patients who have had visits but never had any lab results. Use EXCEPT to find patient IDs with visits but not in lab_results. Return first_name, last_name. Order by last_name.

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