Answer the question
In order to leave comments, you need to log in
How to implement the plan using SQL?
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`);
#1242 - Subquery returns more than 1 row
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question