Abaixo está uma instrução que descreve uma tarefa de geração de SQL, combinada com uma entrada que fornece mais contexto sobre os esquemas de tabela disponíveis. Escreva o código SQL que responda adequadamente à solicitação
 ###Instrução: Qual é a aquisição via que possui uma equipe escolar ou de clube estadual?
 ###Tabelas: CREATE TABLE current_bus_fleet_roster (current_bus_fleet_roster_id AUTO_INCREMENT PRIMARY KEY, Order Year INT, Fleet Series (Qty.) VARCHAR, Manufacturer VARCHAR, Model VARCHAR, Powertrain (Engine/Transmission) VARCHAR, Fuel or Propulsion VARCHAR, Division VARCHAR) CREATE TABLE g (g_id AUTO_INCREMENT PRIMARY KEY, Name VARCHAR, Position VARCHAR, Number INT, School/Club Team VARCHAR, Season VARCHAR, Acquisition via VARCHAR) CREATE TABLE points_system (points_system_id AUTO_INCREMENT PRIMARY KEY, Distance VARCHAR, 10th INT, 11th INT, 12th INT, 13th INT, 14th INT, 15th INT, 16th INT, 17th INT, 18th INT, 19th INT, 20th INT, 21st INT, 22nd INT, 23rd INT, 24th INT, 25th INT, 26th INT, 27th INT, 28th INT, 29th INT, 30th INT, 31st INT, 32nd INT) CREATE TABLE pga_tour_professional_career_summary (pga_tour_professional_career_summary_id AUTO_INCREMENT PRIMARY KEY, Year INT, Starts INT, Cuts made VARCHAR, Wins (Majors) VARCHAR, 2nd INT, 3rd INT, Top 10 INT, Top 25 INT, Earnings ($) INT, Money list rank INT, Adjusted scoring average (rank) VARCHAR) CREATE TABLE top_ten_medals (top_ten_medals_id AUTO_INCREMENT PRIMARY KEY, Rank INT, Province VARCHAR, Gold INT, Silver INT, Bronze INT, Total INT)  
SELECT Acquisition via FROM g WHERE School/Club Team = state