3L5AvyLc

1--Point 1
2CREATE TABLE IF NOT EXISTS ia_dbonasin_sandbox.sqlday3_task1_point1
3(
4  id int IDENTITY(1, 1),
5  country_names varchar(50),
6  dates varchar(50),
7  cases int,
8  primary key(id)
9);
10
11SELECT country_name, date, cases
12FROM academy_datasets.covid_global
13LIMIT 30;
14
15INSERT INTO ia_dbonasin_sandbox.sqlday3_task1_point1(country_names, dates, cases)
16SELECT country_name, date, cases
17FROM academy_datasets.covid_global
18LIMIT 30;