Use the SUM(), AVG() functions along with the GROUP BY clause.
Link to my SQL Courses on Udemy: https://www.udemy.com/course/sql-serv...
Watch video SQL SUM & AVG FUNCTION WITH GROUP BY online without registration, duration hours minute second in high quality. This video was added by user SQL University 01 January 1970, don't forget to share it with your friends and acquaintances, it has been viewed on our site 121 once and liked it 1 people.