Mysql

Kemarin di grup FB PHP Indonesia, ada yang bertanya tentang masalah query di MySQL. Dari data di tabel1, dia ingin menghasilkan data seperti tabel2, seperti gambar dibawah ini. Query untuk menghasilkan data diatas sebetulnya cukup mudah yaitu seperti berikut : [code language=“sql”] SELECT @cat_id:=category_id, category_id, count(category_id) as count_cat, (SELECT count(category_id) FROM table1 WHERE status = ‘Y’ AND category_id = @cat_id) as count_y, (SELECT count(category_id) FROM table1 WHERE status = ‘N’ AND category_id = @cat_id) as count_y FROM table1 group by category_id[/code] ...