SQL

Aside from "Various Artists", "The Office", and "Lost", there are 9 artists that have more than 50 tracks. Write a query to generate a list of these artists, identifying their name (artist name) and number of tracks (num_tracks). The list should be sorted by the number of tracks (greatest first), then by the name of the artist (alphabetically). Your query must not hardcode any numeric ids (e.g. TrackId, AlbumId, ArtistId)

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