Which playlists do not contain any tracks for the artists “Black Sabbath” nor “Chico Buarque” ? AndList the names and the countries of those customers who are supported by an employee who was younger than 35 when hired. HINT: use year as the first parameter in DATEDIFF(). ArtistArtistidNamePlaylistPlaylistldNameEmployeeEmployeeldLastNameFirstNameTitleReportsToBirthDateHireDateAddressCityStateCountryPostalCodePhoneFaxEmailAlbumAlbumidTitleArtistidPlaylist TrackPlaylistldTrackldCustomerCustomerldFirstNameLastNameCompanyAddressCityStateCountryPostalCode:PhoneFaxEmailSupportRepldTrackTrackldName:AlbumidMedia TypeldGenreldComposerMillisecondsBytesUnitPriceInvoiceLineInvoiceLineldInvoiceldTrackldUnitPriceQuantityInvoiceInvoiceldCustomerldInvoice DateBilling AddressBillingCityBillingStateBilling CountryBillingPostalCodeTotalMediaTypeMedia TypeldNameGenreGenreldName

The SQL queries are given below

Answered: Which playlists do not contain any…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Concept explainers

Question

Which playlists do not contain any tracks for the artists “Black Sabbath” nor “Chico Buarque” ? And

List the names and the countries of those customers who are supported by an employee who was younger than 35 when hired. HINT: use year as the first parameter in DATEDIFF().

Artist
Artistid
Name
Playlist
Playlistld
Name
Employee
Employeeld
LastName
FirstName
Title
ReportsTo
BirthDate
HireDate
Address
City
State
Country
PostalCode
Phone
Fax
Email
Album
Albumid
Title
Artistid
Playlist Track
Playlistld
Trackld
Customer
Customerld
FirstName
LastName
Company
Address
City
State
Country
PostalCode:
Phone
Fax
Email
SupportRepld
Track
Trackld
Name:
Albumid
Media Typeld
Genreld
Composer
Milliseconds
Bytes
UnitPrice
InvoiceLine
InvoiceLineld
Invoiceld
Trackld
UnitPrice
Quantity
Invoice
Invoiceld
Customerld
Invoice Date
Billing Address
BillingCity
BillingState
Billing Country
BillingPostalCode
Total
MediaType
Media Typeld
Name
Genre
Genreld
Name

Expert Solution

Step by step

Solved in 3 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions