We are planning on buying a new vehicle and we are choosing between the Hyundai Accent hatchback and the Chevrolet Spin because these two vehicles are the most fuel efficient from what we have known so far and these two are just right on our budget (less than 900k)

My friend suggested me not to buy an automatic transmission as buying either one of the two vehicles I mentioned for fuel efficiency purposes will be defeated but I am still wondering if there is really an automatic transmission vehicle that comes near to the fuel efficiency of a manual transmission vehicle?