THE TABLE IS NOT THE ANSWER TO THE QUESTION! PLEASE WRITE OUT THE SQL QUERY TO THESE QUESTIONS BASED ON WHAT YOU SEE FROM THE TABLE!

1. Table: billboard_top_100_year_end

a) What were the top songs for the past 30 years?

b) Which artists have had the most top 10 songs over the years? What were the songs?

c) Which artists have been on the billboard top 100 the most in the past 10 years?

d) Who is the best artist in the past 50 years? What metrics would you use to answer this question?

The bold question at the bottom is an open-ended question. There is no right or wrong answer but youll be graded on your approach and the data-driven support you provide. To answer the question thoroughly, you should aim to analyze the data 3-4 different ways to provide support for your answer.

billboard year year_rank group_name artist song_name id 1956 1 Elvis Presley Elvis Presley Heartbreak Hotel 1 1956 2 Elvis Presley Elvis Presley Don't Be Cruel 2 1956 3 Nelson Riddle Nelson Riddle Lisbon Antigua 3 1956 4 Platters Platters My Prayer 4 1956 5 Gogi Grant Gogi Grant The Wayward Wind 5 1956 6 Les Baxter Les Baxter The Poor People Of Paris 6 1956 7 Doris Day Doris Day Whatever Will Be Will Be (Que Sera Sera) 7 1956 8 Elvis Presley Elvis Presley Hound Dog 8 1956 9 Dean Martin Dean Martin Memories Are Made Of This 9 1956 10 Kay Starr Kay Starr Rock And Roll Waltz 10 1956 11 Morris Stoloff Morris Stoloff Moonglow And Theme From Picnic 11 1956 12 Platters Platters The Great Pretender 12 1956 13 Pat Boone Pat Boone 13 I Almost Lost My Mind I Want You, I Need You, I Love You 1956 14 Elvis Presley Elvis Presley 14 1956 15 Elvis Presley Elvis Presley Love Me Tender 15 1956 16 Hot Diggity Canadian Sunset 1956 17 16 Perry Como Perry Como 17 Eddie Heywood and Hugo Winterhalter Eddie Heywood 17 Eddie Heywood and Hugo Winterhalter Hugo Winterhalter 18 Carl Perkins Carl Perkins 1956 Canadian Sunset 18 1956 Blue Suede Shoes 19 1956 19 Jim Lowe Jim Lowe The Green Door 20 1956 20 Four Lads Four Lads No, Not Much 21 1956 21 Bill Doggett Bill Doggett Honky Tonk 22 1956 22 Tennessee Ernie Ford Tennessee Ernie Ford Sixteen Tons 23 1956 23 Johnnie Ray Johnnie Ray Just Walking In The Rain 24 1956 24 Patti Page 25 1956 25 Fats Domino 26 1956 26 Patience and Prudence Patti Page Allegheny Moon Fats Domino I'm In Love Again Patience and Prudence Tonight You Belong To Me Gene Vincent Be-Bop-A-Lula Frankie Lymon and The Teenagers Why Do Fools Fall In Love 27 1956 27 Gene Vincent 28 1956 28 Frankie Lymon and The Teenagers 29