<invoke name="query_sql"> <parameter name="sql">SELECT COUNT(*) AS n, SUM(CASE WHEN Surface IS NULL OR TRIM(Surface)='' THEN 1 ELSE 0 END) AS blank_surface, SUM(CASE WHEN Date LIKE '%‑%' THEN 1 ELSE 0 END) AS date_nonbreaking_hyphen, SUM(CASE WHEN Date NOT LIKE '%‑%' AND Date NOT LIKE '%-%' THEN 1 ELSE 0 END) AS date_other_format, SUM(CASE WHEN Time IS NULL OR TRIM(Time)='' THEN 1 ELSE 0 END) AS blank_time, SUM(CASE WHEN Score LIKE '%nbsp%' THEN 1 ELSE 0 END) AS score_nbsp, SUM(CASE WHEN Score IN ('Walkover','W/O') OR Score ILIKE '%ret%' OR Score ILIKE '%def%' THEN 1 ELSE 0 END) AS score_incomplete, SUM(CASE WHEN SP IS NOT NULL AND SP > TP THEN 1 ELSE 0 END) AS sp_gt_tp, SUM(CASE WHEN SP IS NOT NULL AND ABS(SP-(1SP+2SP))>0 THEN 1 ELSE 0 END) AS sp_ne_1sp_plus_2sp, SUM(CASE WHEN Aces > SP THEN 1 ELSE 0 END) AS aces_gt_sp, SUM(CASE WHEN DFs > SP THEN 1 ELSE 0 END) AS dfs_gt_sp, SUM(CASE WHEN TP=0 OR SP=0 THEN 1 ELSE 0 END) AS zero_points, SUM(CASE WHEN Rk=vRk THEN 1 ELSE 0 END) AS rk_eq_vrk, SUM(CASE WHEN Aces>40 THEN 1 ELSE 0 END) AS aces_gt40, SUM(CASE WHEN TP>300 THEN 1 ELSE 0 END) AS tp_gt300, SUM(CASE WHEN TP<20 THEN 1 ELSE 0 END) AS tp_lt20 FROM raw.raw_kaggle</parameter> <parameter name="purpose">Profile impossible values and format problems in raw_kaggle</parameter> </invoke>