MAX

SELECT o.off_name as offName, n.ngt_buyer_usr_code as ngtBuyer, m.mnf_category as mnfCateg, n.ngt_status as ngtStatus,  COUNT(n.ngt_buyer_usr_code) as countBuyer
					FROM negotiation as n, manufacturer as m, user as u, office as o
					WHERE n.ngt_mnf_code= m.mnf_code
					AND n.ngt_buyer_usr_code=u.usr_email
					AND o.off_code=u.usr_off_code
					AND u.usr_type='B'
					AND n.ngt_buyer_usr_code='magno@dimawe.com'
GROUP BY n.ngt_status, m.mnf_category
ORDER BY n.ngt_buyer_usr_code, n.ngt_status