Mysql where sum > 0

Mysql where sum >0

 SELECT user.id, CONCAT(lastname, firstname), year, month, date FROM user
LEFT JOIN adoption ON user.id = adoption.adopter
GROUP BY user.id
HAVING SUM(CONCAT(year,month,date) = '2016618') = 0

Source: stackoverflow.com

Similar codes

0 vote344 views3 answers
Condition in count sql
SQL
0 vote312 views3 answers
Insert or ignore postgres
SQL
0 vote294 views1 answer
How do i calculate someone's age based on a datetime type birthday?
SQL
0 vote361 views1 answer
Python dictionary to sql update
SQL
7 votes319 views2 answers
Add column table pl sql
SQL
11 votes323 views1 answer
Get ddl materialized view oracle
SQL
0 vote354 views1 answer
Stored procedure to change name of column for all dependent tables and views
SQL
1 vote340 views1 answer
Second last highest id in sql
SQL
0 vote341 views2 answers
Connect to mysql server mac terminal
SQL
6 votes326 views2 answers
Non relational database
SQL