SELECT
"year",
SUM(CASE WHEN powertrain = 'BEV' THEN CAST(REPLACE(REPLACE("value", '.', ''), ',', '') AS DOUBLE) END) AS 'Sales Battery EV',
SUM(CASE WHEN powertrain = 'PHEV' THEN CAST(REPLACE(REPLACE("value", '.', ''), ',', '') AS DOUBLE) END) AS 'Sales PHEV',
SUM(CASE WHEN powertrain = 'FCEV' THEN CAST(REPLACE(REPLACE("value", '.', ''), ',', '') AS DOUBLE) END) AS 'Sales Full-cell EV'
FROM
@kaggle.willianoliveiragibin_ev_sales_2010_2024.iea_global_ev_data_2024_new
WHERE
"parameter" = 'EV sales' AND "mode" = 'Cars'
AND "year" BETWEEN 2010 AND 2025
AND CAST(REPLACE(REPLACE("value", '.', ''), ',', '') AS DOUBLE) < 100000004768618
GROUP BY
"year"
ORDER BY
"year" ASC