Create a query in Query Design view based on the $2$G Scholarships Awarded table and the Sum aggregate function to answer the question: For each major, what is the total scholarship amount, sorted in descending order by the Amount field? Use the Property Sheet to format the Amount field with $0$ decimal places, and then close the Property Sheet. Run the query $($for the Major of History, the total scholarship amount is $$1,850).$ Apply Best Fit to the fields, save the query as $2$G Amount by Major Query, and then close the query.