Rails sql query converstion

SmsMessage.where(
        sms_campaign_id: sms_campaign_ids
      ).select(
        "sum(CASE WHEN sms_messages.status = 1 THEN 1 ELSE 0 END) as enqueued_count",
        "sum(CASE WHEN sms_messages.status = 2 THEN 1 ELSE 0 END) as delivered_count",
        "sum(CASE WHEN sms_messages.status = 3 THEN 1 ELSE 0 END) as replies_count",
        "sum(CASE WHEN sms_messages.status = 4 THEN 1 ELSE 0 END) as failed_count",
        "sum(CASE WHEN sms_messages.status IN (1,2,4) THEN 1 ELSE 0 END) as sends_count",
        "count(id) as total_messages_count"
      )

Source: scuttle.io

Similar codes

0 vote259 views3 answers
Osx stop mysql service
SQL
1 vote243 views1 answer
Sqlite check if row exists
SQL
7 votes251 views4 answers
Database dump mysql command
SQL
0 vote251 views2 answers
Starting mysql service from mac
SQL
0 vote291 views1 answer
Add two days to current date in sql when creating tables
SQL
1 vote268 views1 answer
Expression number 1 of select list is not in group by clause
SQL
11 votes275 views1 answer
Creating tables in sql with python
SQL
5 votes248 views2 answers
Oracle tables with column name
SQL
0 vote254 views1 answer
How to install mysql without admin rights
SQL
0 vote242 views1 answer
Including parameters in OPENQUERY
SQL