Baselight
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
yearSales Battery EVSales PHEVSales Full-cell EV
2010162771103101
20119779718796152
2012147215138577118
2013278034232124176
2014490057320407246
20158002426107821747
201610844897629455089
2017174049010797917577
2018312794316002319440
20193660719150387416149
202013356170701510045929
2021300090951340832997931
2022465082471937604993302
2023605943102766367055139
20256351000020963800298244

Share link

Anyone who has the link will be able to view this.