-
Notifications
You must be signed in to change notification settings - Fork 0
/
Analyze Process.sql
51 lines (41 loc) · 1.82 KB
/
Analyze Process.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
--Analyze Process
select member_casual, rideable_type, count(*) as total_trip
from `BikePortfolioProject.Cleaned_All_Data`
group by member_casual, rideable_type
order by member_casual, rideable_type;
select member_casual, month, count(ride_id) as total_trip
from `BikePortfolioProject.Cleaned_All_Data`
group by month, member_casual
order by member_casual ;
select member_casual, day_of_week, count(ride_id) as total_trip
from `BikePortfolioProject.Cleaned_All_Data`
group by day_of_week, member_casual
order by member_casual ;
select extract(hour from(started_at)) as hour_of_day, member_casual, count(ride_id) as total_trip
from `BikePortfolioProject.Cleaned_All_Data`
group by hour_of_day, member_casual
order by total_trip desc;
select month, member_casual, round(avg(ride_length),2) as ride_length_duration
from `BikePortfolioProject.Cleaned_All_Data`
group by month, member_casual
order by member_casual;
select day_of_week, member_casual, round(avg(ride_length),2) as ride_length_duration
from `BikePortfolioProject.Cleaned_All_Data`
group by day_of_week, member_casual
order by member_casual;
select extract(hour from(started_at)) as hour_of_day, member_casual, round(avg(ride_length),2) as ride_length_duration
from `BikePortfolioProject.Cleaned_All_Data`
group by hour_of_day, member_casual
order by member_casual;
select start_station_name, member_casual,
avg(start_lat) as start_lat, avg(start_lng) as start_lng,
count(ride_id) as total_trips
from `BikePortfolioProject.Cleaned_All_Data`
group by start_station_name, member_casual
order by total_trips desc;
select end_station_name, member_casual,
avg(end_lat) as end_lat, avg(end_lng) as end_lng,
count(ride_id) as total_trips
from `BikePortfolioProject.Cleaned_All_Data`
group by end_station_name, member_casual
order by total_trips desc;