CREATE TABLE albums (
	id INTEGER PRIMARY KEY,
	name TEXT NOT NULL,
	artist TEXT NOT NULL,
	genre TEXT NOT NULL,
	year TEXT NOT NULL,
	country TEXT NOT NULL
);
INSERT INTO albums (name, artist, genre, year, country) VALUES
	('The Wall', 'Pink Floyd', 'Progressive rock', '1979', 'UK'),
	('The Dark Side of the Moon', 'Pink Floyd', 'Progressive rock', '1973', 'UK'),
	('Animals', 'Pink Floyd', 'Progressive rock', '1977', 'UK'),
	('Wish You Were Here', 'Pink Floyd', 'Progressive rock', '1975', 'UK'),
	('A Momentary Lapse of Reason', 'Pink Floyd', 'Progressive rock', '1987', 'UK'),
	('The Division Bell', 'Pink Floyd', 'Progressive rock', '1994', 'UK'),
	('The Endless River', 'Pink Floyd', 'Progressive rock', '2014', 'UK'),
	('Nevermind', 'Nirvana', 'Grunge', '1991', 'US'),
	('Bleach', 'Nirvana', 'Grunge', '1989', 'US'),
	('In Utero', 'Nirvana', 'Grunge', '1993', 'US'),
	('OK Computer', 'Radiohead', 'Alt rock', '1997', 'UK'),
	('Kid A', 'Radiohead', 'Alt rock', '2000', 'UK'),
	('Amnesiac', 'Radiohead', 'Alt rock', '2001', 'UK'),
	('Hail to the Thief', 'Radiohead', 'Alt rock', '2003', 'UK'),
	('In Rainbows', 'Radiohead', 'Alt rock', '2007', 'UK'),
	('A Moon Shaped Pool', 'Radiohead', 'Alt rock', '2016', 'UK'),
	('Woodface', 'Crowded House', 'Pop rock', '1991', 'Australia'),
	('Temple of Low Men', 'Crowded House', 'Pop rock', '1988', 'Australia'),
	('Together Alone', 'Crowded House', 'Pop rock', '1993', 'Australia'),
	('Time on Earth', 'Crowded House', 'Pop rock', '2007', 'Australia'),
	('The Innocents', 'Erasure', 'Synth pop', '1988', 'UK'),
	('Wild!', 'Erasure', 'Synth pop', '1989', 'UK'),
	('I Say I Say I Say', 'Erasure', 'Synth pop', '1994', 'UK'),
	('Light at the End of the World', 'Erasure', 'Synth pop', '2007', 'UK'),
	('Actually', 'Pet Shop Boys', 'Synth pop', '1987', 'UK'),
	('Behaviour', 'Pet Shop Boys', 'Synth pop', '1990', 'UK'),
	('Fundamental', 'Pet Shop Boys', 'Synth pop', '2006', 'UK'),
	('Electric', 'Pet Shop Buys', 'Synth pop', '2013', 'UK'),
	('Ben', 'Michael Jackson', 'Pop', '1972', 'US'),
	('Thriller', 'Michael Jackson', 'Pop', '1982', 'US'),
	('Bad', 'Michael Jackson', 'Pop', '1987', 'US'),
	('Dangerous', 'Michael Jackson', 'Pop', '1991', 'US'),
	('HIStory', 'Michael Jackson', 'Pop', '1995', 'US'),
	('Birth of the Cool', 'Miles Davis', 'Jazz', '1957', 'US'),
	('Cookin''', 'Miles Davis', 'Jazz', '1957', 'US'),
	('Kind of Blue', 'Miles Davis', 'Jazz', '1959', 'US'),
	('Miles in the Sky', 'Miles Davis', 'Jazz', '1968', 'US'),
	('The Woman in Me', 'Shania Twain', 'Country pop', '1995', 'Canada'),
	('Come On Over', 'Shania Twain', 'Country pop', '1997', 'Canada'),
	('Queen of Me', 'Shania Twain', 'Country pop', '2023', 'Canada'),
	('October', 'U2', 'Rock', '1981', 'Ireland'),
	('Achtung Baby', 'U2', 'Rock', '1991', 'Ireland'),
	('Zooropa', 'U2', 'Rock', '1993', 'Ireland'),
	('The Joshua Tree', 'U2', 'Rock', '1987', 'Ireland'),
	('How to Dismantle an Atomic Bomb', 'U2', 'Rock', '2004', 'Ireland'),
	('Autobahn', 'Kraftwerk', 'Electronic', '1974', 'Germany'),
	('Trans Europa Express', 'Kraftwerk', 'Electronic', '1977', 'Germany'),
	('Computerwelt', 'Kraftwerk', 'Electronic', '1981', 'Germany'),
	('Electric Café', 'Kraftwerk', 'Electronic', '1986', 'Germany'),
	('The Mix', 'Kraftwerk', 'Electronic', '1991', 'Germany')
;