Skip to main content
All Problems
easy0% acceptance

Visits That Had Abnormal Lab Results

Quality assurance wants to review visits where patients had abnormal lab results. Return distinct visit_id, visit_date, and diagnosis for visits that have at least one lab result where is_abnormal = 1. Order by visit_date.

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