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

1 vote119 views1 answer
VERIFY INDEXES IN SQL ORACLE
SQL
3 votes124 views1 answer
Oracle list user grants
SQL
0 vote116 views1 answer
Fix sqlite3 ruby on rails
SQL
3 votes128 views2 answers
Update part of a string in mysql
SQL
0 vote114 views2 answers
Get top 1 row of each group
SQL
0 vote107 views1 answer
Json_remove mysql
SQL
0 vote117 views4 answers
Mysql select bottom 10 rows
SQL
1 vote123 views1 answer
Rails run native ssql query
SQL
4 votes120 views1 answer
T-sql get duplicate rows
SQL
7 votes118 views5 answers
Sql remove spaces
SQL