Input Table: covid
The dataset represents daily reported COVID cases across multiple cities.
Create Table & Insert Data
-- Create table
CREATE TABLE covid (
city VARCHAR(50),
days DATE,
cases INT
);
-- Insert data
INSERT INTO covid (city, days, cases) VALUES
('DELHI', '2022-01-01', 100),
('DELHI', '2022-01-02', 200),
('DELHI', '2022-01-03', 300),
('MUMBAI', '2022-01-01', 100),
('MUMBAI', '2022-01-02', 100),
('MUMBAI', '2022-01-03', 300),
('CHENNAI', '2022-01-01', 100),
('CHENNAI', '2022-01-02', 200),
('CHENNAI', '2022-01-03', 150),
('BANGALORE', '2022-01-01', 100),
('BANGALORE', '2022-01-02', 300),
('BANGALORE', '2022-01-03', 200),
('BANGALORE', '2022-01-04', 400);
Reference Link
You can also access this dataset using the following link:
https://drive.google.com/drive/folders/1D4Yydsg1WSKaofYuiRTscFqg5Ey6pV7n
