How to count and do alias in query builder ?

@karapho712 you can check the documentation and try to convert it piece by piece. See here: https://laravel.com/docs/8.x/queries

But to answer:

DB::raw('count(DISTINCT idm) as total, COUNT(idm) FILTER (WHERE nilai=1) as jawab_1...')

Something like that :)

And for the whole query:

DB::table("t_mahasiswa_quisinoer")
             ->select(DB::raw("COUNT(DISTINCT idm) as total, COUNT(idm) FILTER (WHERE nilai=1) as jawab_1, COUNT(idm) FILTER (WHERE nilai=2) as jawab_2, COUNT(idm) FILTER (WHERE nilai=3) as jawab_3, COUNT(idm) FILTER (WHERE nilai=4) as jawab_4, COUNT(idm) FILTER (WHERE nilai=5) as jawab_5"))
             ->whereRaw("tahun_id='aaa' and kode_mk='bbb' and kelas='ccc' and kode_prodi='ddd'")
			 ->get();

It might not work because I haven't tested it but at least you know what to check on the docs.