A clinical review board needs all abnormal lab results from 2024 onward. Return the test_name, result_value, unit, and tested_at for abnormal results tested on or after '2024-01-01', ordered by tested_at descending.
Schema
🔑idINT
🔗visit_idINT
test_nameTEXT
result_valueTEXT
unitTEXT
reference_rangeTEXT
is_abnormalINT
tested_atTEXT
postgresql
Run your query to see results
Press Ctrl + Enter to execute