Question: sqlite > . open CTA _ L _ daily _ ridership.db sqlite > . schema CREATE TABLE [ Stations ] ( [ Station _ ID
sqliteopen CTALdailyridership.db
sqliteschema
CREATE TABLE Stations
StationID INT NOT NULL,
StationName TEXT NOT NULL,
PRIMARY KEY StationID ASC
;
CREATE TABLE Ridership
StationID INT NOT NULL,
RideDate TEXT NOT NULL,
TypeofDay TEXT NOT NULL,
NumRiders INT NOT NULL,
PRIMARY KEY StationIDRideDate
FOREIGN KEY StationID REFERENCES StationsStationID
;
Find the date that had the smallest number of riders across all L stations. Also retrieve
this number of riders.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
