Analyzing Electric Vehicle Charging Habits

This is the third project I’ve gone through, SQL again. This one was all about charging habits, specifically as it pertains to shared charging stations at apartment buildings. For reminders I wrote down when submitting the project and getting errors: 1. Read the directions. This will avoid confusion. 2. Read your code and make sure everything is spelled correctly. This will also avoid confusion. 3. When using an aggregate function like AVG( ), any columns in SELECT statements that are not part of an aggregate function must be included in the GROUP BY clause. 4. If you’re using ORDER BY, you need to GROUP BY the columns that are not in an aggregate function. 5. When using an aggregate function, you need to use HAVING if you are trying to filter by that aggregate function. WHERE clauses can’t filter an aggregate function.

Questions that needed to be answered in this project:

• Unique users in each garage

• The popular start times in shared garages

• Users that used the shared charging stations for a long period of time, specifically 10+ hours