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 vote165 views1 answer
Mysql listing get a particu particular user firsdt
SQL
0 vote166 views1 answer
Sql use with to get value counts and percentages
SQL
3 votes197 views2 answers
Oracle drop column
SQL
0 vote158 views1 answer
How to select only the first rows for each unique value of a sql tablecolumn?
SQL
0 vote144 views1 answer
Psql check if value in array
SQL
0 vote163 views1 answer
Psql show db
SQL
0 vote163 views1 answer
Ms sql filter all sympbol
SQL
0 vote153 views1 answer
Limit and offset in stored procedure mssql
SQL
1 vote164 views1 answer
Postgres count string length
SQL
0 vote158 views1 answer
Heidisql check how much space a row
SQL