orde Song Database
an anonymous user · 3 months ago
MySQL


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
CREATE TABLE album (
album VARCHAR(20) PRIMARY KEY,
song_amount INT NOT NULL,
producer VARCHAR(20) NOT NULL
);

INSERT INTO album VALUES('Pure Heroine', 10, 'Joel Little');
INSERT INTO album VALUES('Melodrama', 11, 'Jack Antonoff');
INSERT INTO album VALUES('Solar Power', 12, 'Jack Antonoff');

CREATE TABLE songs (
song_name VARCHAR(40) PRIMARY KEY,
album VARCHAR (20),
producers INT,
single VARCHAR(5)
);

INSERT INTO songs VALUES('Tennis Court', 'Pure Heroine', 1, 'Yes');
INSERT INTO songs VALUES('Four Hundred Lux', 'Pure Heroine', 1, 'No');
INSERT INTO songs VALUES('Royals', 'Pure Heroine', 1, 'Yes');
INSERT INTO songs VALUES('Ribs', 'Pure Heroine', 1, 'No');
INSERT INTO songs VALUES('Buzzcut Season', 'Pure Heroine', 1, 'No');
INSERT INTO songs VALUES('Team', 'Pure Heroine', 2, 'Yes');
INSERT INTO songs VALUES('Glory and Gore', 'Pure Heroine', 1, 'Yes');
INSERT INTO songs VALUES('Still Sane', 'Pure Heroine', 1, 'No');
INSERT INTO songs VALUES('White Teeth Teens', 'Pure Heroine', 1, 'No');
INSERT INTO songs VALUES('A World Alone', 'Pure Heroine', 2, 'No');
INSERT INTO songs VALUES('Green Light', 'Melodrama', 4, 'Yes');
INSERT INTO songs VALUES('Sober', 'Melodrama', 4, 'No');
INSERT INTO songs VALUES('Homemade Dynamite', 'Melodrama', 3, 'No');
INSERT INTO songs VALUES('The Lourve', 'Melodrama', 5, 'No');
INSERT INTO songs VALUES('Liability', 'Melodrama', 2, 'No');
INSERT INTO songs VALUES('Hard Feelings Loveless', 'Melodrama', 4, 'No'); INSERT INTO songs VALUES('Sober Two Melodrama', 'Melodrama', 5, 'No');
INSERT INTO songs VALUES('Writer in the Dark', 'Melodrama', 2, 'No');
INSERT INTO songs VALUES('Supercut', 'Melodrama', 5, 'No');
INSERT INTO songs VALUES('Liability Reprise', 'Melodrama', 2, 'No');
INSERT INTO songs VALUES('Perfect Places', 'Melodrama', 6, 'Yes');
INSERT INTO songs VALUES('The Path', 'Solar Power', 3, 'No');
INSERT INTO songs VALUES('Solar Power', 'Solar Power', 3, 'Yes');
INSERT INTO songs VALUES('California', 'Solar Power', 2, 'No');
INSERT INTO songs VALUES('Stoned at the Nail Salon', 'Solar Power', 2, 'Yes'); INSERT INTO songs VALUES('Fallen Fruit', 'Solar Power', 2, 'Yes');
INSERT INTO songs VALUES('Secrets from a Girl', 'Solar Power', 2, 'No');
INSERT INTO songs VALUES('The mother we share', 'Solar Power', 3, 'No');
INSERT INTO songs VALUES('Dominoes', 'Solar Power', 2, 'No');
INSERT INTO songs VALUES('Big Star', 'Solar Power', 2, 'No');
INSERT INTO songs VALUES('Leader of a New Regime', 'Solar Power', 3, 'No'); INSERT INTO songs VALUES('Mood Ring', 'Solar Power', 2, 'Yes');
INSERT INTO songs VALUES('Oceanic Feeling', 'Solar Power', 2, 'No');

SELECT*FROM songs
Output
(Run the program to view its output)
ads via Carbon
Work smarter, not harder. Effectively run workloads and builds with Kubes.
ADS VIA CARBON
Comments

--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)