your next task is to identify the average contribution given by donors over the past two years. tayen will use this information to set a donation minimum for inviting donors to an upcoming event. you start with 2019. to return average contributions in 2019 (contributions 2019), you use the avg function. what portion of your sql statement will instruct the database to find this average and store it in the avglinetotal variable?

In this post, we will learn about the T-SQL function known as AVG(), or the SQL Average function. The SELECT command returns a numerical dataset, and the aggregate function AVG() determines the average value of that dataset.Introduction to and examples for the SQL AVG() functionLet's say we have a list of numbers. First, we add up all of the collection's members, and then we divide the total number of members. John, a university student, chooses to keep a daily journal of his spending. The following table and chart show John's spending for the previous week.We will now determine John's average weekly expenditures. We shall first total up all of the outlays for the aforementioned week.($20+$60+$20+$42+$10+$15+$8) = $175 is the total amount of the expenses for the week.The second step will be to split the overall expense amount by 7, as there are 7 members in this collection. In other words, there are seven days in a week.$175 / 7 = $25 is the average expense of the week.Let's continue learning the fundamentals of the AVG() function in SQL after understanding the average mathematical idea.Preparation of Data The WeekExpense table will be created with the use of the following query, and John's three weeks' worth of expenses will then be inserted. In all of the examples in this tutorial, we will utilize this table.To Learn more about AVG() refer to:https://brainly.com/question/28818771#SPJ4