1SELECT 
2    "year",
3    SUM(CASE WHEN powertrain = 'BEV' THEN CAST(REPLACE(REPLACE("value", '.', ''), ',', '') AS DOUBLE) END) AS 'Sales Battery EV',
4    SUM(CASE WHEN powertrain = 'PHEV' THEN CAST(REPLACE(REPLACE("value", '.', ''), ',', '') AS DOUBLE) END) AS 'Sales PHEV',
5    SUM(CASE WHEN powertrain = 'FCEV' THEN CAST(REPLACE(REPLACE("value", '.', ''), ',', '') AS DOUBLE) END) AS 'Sales Full-cell EV'
6FROM 
7    @kaggle.willianoliveiragibin_ev_sales_2010_2024.iea_global_ev_data_2024_new
8WHERE 
9    "parameter" = 'EV sales' AND "mode" = 'Cars'
10    AND "year" BETWEEN 2010 AND 2025
11    AND CAST(REPLACE(REPLACE("value", '.', ''), ',', '') AS DOUBLE) < 100000004768618
12GROUP BY 
13    "year"
14ORDER BY 
15    "year" ASC