Question: sqlite > . open CTA _ L _ daily _ ridership.db sqlite > . schema CREATE TABLE [ Stations ] ( [ Station _ ID

sqlite>.open CTA_L_daily_ridership.db
sqlite>.schema
CREATE TABLE [Stations](
[Station_ID] INT NOT NULL,
[Station_Name] TEXT NOT NULL,
PRIMARY KEY ([Station_ID] ASC)
);
CREATE TABLE [Ridership](
[Station_ID] INT NOT NULL,
[Ride_Date] TEXT NOT NULL,
[Type_of_Day] TEXT NOT NULL,
[Num_Riders] INT NOT NULL,
PRIMARY KEY ([Station_ID],[Ride_Date])
FOREIGN KEY ([Station_ID]) REFERENCES [Stations]([Station_ID])
);
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 blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!