Table: mike_hart
Columns: rank
name
attempts
net_yds
yds_att
touchdowns
long
start

Question: How many touchdowns did the player with less than 4495 yards, long of less than 80, and yds/att less than 5.5 have?
SQL: SELECT COUNT("touchdowns") FROM mike_hart WHERE "net_yds" < 4495 AND "long" < 80 AND "yds_att" < 5.5

Question: How many attempts did the player ranking with a number higher than 1, who started after 1997 and had yds/att of 5 have?
SQL: SELECT SUM("attempts") FROM mike_hart WHERE "start" > 1997 AND "yds_att" = 5 AND "rank" > 1

Question: What is the average net yds for the player who had a long of 68 and started after 1984?
SQL: SELECT AVG("net_yds") FROM mike_hart WHERE "long" = 68 AND "start" > 1984

Question: What is the lowest number of attempts for the player with a rank number larger than 3, who started after 1984 and had less than 6.1 yds/att?
SQL: SELECT MIN("attempts") FROM mike_hart WHERE "rank" > 3 AND "start" > 1984 AND "yds_att" < 6.1