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