Quality assurance wants to know the percentage of lab results that are abnormal. Return a single row with the total count, the abnormal count, and the abnormal percentage rounded to one decimal place.
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