Sfrgttk

What's the purpose of these copper coils with resistors inside them in A Yamaha RX-V396RDS amplifier?

Equivalent to "source" in OpenBSD?

How do I construct an nxn matrix?

Is there a frame of reference in which I was born before I was conceived?

What are these green text/line displays shown during the livestream of Crew Dragon's approach to dock with the ISS?

Is there any relevance to Thor getting his hair cut other than comedic value?

"Murder!" The knight said

Difference between 小吃 and 零食

Must a tritone substitution use a dominant seventh chord?

Six real numbers so that product of any five is the sixth one

How to speed up a process

How do ISS astronauts "get their stripes"?

Can I become debt free or should I file for bankruptcy? How do I manage my debt and finances?

As a new poet, where can I find help from a professional to judge my work?

How can atoms be electrically neutral when there is a difference in the positions of the charges?

Difference between 'stomach' and 'uterus'

Compare four integers, return word based on maximum

What is the difference between ashamed and shamed?

How to count words in a line

Which aircraft had such a luxurious-looking navigator's station?

Can you use a beast's innate abilities while polymorphed?

What's the difference between a cart and a wagon?

Pure Functions: Does "No Side Effects" Imply "Always Same Output, Given Same Input"?

Where is the fallacy here?

SUM CASE MARIADB

MySQL optimization - year column grouping - using temporary table, filesortCASE Statement - 1st case is being ignoredCase always returns null?mysql: counting number of tickets which are open per day basisMariaDB: Querying a timestamp partitionHow do I prevent multiple row insert?Rolling SUM with a 30 day rangesum of count in where clause (or having) in the same table with group byUse of null in case expressionTotals on multple case conditions - mySql

0

I am wanting to count the number of users (rows) who have messages.

users - table
message_count - shows how many messages

I am selecting user.message_count without any problem.

SELECT xf_user.message_count,

I then have

SUM(CASE WHEN user.message_count > 0 THEN 1 ELSE 0 END) AS usersWithMessages,

However I'm not getting anything for usersWithMessages

Any advice?

mysql mariadb case sum

share

asked 4 mins ago

SQL NoobSQL Noob

1

New contributor

SQL Noob is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

0

I am wanting to count the number of users (rows) who have messages.

users - table
message_count - shows how many messages

I am selecting user.message_count without any problem.

SELECT xf_user.message_count,

I then have

SUM(CASE WHEN user.message_count > 0 THEN 1 ELSE 0 END) AS usersWithMessages,

However I'm not getting anything for usersWithMessages

Any advice?

mysql mariadb case sum

share

asked 4 mins ago

SQL NoobSQL Noob

1

New contributor

SQL Noob is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

I am wanting to count the number of users (rows) who have messages.

users - table
message_count - shows how many messages

I am selecting user.message_count without any problem.

SELECT xf_user.message_count,

I then have

SUM(CASE WHEN user.message_count > 0 THEN 1 ELSE 0 END) AS usersWithMessages,

However I'm not getting anything for usersWithMessages

Any advice?

mysql mariadb case sum

share

asked 4 mins ago

SQL NoobSQL Noob

1

New contributor

SQL Noob is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

SELECT xf_user.message_count,

SUM(CASE WHEN user.message_count > 0 THEN 1 ELSE 0 END) AS usersWithMessages,

share

asked 4 mins ago

SQL NoobSQL Noob

1

New contributor

SQL Noob is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

share

asked 4 mins ago

SQL NoobSQL Noob

1

New contributor

SQL Noob is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 4 mins ago

SQL NoobSQL Noob

1

New contributor

SQL Noob is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 4 mins ago

SQL NoobSQL Noob

1