79118942

Date: 2024-10-23 16:58:39
Score: 0.5
Natty:
Report link

Try

SELECT 
    string, 
    CASE 
        WHEN COUNT(*) = 0 THEN 0  -- Handle division by zero
        ELSE (SUM(CASE WHEN adm = 2 THEN 1 ELSE 0 END)::decimal / COUNT(*)) * 100 
    END AS perc_adm
FROM 
    your_table
GROUP BY 
    string;
Reasons:
  • Low length (0.5):
  • Has code block (-0.5):
  • Low reputation (0.5):
Posted by: SubrataG