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 vote171 views1 answer
How to concatenate text from multiple rows into a single text string in SQL Server
SQL
0 vote194 views1 answer
Mysql Selected All Duplicate Rows
SQL
0 vote192 views1 answer
Wordpress delete post revisions older than date "sql"
SQL
0 vote202 views1 answer
Group by 15 minute interval sql server
SQL
0 vote173 views1 answer
Mysql concat and use as where column
SQL
0 vote188 views1 answer
Lesser than or equal to symbol in postgres
SQL
1 vote178 views1 answer
Mysql get character set
SQL
3 votes193 views2 answers
Monthname sql
SQL
0 vote199 views1 answer
Mysql update from select on same table
SQL
0 vote182 views1 answer
Sequelize postgresql schema
SQL