How to implement the plan using SQL?

Question

MySQL

How to implement the plan using SQL?
Task:
Display the sum of prices for each unique Email.
As I thought:

SELECT SUM(`price`) FROM `orders` WHERE `email` = (SELECT DISTINCT `email` FROM `orders`);

But in the end:
#1242 - Subquery returns more than 1 row

Answer 1

This is done through Group by

SELECT `email`, SUM(`price`) FROM `orders`
GROUP BY `email`