Magdalena

Aus ProgrammingWiki

Archivierte Version vom 2024-03-19T19:47:57+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
);

CREATE TABLE FiktivePersonen (
    person_id INT PRIMARY KEY,
    vorname VARCHAR(50),
    nachname VARCHAR(50),
    musikgeschmack VARCHAR(100),
    lieblingskünstler VARCHAR(100)
);

INSERT INTO FiktivePersonen (person_id, vorname, nachname, musikgeschmack, lieblingskünstler)
VALUES
    (1, 'Anna', 'Schmidt', 'Pop', 'Adele'),
    (2, 'Max', 'Müller', 'Rock', 'Queen'),
    (3, 'Lena', 'Fischer', 'Electronic', 'Daft Punk'),
    (4, 'Tom', 'Wagner', 'Hip Hop', 'Kendrick Lamar'),
    (5, 'Sophie', 'Keller', 'Classical', 'Mozart'),
    (6, 'Paul', 'Becker', 'Indie', 'Arctic Monkeys'),
    (7, 'Laura', 'Hoffmann', 'Jazz', 'Miles Davis'),
    (8, 'Felix', 'Schulz', 'Country', 'Johnny Cash'),
    (9, 'Julia', 'Weber', 'Reggae', 'Bob Marley'),
    (10, 'Simon', 'Lehmann', 'Metal', 'Metallica'),
    (11, 'Maria', 'Bauer', 'Blues', 'B.B. King'),
    (12, 'David', 'Koch', 'Funk', 'James Brown'),
    (13, 'Nina', 'Schneider', 'R&B', 'Beyoncé'),
    (14, 'Tim', 'Hansen', 'Alternative', 'Radiohead'),
    (15, 'Lisa', 'Schwarz', 'Soul', 'Aretha Franklin'),
    (16, 'Mark', 'Zimmermann', 'Punk', 'The Ramones'),
    (17, 'Carla', 'Kühn', 'Latin', 'Shakira'),
    (18, 'Erik', 'Lange', 'EDM', 'Calvin Harris'),
    (19, 'Sarah', 'Graf', 'Reggaeton', 'Daddy Yankee'),
    (20, 'Alex', 'Wolf', 'Folk', 'Bob Dylan');


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