query conversion manual

I have a few rows of a query which I run in MSSQL but I want to try converting the query into the procedure of laravel. anyone can help me?

general query :

select NM_PERUSAHAAN, count(*) as total_count, sum(FLAG_TERIMA) as approved, sum(1 - FLAG_TERIMA) as not_approved from MSTBEASISWAS group by NM_PERUSAHAAN;

tykus

8 years ago

Level 104

What is wrong with the query as you have it written?

select NM_PERUSAHAAN, 
    count(*) as total_count,
    sum(FLAG_TERIMA) as approved,
    sum(1 - FLAG_TERIMA) as not_approved 
from MSTBEASISWAS
group by NM_PERUSAHAAN;

Please or to participate in this conversation.