create view vContMaf as

select m.manufacturers_id,

m.manufacturers_name,

(select count(*) from products

where manufacturers_id=m.manufacturers_id)

as total

from manufacturers as m

order by m.manufacturers_id

---------------------------------------

select * from vContMaf