Find Average Purchase Value.
EasyUnlock detailed company stats for this questionUpgrade
You are given the following tables:
attribution table:
user_sessions table:
Find the average value of purchases made through each marketing channel and arrange them in descending order, starting with the channel that has the highest average purchase value. Your output should have the following columns: marketing_channel, avg_purchase_value
SQLSELECT marketing_channel, AVG(purchase_value) AS avg_purchase_value FROM attribution GROUP BY marketing_channel ORDER BY AVG(purchase_value) DESC;