Waiting for answer This question has not been answered yet. You can hire a professional tutor to get the answer.
I am tasked with writing queries for my computer science class, however, I am having trouble understanding how
I am tasked with writing queries for my computer science class, however, I am having trouble understanding how
to1. Show all the songs in your database ordered by your ranking (bestsong ranked number 1 followed by number 2 etc.) alongside your twoadditional fields: (order of fields: Ranking, SongTitIe, SOMETHING, SOME THINGELSE) 2. Show all the songs in your database of currently active bands orderedby year (oldest first)(order of fields: Ranking, SongTitIe, Year, Name, NumberOfMembers,C urren tIyActive) 3. Show all the unique languages alphabetically of currently not activeartists (so without repeating the same language twice in the output):(order of fields: Language) Put your working queries in the q2 .txt file (each on a separate line) the file shouldcontain 3 lines (one for each query).
