$3$ All members will receive a $10\%$ discount on their total charges. Write a query to summarize by MemberID

the Discounted charge $($name the field Discounted Charge$).$ List the MemberID, StatusID, member$$s first name, last

name, the total charges and the discounted charge. Format the new Discounted Charge field to Currency.