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

7 votes351 views6 answers
Group_concat mysql
SQL
0 vote350 views1 answer
I wanted to select among the rows the highest value in mysql
SQL
1 vote363 views1 answer
Update mysql centos
SQL
0 vote379 views2 answers
While mysql
SQL
8 votes342 views1 answer
Database backup in mysql server recovery
SQL
0 vote316 views1 answer
Import sql mysql ubuntu
SQL
0 vote384 views1 answer
Oracle string length
SQL
5 votes356 views1 answer
Oracle list functions
SQL
4 votes339 views1 answer
Oracle error compilation line
SQL
0 vote373 views2 answers
Oracle create tablespace autoextend
SQL