CREATE TABLE table_name_48 (car VARCHAR2, yards VARCHAR2, avg VARCHAR2)

How many carries for the player with under 6 yards and an average of over 5?
SELECT COUNT(car) FROM table_name_48 WHERE yards < 6 AND avg > 5
SELECT COUNT("car") FROM "table_name_48" WHERE "avg" > 5 AND "yards" < 6