Skip to main content
All Problems
medium0% acceptance

Overdue Bills with Patient Contact Info

Collections needs contact info for overdue accounts. Find all billing records with status 'overdue'. Return patient full name, email, phone, billing amount, and patient_responsibility. Order by patient_responsibility descending.

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