Skip to main content
All Problems
easy0% acceptance

Patients with Missing Phone Numbers

The contact center needs to identify patients whose phone number is missing. Return the first name, last name, and email of all patients where phone is NULL.

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