Cyclistic Bikes: Members Vs. Casual Riders
Capstone project for Google Data Analytics Certificate
@kaggle.rachelcam17_cyclistic_bikes_members_vs_casual_riders
Capstone project for Google Data Analytics Certificate
@kaggle.rachelcam17_cyclistic_bikes_members_vs_casual_riders
CREATE TABLE clean_divvy_trips_2020_q1 (
"ride_id" VARCHAR,
"rideable_type" VARCHAR,
"started_at" TIMESTAMP,
"ended_at" TIMESTAMP,
"start_station_name" VARCHAR,
"start_station_id" BIGINT,
"end_station_name" VARCHAR,
"end_station_id" BIGINT,
"start_lat" DOUBLE,
"start_lng" DOUBLE,
"end_lat" DOUBLE,
"end_lng" DOUBLE,
"member_casual" VARCHAR,
"ride_length" VARCHAR,
"day_of_week" BIGINT,
"mean_of_ride_length" VARCHAR,
"max_ride_length" VARCHAR,
"unique_members" VARCHAR,
"avg_ride_length" VARCHAR
);
CREATE TABLE clean_divvy_trips_2019_q1 (
"trip_id" BIGINT,
"start_time" TIMESTAMP,
"end_time" TIMESTAMP,
"bikeid" BIGINT,
"tripduration" BIGINT,
"from_station_id" BIGINT,
"from_station_name" VARCHAR,
"to_station_id" BIGINT,
"to_station_name" VARCHAR,
"usertype" VARCHAR,
"gender" VARCHAR,
"birthyear" DOUBLE,
"ride_length" VARCHAR,
"day_of_week" BIGINT,
"mean_of_ride_length" VARCHAR
);
Anyone who has the link will be able to view this.