data_entry_marketshare.sql

--@block
INSERT INTO marketshare
VALUES
("Samsung", 18, 2021, 2),
("Samsung", 22, 2021, 1),
("Samsung", 16, 2020, 4);

--@block
INSERT INTO marketshare
VALUES
("Samsung", 22, 2020, 3),
("Samsung", 20, 2020, 2),
("Samsung", 20, 2020, 1),
("Samsung", 18, 2019, 4),
("Samsung", 21, 2019, 3),
("Samsung", 21, 2019, 2),
("Samsung", 21, 2019, 1),
("Samsung", 18, 2018, 4),
("Samsung", 19, 2018, 3);


--@block
INSERT INTO marketshare
VALUES
("Xiaomi", 9, 2018, 3),
("Xiaomi", 6, 2018, 4),
("Xiaomi", 8, 2019, 1),
("Xiaomi", 9, 2019, 2),
("Xiaomi", 8, 2019, 3),
("Xiaomi", 8, 2019, 4),
("Xiaomi", 10, 2020, 1),
("Xiaomi", 10, 2020, 2),
("Xiaomi", 13, 2020, 3),
("Xiaomi", 11, 2020, 4),
("Xiaomi", 14, 2021, 1),
("Xiaomi", 16, 2021, 2);

--@block
INSERT INTO marketshare
VALUES
("Apple", 12, 2018, 3),
("Apple", 17, 2018, 4),
("Apple", 12, 2019, 1),
("Apple", 10, 2019, 2),
("Apple", 12, 2019, 3),
("Apple", 18, 2019, 4),
("Apple", 14, 2020, 1),
("Apple", 14, 2020, 2),
("Apple", 11, 2020, 3),
("Apple", 21, 2020, 4),
("Apple", 17, 2021, 1),
("Apple", 15, 2021, 2);

--@block
COMMIT;