Table: kevin_brooks
Columns: round
pick
name
position
school

Question: How many picks does Matt Moran have altogether after round 6?
SQL: SELECT COUNT("pick") FROM kevin_brooks WHERE "name" = 'matt moran' AND "round" > 6

Question: What position after round 8 has a pick less than 270?
SQL: SELECT "position" FROM kevin_brooks WHERE "round" > 8 AND "pick" < 270

Question: What is the total number of rounds that UCLA has?
SQL: SELECT COUNT("round") FROM kevin_brooks WHERE "school" = 'ucla'

Question: What is the lowest round for Georgia Tech?
SQL: SELECT MIN("round") FROM kevin_brooks WHERE "school" = 'georgia tech'

Question: What is the average round for Georgia Tech with a pick greater than 103?
SQL: SELECT AVG("round") FROM kevin_brooks WHERE "school" = 'georgia tech' AND "pick" > 103