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 votes547 views2 answers
Current date in postgresql minus 1 day
SQL
0 vote319 views1 answer
Sql pivot without aggregate
SQL
0 vote290 views1 answer
Sql convert datetime to year
SQL
0 vote282 views1 answer
Mysql regex exact match
SQL
0 vote308 views1 answer
How to set sql_mode for a query in CI model
SQL
2 votes293 views1 answer
Sqlite insert if not exists
SQL
3 votes314 views1 answer
Only join in sql
SQL
0 vote307 views1 answer
Codeigniter MySQL - Issue with SELECT & GROUP BY
SQL
0 vote279 views1 answer
Sqlalchemy.exc.DBAPIError: (ibm_db_dbi.Error) ibm_db_dbi::Error: SystemError('<built-in function connect> returned NULL without setting an error')
SQL
-1 vote289 views1 answer
Add bool column in sql
SQL