1. Which of the following is not a built in aggregate function in SQL? a) avg b) max c) total d) count AnswerAnswer: c [Reason:] SQL does not include total as a built in aggregate function. The avg is used to find average, max is used to find the maximum and the count is used…