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 vote279 views1 answer
Big query add table rows to another table
SQL
1 vote301 views1 answer
Oracle first row
SQL
19 votes321 views5 answers
Mysql between date range
SQL
1 vote326 views1 answer
Postgres killing connections on db
SQL
0 vote306 views1 answer
Compare if is null sql
SQL
3 votes329 views1 answer
Postgres kill running query
SQL
0 vote328 views1 answer
Count number of entires by months sql
SQL
0 vote325 views1 answer
Lost connection to mysql
SQL
0 vote325 views1 answer
Selecting from a view SQL
SQL
0 vote317 views1 answer
How to select only id where is not in column mysql
SQL