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

1 vote246 views1 answer
Autocommit mysql
SQL
0 vote201 views1 answer
Sql injection payload list github
SQL
0 vote221 views1 answer
Mysql date equals to current_date plus days
SQL
0 vote187 views1 answer
Renommer table sql
SQL
0 vote221 views1 answer
Retornar apenas o ano mysql date
SQL
0 vote189 views1 answer
How to get first 10 records of a table in mysql
SQL
0 vote184 views1 answer
Mysql add to number
SQL
7 votes186 views4 answers
Index in mysql
SQL
1 vote204 views2 answers
Remove space in mysql
SQL
1 vote147 views1 answer
Psql kill pid
SQL