Skip to main content
All Problems
medium0% acceptance

Visits Without Any Prescriptions (NOT EXISTS)

Find all completed visits that did not result in any prescriptions. Use NOT EXISTS. Return visit_id, visit_date, patient_id, and diagnosis. Order by visit_date descending.

Schema

🔑idINT
🔗patient_idINT
🔗doctor_idINT
visit_dateTEXT
diagnosisTEXT
notesTEXTNULL
follow_up_dateTEXTNULL
statusTEXT
postgresql

Run your query to see results

Press Ctrl + Enter to execute