Here you can look up the EPA estimated MPG for any car or truck since the '80's.
Search by Model
They changed the test procedure during that time but they've standardized all the published numbers at that site so you get an even comparison between models.
Like I said before, pick your year and take a look at the Ford Ranger/Mazda B-series.