SELECT n.ngt_buyer_usr_code as ngtBuyer, 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
ORDER BY n.ngt_buyer_usr_code, n.ngt_status