How many short cars are in the shape of hexagon?
short cars refers to len = 'short'; in the shape of hexagon refers to shape = 'hexagon'
SELECT COUNT(id) FROM cars WHERE shape = 'hexagon' AND len = 'short'