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

14 votes189 views1 answer
Excel
SQL
1 vote213 views1 answer
Where to locate set password for mysql
SQL
0 vote256 views3 answers
Classement rang mysql 7
SQL
0 vote219 views1 answer
To Create directory
SQL
1 vote272 views1 answer
Error cs1061 'dbcontextoptionsbuilder' does not contain a definition for 'usesqlserver'
SQL
2 votes204 views1 answer
Mysql application.properties spring boot
SQL
2 votes201 views2 answers
HOW TO FIND MEDIAN IN SQL FOR BOTH IDD AND EVEN
SQL
0 vote218 views1 answer
Mysql show create db
SQL
0 vote219 views1 answer
How to get data from 2 database
SQL
1 vote198 views1 answer
Mysql view command
SQL