So I have this table in MySQL:
proprietar (person unique ID) can have one or more cars with a
valoare (value $) and I want to show by a
SELECT statement all the persons (
proprietar) with cars above 190000$.
I tried this but doesn’t work:
SELECT proprietar FROM datec.masini WHERE sum(valoare)>190000
and I want this result:
What am I missing here?
One approach, using aggregation:
SELECT proprietar FROM datec.masini GROUP BY proprietar HAVING SUM(valoare) > 190000;