MySQL: Query with SUM(if ..)

Question

Please, help me with query:

SELECT 
    N.site_name, 
    Count(N.site_name), 
    SUM (IF((SC.type_conn = 'GET') && (SC.type_conn = 'CONNECT'),N.size_site,0)) as Traffic_IN, 
    SUM (IF(SC.type_conn = 'POST',N.size_site,0)) as Traffic_OUT 
From 
    news N, 
    status_conn SC, 
    users U 
where 
    N.id_conn = SC.id_conn and 
    N.id_user = U.id_user and 
    U.name_user = 'max' and 
    N.date_conn = '2015-08-04' 
Group by 
    N.site_name 
Order by 
    SUM (IF((SC.type_conn = 'GET') && (SC.type_conn = 'CONNECT'),N.size_site,0))

Please don't use this type of JOINs, And clarify us about how can we help you?! ;). — shA.t
– shA.t, Commented Aug 4, 2015 at 7:21
ERROR : #1630 FUNCTION [name_db].sum does not exist. Check the ' Function Name Parsing and Resolution' action in the Reference Manual — madmax
– madmax, Commented Aug 4, 2015 at 7:59

UBEX · Accepted Answer · 2015-08-04 07:19:47Z

1

I don't know witch is the problem; in any case you could try this:

Select N.site_name, 
Count(N.site_name), 
SUM (IF((SC.type_conn = 'GET') && (SC.type_conn = 'CONNECT'),N.size_site,0)) as Traffic_IN, 
SUM (IF(SC.type_conn = 'POST',N.size_site,0)) as Traffic_OUT 
From news N, status_conn SC, users U
where N.id_conn = SC.id_conn 
and N.id_user = U.id_user 
and U.name_user = 'max' 
and N.date_conn = '2015-08-04' 
Group by N.site_name 
Order by Traffic_IN

otherwise

select ...
...
Order by 3

answered Aug 4, 2015 at 7:19

UBEX

1221 silver badge14 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

ted · Accepted Answer · 2015-08-04 07:17:28Z

0

You may very well have a parenthesis problem at the end of your query. Try

[...] ORDER BY SUM (IF((SC.type_conn = 'GET') && (SC.type_conn = 'CONNECT')),N.size_site,0)

answered Aug 4, 2015 at 7:17

ted

14.9k10 gold badges70 silver badges117 bronze badges

Collectives™ on Stack Overflow

MySQL: Query with SUM(if ..)

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related