<invoke name="query_sql"> <parameter name="sql">SELECT CASE WHEN lower(replace(trim(AI_Tool),' ','')) IN ('chatgpt') THEN 'ChatGPT' WHEN lower(trim(AI_Tool)) IN ('microsoft copilot','copilot') THEN 'Microsoft Copilot' WHEN lower(trim(AI_Tool)) IN ('google gemini','gemini') THEN 'Google Gemini' WHEN lower(trim(AI_Tool))='claude' THEN 'Claude' WHEN AI_Tool IS NULL OR trim(AI_Tool)='' THEN 'Unspecified' ELSE trim(AI_Tool) END AS AI_Tool_clean, COUNT(*) AS users, ROUND(AVG(Productivity_Score),2) AS avg_productivity, ROUND(MEDIAN(Productivity_Score),2) AS median_productivity, ROUND(AVG(Satisfaction_Score),2) AS avg_satisfaction FROM raw.AI_Usage_and_Impact_on_Students_and_Professionals GROUP BY 1 ORDER BY avg_productivity DESC</parameter> <parameter name="purpose">Productivity score by AI tool after merging spelling variants</parameter> <parameter name="source">raw</parameter> </invoke>