i think this will be the answer for ur second question

create view new as
select vendorid,"nova"=count(invoiceqty) from invoice group by vendorid

select vendorname from vendors where
vendorid in(select vendorid from new where nova=(select max(nova) from new))