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: Em qual rodada foi selecionado o 1b e assinou com os Cardinals - junho de 1969?
 ###Tabelas: CREATE TABLE series_1_round_summary_top_24 (series_1_round_summary_top_24_id AUTO_INCREMENT PRIMARY KEY, Name/Name of Act VARCHAR, Age(s) VARCHAR, Genre VARCHAR, Act VARCHAR, Hometown VARCHAR, Semifinal (Week) INT, Position Reached VARCHAR) CREATE TABLE schools (schools_id AUTO_INCREMENT PRIMARY KEY, School name VARCHAR, address VARCHAR, students INT, grades VARCHAR, 2007 API INT) CREATE TABLE vocabulary_comparison (vocabulary_comparison_id AUTO_INCREMENT PRIMARY KEY, English VARCHAR, Scots VARCHAR, West Frisian VARCHAR, Afrikaans VARCHAR, Dutch VARCHAR, Dutch ( Limburgish ) VARCHAR, Low German VARCHAR, Low German ( Groningen ) VARCHAR, Middle German ( Luxemburgish ) VARCHAR, German VARCHAR, Yiddish VARCHAR, Gothic VARCHAR) CREATE TABLE january_secondary_phase (january_secondary_phase_id AUTO_INCREMENT PRIMARY KEY, Round INT, Name VARCHAR, Position VARCHAR, School VARCHAR, Signed VARCHAR) CREATE TABLE former_teams (former_teams_id AUTO_INCREMENT PRIMARY KEY, Institution VARCHAR, Location VARCHAR, Founded INT, Affiliation VARCHAR, Enrollment INT, Team Nickname VARCHAR, Primary conference VARCHAR)  
SELECT COUNT Round FROM january_secondary_phase WHERE Position = 1b AND Signed = no cardinals - 1969 june