Table: draft_history_15
Columns: round
pick
overall
name
position
college

Question: What is Arkansas State's total pick number with an overal lower than 242?
SQL: SELECT COUNT("pick") FROM draft_history_15 WHERE "college" = 'arkansas state' AND "overall" < 242

Question: Who is from the College of Cincinnati?
SQL: SELECT "name" FROM draft_history_15 WHERE "college" = 'cincinnati'

Question: What is the overall number for a kicker with a pick of less than 6?
SQL: SELECT COUNT("overall") FROM draft_history_15 WHERE "position" = 'kicker' AND "pick" < 6

Question: Which college has a defensive end with a round less than 6?
SQL: SELECT "college" FROM draft_history_15 WHERE "round" > 6 AND "position" = 'defensive end'