PMG2224 4/DB Beleg/Magdalena

Aus ProgrammingWiki
Wiki-Quelltext dieser Seite.
<language>SQL</language>
==Musikgenre==

<code id="65f9ea34d0995">

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)
);

</code>

<code id="65f9ebed43ed5">

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);

</code>




<run id="65f9ea3fe825c"></run>
PMG2224 4/DB Beleg/Magdalena

Suche
