(Solved) : Write Five Select Statements Select Data Table Individually B Write One Select Statement Q36418703 . . .
a. Write five select statements to select data from eachtable individually.
b. Write one select statement with joins to list theplaylist name, playlist track number, song name, artist name, albumname, sorted by playlist name and playlist tracknumber.
DROP TABLE Artists CASCADE CONSTRAINTS;
DROP TABLE Albums CASCADE CONSTRAINTS;
DROP TABLE Songs CASCADE CONSTRAINTS;
DROP TABLE Playlists CASCADE CONSTRAINTS;
DROP TABLE PlaylistSongs CASCADE CONSTRAINTS;
CREATE TABLE Artists (
ArtistID int NOT NULL,
ArtistName varchar(255),
PRIMARY KEY (ArtistID)
);
CREATE TABLE Albums(
AlbumID int NOT NULL,
AlbumName varchar(255),
YearReleased int,
ArtistID int NOT NULL,
PRIMARY KEY (AlbumID)
);
CREATE TABLE Songs(
SongID int NOT NULL,
SongName varchar(255),
TrackNumber int,
AlbumID int NOT NULL,
PRIMARY KEY (SongID)
);
CREATE TABLE Playlists(
PlaylistID int NOT NULL,
PlaylistName varchar(255),
PRIMARY KEY(PlaylistID)
);
CREATE TABLE PlaylistSongs
(
PlaylistID int NOT NULL,
SongID int NOT NULL,
PlaylistTRackNumber int,
PRIMARY KEY(PlaylistID,SongID)
);
INSERT INTO Artists (ArtistID, ArtistName)
VALUES (‘1’, ‘Primus’);
INSERT INTO Artists (ArtistID, ArtistName)
VALUES (‘2’, ‘Captain Murphy’);
INSERT INTO Artists (ArtistID, ArtistName)
VALUES (‘3’, ‘King Krule’);
INSERT INTO Albums (AlbumID, AlbumName, YearReleased,ArtistID)
VALUES (‘1’, ‘Sailing the Seas of Cheese’, ‘1991’, ‘1’);
INSERT INTO Albums (AlbumID, AlbumName, YearReleased,ArtistID)
VALUES (‘2’, ‘Frizzle Fry’, ‘1990’, ‘1’);
INSERT INTO Albums (AlbumID, AlbumName, YearReleased,ArtistID)
VALUES (‘3’, ‘Duality’, ‘2012’, ‘2’);
INSERT INTO Albums (AlbumID, AlbumName, YearReleased,ArtistID)
VALUES (‘4’, ‘6 Feet Beneath the Moon’, ‘2013’, ‘3’);
INSERT INTO Songs (SongID, SongName, TrackNumber, AlbumID)
VALUES (‘1’, ‘John The Fisherman’, ‘6’, ‘2’);
INSERT INTO Songs (SongID, SongName, TrackNumber, AlbumID)
VALUES (‘2’, ‘Jerry was a Race Car Driver’, ‘5’, ‘1’);
INSERT INTO Songs (SongID, SongName, TrackNumber, AlbumID)
VALUES (‘3’, ‘Tommy the Cat’, ‘9’, ‘1’);
INSERT INTO Songs (SongID, SongName, TrackNumber, AlbumID)
VALUES (‘4’, ‘The Killing Joke’, ‘9’, ‘3’);
INSERT INTO Songs (SongID, SongName, TrackNumber, AlbumID)
VALUES (‘5’, ‘Out Getting Ribs’, ’13’, ‘4’);
INSERT INTO Playlists (PlaylistID, PlaylistName)
VALUES (‘1’, ‘Putting in Work’);
INSERT INTO Playlists (PlaylistID, PlaylistName)
VALUES (‘2’, ‘Relaxing’);
INSERT INTO PlaylistSongs (PlaylistID, SongID,PlaylistTRackNumber)
VALUES (‘1’, ‘1’, ‘1’);
INSERT INTO PlaylistSongs (PlaylistID, SongID,PlaylistTRackNumber)
VALUES (‘1’, ‘2’, ‘2’);
INSERT INTO PlaylistSongs (PlaylistID, SongID,PlaylistTRackNumber)
VALUES (‘2’, ‘4’, ‘1’);
INSERT INTO PlaylistSongs (PlaylistID, SongID,PlaylistTRackNumber)
VALUES (‘2’, ‘5’, ‘2’);
Expert Answer
Answer to Write Five Select Statements Select Data Table Individually B Write One Select Statement Q36418703 . . .
OR