· 6 years ago · Apr 10, 2019, 06:46 AM
1DROP DATABASE IF EXISTS top_songsDB;
2CREATE database top_songsDB;
3
4USE top_songsDB;
5
6CREATE TABLE top5000 (
7 position INT NOT NULL,
8 artist VARCHAR(100) NULL,
9 song VARCHAR(100) NULL,
10 year INT NULL,
11 raw_total DECIMAL(10,4) NULL,
12 raw_usa DECIMAL(10,4) NULL,
13 raw_uk DECIMAL(10,4) NULL,
14 raw_eur DECIMAL(10,4) NULL,
15 raw_row DECIMAL(10,4) NULL,
16 PRIMARY KEY (position)
17);
18
19CREATE TABLE top_albums (
20 position INT NOT NULL,
21 artist VARCHAR(100) NULL,
22 album VARCHAR(100) NULL,
23 year INT NULL,
24 raw_total DECIMAL(10,4) NULL,
25 raw_usa DECIMAL(10,4) NULL,
26 raw_uk DECIMAL(10,4) NULL,
27 raw_eur DECIMAL(10,4) NULL,
28 raw_row DECIMAL(10,4) NULL,
29 PRIMARY KEY (position)
30);
31
32SELECT * FROM top5000;
33select * from top_albums;