Table: mlb_draft_players_2
Columns: player
position
school
hometown
mlb_draft

Question: What is the hometown of the pitcher who's school was Saint Joseph Regional High School?
SQL: SELECT "hometown" FROM mlb_draft_players_2 WHERE "position" = 'Pitcher' AND "school" = 'Saint Joseph Regional High School'

Question:  What is the school of the player from Lake Charles, LA?
SQL: SELECT "school" FROM mlb_draft_players_2 WHERE "hometown" = 'Lake Charles, LA'

Question: Where was mlb draft for the player who's school was Carl Albert High School?
SQL: SELECT "mlb_draft" FROM mlb_draft_players_2 WHERE "school" = 'Carl Albert High School'

Question: What school did the player attend who's hometown was Montvale, NJ?
SQL: SELECT "school" FROM mlb_draft_players_2 WHERE "hometown" = 'Montvale, NJ'

Question: What is the school for the player who's hometown was Irvine, CA?
SQL: SELECT "school" FROM mlb_draft_players_2 WHERE "hometown" = 'Irvine, CA'