Question

Baze de date — tabelul Melodii

Accepted Answer

-- a) Crearea structurii tabelului
CREATE TABLE Melodii (
    Id_melodie    INTEGER,
    Titlu         VARCHAR(100),
    Artist        VARCHAR(100),
    Durata        INTEGER,
    Data_aparitie DATE
);

-- b) Introducerea inregistrarilor
INSERT INTO Melodii VALUES (1254, 'Desert rose',           'Sting',       286, '1999-09-24');
INSERT INTO Melodii VALUES (1043, 'House of rising sun',   'Deep Purple', 230, '1973-01-12');
INSERT INTO Melodii VALUES (1067, 'Every breath you take', 'Sting',       253, '1983-06-01');
INSERT INTO Melodii VALUES (1198, 'Left outside alone',    'Anastacia',   233, '2004-03-15');
INSERT INTO Melodii VALUES (1233, 'Child in time',         'Deep Purple', 614, '1970-06-03');
INSERT INTO Melodii VALUES (1022, 'Nothing else matters',  'Metallica',   389, '1991-08-02');

-- c) Melodiile anilor '90, ordonate alfabetic dupa artist
SELECT *
FROM Melodii
WHERE Data_aparitie BETWEEN '1990-01-01' AND '1999-12-31'
ORDER BY Artist ASC;

-- d) Stergerea melodiilor formatiei Deep Purple
DELETE FROM Melodii
WHERE Artist = 'Deep Purple';

Baze de date — tabelul Melodii

Enunț

Rezolvare

Apariții

Id_melodie	Titlu	Artist	Durata	Data_aparitie
1254	Desert rose	Sting	286	24.sep.1999
1043	House of rising sun	Deep Purple	230	12.ian.1973
1067	Every breath you take	Sting	253	01.iun.1983
1198	Left outside alone	Anastacia	233	15.mar.2004
1233	Child in time	Deep Purple	614	03.iun.1970
1022	Nothing else matters	Metallica	389	02.aug.1991