Help me in solving SQW12 problem

My issue : this account not a college dashboard it is a student ,so please change dash board on my profile

Aggregate functions
AGGREGATE functions
Analysis and calculations performed on multiple rows of a table are called aggregate functions.
Important aggregate functions are as follows

COUNT() - counts the number of rows that meet the given conditions
MAX() & MIN() - return the largest & smallest value that meet the query conditions
SUM() & AVG() - return the sum and average of the values in the column
GROUP BY - used to combine rows with identical values into summary rows.
It is typically used with aggregate functions such as COUNT, SUM, etc
Solve some of these questions about Aggregate functions to proceed.

Learning course: SQL at Work
Problem Link: Aggregate functions in SQL at Work