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: Quais organizações foram fundadas em 1972, mas tornaram-se membros da WOSM até 1977?
 ###Tabelas: CREATE TABLE 2901–3000 (2901–3000_id AUTO_INCREMENT PRIMARY KEY, NGC number INT, Object type VARCHAR, Constellation VARCHAR, Right ascension ( J2000 ) VARCHAR, Declination ( J2000 ) VARCHAR) CREATE TABLE elementary_schools_grades_k-6 (elementary_schools_grades_k-6_id AUTO_INCREMENT PRIMARY KEY, Elementary Schools VARCHAR, Mascot VARCHAR, Address VARCHAR, Principal (2013-2014) VARCHAR, Assistant Principal (2013-2014) VARCHAR) CREATE TABLE table_of_world_organization_of_the_scout_movement_members (table_of_world_organization_of_the_scout_movement_members_id AUTO_INCREMENT PRIMARY KEY, Country VARCHAR, Membership (from 2010) INT, Name of member organization VARCHAR, Year current Scouting organization joined WOSM VARCHAR, Year member organization was founded VARCHAR, Admits boys/girls VARCHAR) CREATE TABLE other_awards (other_awards_id AUTO_INCREMENT PRIMARY KEY, Year INT, Award VARCHAR, Nominee VARCHAR, Episode VARCHAR, Result VARCHAR) CREATE TABLE 2008_london_revival (2008_london_revival_id AUTO_INCREMENT PRIMARY KEY, Year INT, Award VARCHAR, Category VARCHAR, Nominee VARCHAR, Result VARCHAR)  
SELECT Name of member organization FROM table_of_world_organization_of_the_scout_movement_members WHERE Year member organization was founded = 1972 AND Year current Scouting organization joined WOSM = 1977