SQL

Write a query to identify the single track that has no composer and is on both the "Grunge" and the "90's Music" playlists. Your query must not hardcode any numeric ids (e.g. GenreID, TrackID, AlbumID, ArtistID, PlaylistID). The result set (see figure below) should have a single row with the following columns (in order): track name (track_name), album title (album_title), album artist's name (artist_name), and genre name (genre_name). Your query must have subquery for full points

Album Artist Albumld Artistld Title Name L Artist ld PlaylistTrack Playlist playlistId stid Trackld Name Employee n Employ eeld e-m Customer Last Name CustomerId First Name FirstName Title LastName ReportsTo Com BirthDate Address HireDate City Address State City Country State PostalCode Country Phone PostalCode Fax Phone Email Fax Email supportRepld Track Trackld Name Albumld MediaTypeld Genreld Composer Milliseconds Bytes Unit Price Invoice Line Invoice Lineld nvoiceld Trackld UnitPrice Quantity Invoice Invoice Id L customer ld Invoice Date Billing Address BillingCity Billingstate BillingCountry Billing PostalCode Total Media Type Media T Name Genre Genreld Name