Magdalena

Aus ProgrammingWiki

Archivierte Version vom 2024-03-19T19:42:59+00:00. Aktuelle Version

Musikgenre

CREATE TABLE Musik (
    Künstler_ID INT PRIMARY KEY,
    Künstler_Name VARCHAR(255),
    Genre VARCHAR(50),
    Albumanzahl INT,
    Zuhörer_pro_Monat INT
);

INSERT INTO Musik (Künstler_ID , Künstler_Name, Genre, Albumanzahl, Zuhörer_pro_Monat)
VALUES
    (1, 'The Beatles', 'Rock', 12, 5000000),
    (2, 'Beyoncé', 'Pop', 8, 3000000),
    (3, 'Mozart', 'Classical', 25, 100000),
    (4, 'Eminem', 'Hip Hop', 10, 2000000),
    (5, 'Adele', 'Pop', 3, 1500000),
    (6, 'Queen', 'Rock', 15, 4000000),
    (7, 'Taylor Swift', 'Pop', 9, 2500000),
    (8, 'Beethoven', 'Classical', 30, 80000),
    (9, 'Jay-Z', 'Hip Hop', 11, 1800000),
    (10, 'Coldplay', 'Rock', 7, 3500000),
    (11, 'Rihanna', 'Pop', 6, 2800000),
    (12, 'Chopin', 'Classical', 20, 90000),
    (13, 'Kendrick Lamar', 'Hip Hop', 5, 2200000),
    (14, 'Ed Sheeran', 'Pop', 4, 1700000),
    (15, 'Led Zeppelin', 'Rock', 9, 3800000),
    (16, 'Vivaldi', 'Classical', 18, 95000),
    (17, 'Drake', 'Hip Hop', 8, 2100000),
    (18, 'Lady Gaga', 'Pop', 5, 2600000),
    (19, 'Pink Floyd', 'Rock', 10, 4200000),
    (20, 'Tchaikovsky', 'Classical', 22, 110000);

Magdalena

Musikgenre

Suche