baby names

baby-names-2020.sql

DROP TABLE IF EXISTS baby_names;
CREATE TEMPORARY TABLE baby_names( name TEXT, rank INTEGER );

-- From most popular baby names of 2020 according to the Social Security Administration
-- https://www.ssa.gov/oact/babynames/
INSERT INTO baby_names ('name', 'rank') VALUES ('Liam', 1);
INSERT INTO baby_names ('name', 'rank') VALUES ('Olivia', 1);
INSERT INTO baby_names ('name', 'rank') VALUES ('Noah', 2);
INSERT INTO baby_names ('name', 'rank') VALUES ('Emma', 2);
INSERT INTO baby_names ('name', 'rank') VALUES ('Oliver', 3);
INSERT INTO baby_names ('name', 'rank') VALUES ('Ava', 3);
INSERT INTO baby_names ('name', 'rank') VALUES ('Elijah', 4);
INSERT INTO baby_names ('name', 'rank') VALUES ('Charlotte', 4);
INSERT INTO baby_names ('name', 'rank') VALUES ('William', 5);
INSERT INTO baby_names ('name', 'rank') VALUES ('Sophia', 5);
INSERT INTO baby_names ('name', 'rank') VALUES ('James', 6);
INSERT INTO baby_names ('name', 'rank') VALUES ('Amelia', 6);
INSERT INTO baby_names ('name', 'rank') VALUES ('Benjamin', 7);
INSERT INTO baby_names ('name', 'rank') VALUES ('Isabella', 7);
INSERT INTO baby_names ('name', 'rank') VALUES ('Lucas', 8);
INSERT INTO baby_names ('name', 'rank') VALUES ('Mia', 8);
INSERT INTO baby_names ('name', 'rank') VALUES ('Henry', 9);
INSERT INTO baby_names ('name', 'rank') VALUES ('Evelyn', 9);
INSERT INTO baby_names ('name', 'rank') VALUES ('Alexander', 10);
INSERT INTO baby_names ('name', 'rank') VALUES ('Harper', 10);

SELECT * from baby_names LIMIT 2