Ygthkb

Is my plan for fixing my water heater leak bad?

Is there a low-level alternative to Animate Objects?

How to avoid being sexist when trying to employ someone to function in a very sexist environment?

I am on the US no-fly list. What can I do in order to be allowed on flights which go through US airspace?

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

How to speed up a process

Replacement ford fiesta radiator has extra hose

Whom do I have to contact for a ticket refund in case of denied boarding (in the EU)?

Sometimes a banana is just a banana

How to properly claim credit for peer review?

Logistics of a hovering watercraft in a fantasy setting

Must a tritone substitution use a dominant seventh chord?

It took me a lot of time to make this, pls like. (YouTube Comments #1)

Second-rate spelling

Equivalent to "source" in OpenBSD?

CBP Reminds Travelers to Allow 72 Hours for ESTA. Why?

How to count words in a line

Hacker Rank: Array left rotation

Auto Insert date into Notepad

I encountered my boss during an on-site interview at another company. Should I bring it up when seeing him next time?

Why is working on the same position for more than 15 years not a red flag?

A "strange" unit radio astronomy

You'll find me clean when something is full

Do authors have to be politically correct in article-writing?

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 1 min 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 1 min 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 1 min 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 1 min 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 1 min 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 1 min 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 1 min ago

SQL NoobSQL Noob

1