SELECT system_id, SUM(CASE WHEN ((cyl_type = 1) AND (check_net - 14200) = 0) OR ((cyl_type = 2) AND (check_net - 19000) = 0) THEN 1 ELSE 0 END) AS nil_var, SUM(CASE WHEN ((cyl_type = 1) AND (check_net - 14200) > 0 AND (check_net - 14200) <= 50) OR ((cyl_type = 1) AND (check_net - 14200) < 0 AND (check_net - 14200) >= -50) OR ((cyl_type = 2) AND (check_net - 19000) > 0 AND (check_net - 19000) <= 50) OR ((cyl_type = 2) AND (check_net - 19000) < 0 AND (check_net - 19000) >= -50) THEN 1 ELSE 0 END) AS zero_fifty, SUM(CASE WHEN ((cyl_type = 1) AND (check_net - 14200) > 50 AND (check_net - 14200) <= 100) OR ((cyl_type = 1) AND (check_net - 14200) < -50 AND (check_net - 14200) >= -100) OR ((cyl_type = 2) AND (check_net - 19000) > 50 AND (check_net - 19000) <= 100) OR ((cyl_type = 2) AND (check_net - 19000) < -50 AND (check_net - 19000) >= -100) THEN 1 ELSE 0 END) AS fifty_hundred, SUM(CASE WHEN ((cyl_type = 1) AND (check_net - 14200) > 100 AND (check_net - 14200) <= 200) OR ((cyl_type = 1) AND (check_net - 14200) < -100 AND (check_net - 14200) >= -200) OR ((cyl_type = 2) AND (check_net - 19000) > 100 AND (check_net - 14200) <= 200) OR ((cyl_type = 2) AND (check_net - 19000) < -100 AND (check_net - 14200) >= -200) THEN 1 ELSE 0 END) AS hundred_plus, SUM(CASE WHEN ((check_net - 14200) >= -200 AND (check_net - 14200) <= 200) THEN (check_net - 14200) WHEN ((check_net - 14200) < -200) THEN -200 WHEN ((check_net - 14200) > 200) THEN 200 ELSE 0 END)/(COUNT(production_log_id)) AS average, COUNT(production_log_id) AS count, STDDEV_POP(CASE WHEN ((check_net - 14200) >= -200 AND (check_net - 14200) <= 200) THEN (check_net - 14200) WHEN ((check_net - 14200) < -200) THEN -200 WHEN ((check_net - 14200) > 200) THEN 200 ELSE 0 END) AS stddev FROM production_data WHERE process_date BETWEEN '2025-02-07 06:00:00' AND '2025-02-07 23:59:59.999' AND system_id IN (1, 2) AND process_id IN (2, 22) AND cyl_type IN (1, 2) AND process_status IN (0, 1040, 2064) GROUP BY system_id ORDER BY system_id ASC;

PRODASH