Exercise

# Revenue quartiles

Dave is wrapping up his study, and wants to calculate a few more figures. He wants to find out the first, second, and third revenue quartiles. He also wants to find the average to see in which direction the data is skewed.

Calculate the first, second, and third revenue quartiles, as well as the average.

**Note**: You can calculate the 30th percentile for a column named `column_a`

by using `PERCENTILE_CONT(0.30) WITHIN GROUP (ORDER BY column_a ASC)`

.

Instructions

**100 XP**

- Store each user ID and the revenue Delivr generates from it in the
`user_revenues`

CTE. - Calculate the first, second, and third revenue quartile.
- Calculate the average revenue.