Hospital administration wants to review all completed visits from 2024 onward. Return the visit id, visit_date, and diagnosis for all visits with status 'completed' and visit_date on or after '2024-01-01'.
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