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 vote144 views1 answer
Sql transact create cursor with dynamic tables
SQL
0 vote152 views1 answer
Postgres copy command
SQL
0 vote159 views1 answer
Sql select rows with different values in one column
SQL
7 votes165 views6 answers
Group_concat in mysql
SQL
0 vote156 views1 answer
Wordpress sql change site url
SQL
3 votes200 views1 answer
Query less than datetime sql
SQL
0 vote160 views1 answer
Sql bild in function
SQL
0 vote151 views1 answer
Mostrar datos de tablas relacionadas mysql kjava
SQL
1 vote157 views2 answers
How to search date in sql query
SQL
29 votes145 views5 answers
Mysql show table structure
SQL