Skip to main content

Posts

Showing posts from November, 2023

SQL analysis with Electric_Vehicle_Population_Data

This dataset shows the Battery Electric Vehicles (BEVs) and Plug-in Hybrid Electric Vehicles (PHEVs) that are currently registered through Washington State Department. You can get through the dataset through  Dataset - Catalog Based on the Dataset we will answer the following questions. No of Ev's for BMW and TESLA? Each state and each city no of Ev's? Which year has the most EV sales? Which company has manufactured the highest ev? Which model has sold for each brand and how many ev? How many companies make both EV type? Which company has manufactured most PHEV type vehicles? Each year which company has make the most of EV with count. 1. No of Ev's for BMW and TESLA? SELECT MAKE, COUNT(*)  FROM EV_DATA WHERE MAKE IN ('BMW','TESLA') GROUP BY MAKE 2.Each state and each city no of Ev's? SELECT STATE,CITY,COUNT(*) FROM EV_DATA  GROUP BY STATE,CITY 3.Which year has the most EV sales? SELECT TOP 1 MODEL_YEAR,COUNT(*) AS CNT FROM EV_DATA GROUP BY MODEL_YEAR ORD...