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

24 votes384 views4 answers
Postgres delete database
SQL
0 vote337 views2 answers
How to get last inserted id in sql server c#
SQL
6 votes336 views2 answers
Mysql first day of month
SQL
0 vote350 views1 answer
Double in sql server example
SQL
0 vote361 views1 answer
Sql mod even odd
SQL
0 vote344 views1 answer
Mssql check if date is greater than today
SQL
12 votes346 views4 answers
Mysql ifnull
SQL
0 vote346 views2 answers
How to combine diff colmun value using group by postgres
SQL
1 vote339 views1 answer
Oracle case
SQL
0 vote356 views1 answer
Sql delete from with relation
SQL