52. Average Loan Amount
Simple query to calculate the average loan size in USD over the last 6 months. I calculated this in two different ways to confirm - by using the AVG function, as well as calculating it manually by using SUM and COUNT functions. Both numbers came out the exact same, but I used the data and chart from the AVG function because it requires less SQL and is cleaner. I will share in the show-and-tell discord to show people how you can use SQL in different ways to get the same results, often.