Create a query in Query Design view based on both tables to answer the question, What is the Concert ID$,$ Sponsor Name, Box Office Receipts, and a new field named Sponsor Donation that will calculate and display the donation amount when the Sponsor donates an amount equal to $50$ percent $(0\mathrm{.}5)$ of each box office receipts amount to the Music Department. Sort the records in ascending order by the Concert ID field. a$.$ Run the query