Untitled
unknown
plain_text
a year ago
980 B
6
Indexable
USE Trybefy; CREATE TABLE artists ( id INT AUTO_INCREMENT PRIMARY KEY, name VARCHAR(50) NOT NULL, nationality VARCHAR(30) NOT NULL ); CREATE TABLE albums ( id INT AUTO_INCREMENT PRIMARY KEY, title VARCHAR(50) NOT NULL, release_year INT NOT NULL, artist_id INT NOT NULL, FOREIGN KEY (artist_id) REFERENCES artists(id) ); INSERT INTO artists (name, nationality) VALUES ('Michael Jackson', 'USA'), ('Nina Simone', 'USA'), ('The Beatles', 'UK'), ('BTS', 'KOR'), ('Rita Lee', 'BRA'); INSERT INTO albums (title, release_year, artist_id) VALUES ('Thriller', 1982, 1), ('Bad', 1987, 1), ('Dangerous', 1991, 1), ('I Put a Spell on You', 1965, 2), ('Sings the Blues', 1967, 2), ('Sgt. Peppers Lonely Hearts Club Band', 1967, 3), ('The Beatles', 1968, 3), ('Abbey Road', 1969, 3), ('Map of the Soul: 7', 2020, 4), ('You Never Walk Alone', 2017, 4), ('Love Yourself: Tear', 2018, 4), ('Build Up', 1970, 5), ('Fruto Proibido', 1975, 5), ('Entradas e Bandeiras', 1976, 5);
Editor is loading...
Leave a Comment