Because you emulator will not allow Count(Distinct(marq)) then try

select count(marq) from Car c

where c.no IN (select max(no) from Car group by marq)

assuming that [no] is a record key.