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

9 votes319 views6 answers
Check constraint in sql
SQL
0 vote309 views1 answer
Alter fedora mysql 8.0 user
SQL
0 vote317 views1 answer
Ms sql filter all sympbol
SQL
2 votes337 views1 answer
Rails execute sql
SQL
10 votes364 views4 answers
Join multiple tables in sql
SQL
0 vote302 views1 answer
Azure sql server check foreign key
SQL
1 vote336 views1 answer
Drop primary key oracle
SQL
2 votes350 views1 answer
Python sql
SQL
1 vote296 views1 answer
Oracle db create new schema
SQL
1 vote317 views1 answer
Ubuntu mysql cannot connect to database server remote
SQL