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

3 votes210 views2 answers
Monthname sql
SQL
1 vote219 views1 answer
Oracle insert multiple rows into same table
SQL
6 votes215 views6 answers
Code: 'ER_NOT_SUPPORTED_AUTH_MODE', errno: 1251, sqlMessage: 'Client does not support authentication protocol requested by server; consider upgrading MySQL client', sqlState: '08004', fatal: true
SQL
0 vote191 views3 answers
Sql count condition
SQL
0 vote243 views1 answer
Mysql order by where condition sub query
SQL
0 vote187 views1 answer
Cara menampilkan user di mysql terminal
SQL
0 vote208 views1 answer
Write a query to peint the pattern P(20)
SQL
0 vote197 views2 answers
Mysql updating multiple column values from array variable
SQL
0 vote255 views1 answer
Capabilities of sql select statements
SQL
0 vote212 views1 answer
Sqlserver now
SQL