CREATE TABLE Sala (
idSala INT PRIMARY KEY,
Serie VARCHAR (45)
);

CREATE TABLE Alunos (
  idAluno INT PRIMARY KEY,
  idSala INT,
  Nome VARCHAR (45),
  Tel VARCHAR (45),
  Tel2 VARCHAR (45),
  Responsavel VARCHAR (45),
  FOREIGN KEY (idSala) REFERENCES Sala(idSala)
  
);


INSERT INTO Sala(idSala, Serie) VALUES (1, "6 A");
INSERT INTO Sala(idSala, Serie) VALUES (2, "6 B");
INSERT INTO Sala(idSala, Serie) VALUES (3, "7 A");
INSERT INTO Sala(idSala, Serie) VALUES (4, "7 B");
INSERT INTO Sala(idSala, Serie) VALUES (5, "7 C");
INSERT INTO Sala(idSala, Serie) VALUES (6, "8 A");
INSERT INTO Sala(idSala, Serie) VALUES (7, "8 B");
INSERT INTO Sala(idSala, Serie) VALUES (8, "8 C");
INSERT INTO Sala(idSala, Serie) VALUES (9, "9 A");
INSERT INTO Sala(idSala, Serie) VALUES (10, "9 B");
INSERT INTO Sala(idSala, Serie) VALUES (11, "9 C");
INSERT INTO Sala(idSala, Serie) VALUES (12, "9 D");




INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (1, 1, "ARTHUR LIMEIRA GERMANO", "(11) 972541567", "(11) 984173783", "MAE / PAI");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (2, 1, "ALISSON BOFI CAMARGO", "991089242", "991187975", "IRMÃO");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (3, 1, "ANA BEATRIZ FERREIRA BUENO", "981433185", "981433185", "MAE / PAI");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (4, 1, "ANA CLARA NUNES AMORIM", "997755141", NULL, "PADRASTO");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (5, 1, "ARTHUR LIMEIRA GERMANO", "988314148", NULL, NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (6, 1, "DANIEL DOS ANJOS PIEDADE", "996527220", "988118781", "MAE");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (7, 1, "DAVI ALESSANDRO SATURNINO LUIZ", "991190417", "991632751", "MAE / PAI");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (8, 1, "ELOA CRISTINA ATHANAZIO", "997269556", "997634665", NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (9, 1, "GABRIEL BIAGI SELMINI", "981146024", "981826252", NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (10, 1, "ISADORA FARIA DE CAMPOS", "996786369", "992468747", "MAE / PAI");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (11, 1, "JOAO PEDRO MANCINI", "996763603", "996663319", NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (12, 1, "JULIA PEREIRA DA SILVA SANTOS", "986230678", "988073807", NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (13, 1, "LORENA LOPES DA SILVA", "997082690", NULL, NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (14, 1, "MANUELLY BRUSGUI ROSA", "35246142", "991593379", "AVO");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (15, 1, "MARIA LETICIA FERREIRA DE MATTOS", "991625996", "991183193", NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (16, 1, "MICHELLY NASCIMENTO DE SOUZA", "997012052", "91574569", "TIA");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (17, 1, "MATHEUS OLIVEIRA SANTANA", "988387338", "988456228", "MAE / PAI");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (18, 1, "NICOLAS GABRIEL DOS SANTOS", "992299457", "992646535", "MAE / PAI");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (19, 1, "OTAVIO CUSTODIO DE ABREU", "997345850", "997734225", "MAE");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (20, 1, "SOPHIA VITORIA ALVES MARTINS", "993333694", "92395964", "AVO");


INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (21, 2, "ANA LIVIA AMARAL DOS ANJOS", "992080954", "97619451", NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (22, 2, "ANA LIVIA DOMINGOS RUEDA", "997341884", NULL, NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (23, 2, "BRUNA KAROLLINY LIMA DE OLIVEIRA", "991874556", "996478740", "MAE / IRMAO");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (24, 2, "DANIEL ERICK PAIVA DA SILVA", "996574311", "996024446", NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (25, 2, "DAVI HENRIQUE MONTEIRO VIEIRA", "35242806", "999741872", NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (26, 2, "DAVI LUIS SISTO", "991662119", "991908544", "PAI / AVO");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (27, 2, "EMANUELA XAVIER PEREIRA BARROS", "996162065", "996606006", NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (28, 2, "EMILLY LOURENCO DA SILVEIRA", "996165147", "992006537", NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (29, 2, "EVELLYN FARINELI DE ARAUJO", "997595605", "997461672", "MAE / PAI");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (30, 2, "GABRIELLY LARAYNE SANTANA DA SILVA", "988280965", "988091229", "TIA");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (31, 2, "HELOISA GABRIELLY DOS SANTOS", "991578644", NULL, NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (32, 2, "HELOIZE OLIVEIRA DE ANDRADE", "996279273", NULL, NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (33, 2, "HILLARY VITORIA MORAES MENDES DA SILVA", "988322093", NULL, NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (34, 2, "ISABELA VICTORIA PINTO AVERSANI", "991929819", NULL, NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (35, 2, "JONATAS OTAVIO ROCHA SORGI", "992714197", "31510785", "PAI / AVOS");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (36, 2, "KATRINY ELOA BARDELLA", "997019278", "35216186", NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (37, 2, "KAUAN FELIPE ALVES CESARINO", "996528737", "35222642", NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (38, 2, "KAUANE DA SILVA VOLPE", "988261029", "996512112", NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (39, 2, "LATIFA DE OLIVEIRA ABDEL HAMID", "35235123", NULL, NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (40, 2, "LORENA VIEIRA", "997522905", "997122686", NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (41, 2, "LUIZ OTAVIO DOS SANTOS", "991819931", NULL, NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (42, 2, "MANUELA ARGOLO DE SOUZA", "991055630", "35236324", "PAI / TIA");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (43, 2, "MARCOS MARIANO CANOVAS", "988081284", NULL, NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (44, 2, "MARIA CLARA APARECIDA GRANDISOLI", "992089367", "35235995", "PAI / AVOS");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (45, 2, "MATHEUS RIBEIRO ANACLETO", "997770165", "996466862", NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (46, 2, "MIGUEL DAVI MACENA MARIA", "988105263", NULL, NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (47, 2, "NICOLLY DA FONSECA PESSOA", "991056114", "35255323", NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (48, 2, "NICOLLY DE CAMPOS GODOY", "91684638", NULL, NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (49, 2, "PIETRA NICOLY NASCIMENTO TOLEDO", "996365679", "35242471", "IRMÃO");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (50, 2, "RUAN MOTA", "988319778", "996767861", "PAI / AVO");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (51, 2, "SAMUEL JONATAS MANOEL", "991831431", "991466859", NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (52, 2, "WANDERLEY DE ANDRADE NETO", "981105852", "35223222", NULL);




INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (53, 3, "ALICIA DOS SANTOS ALONSO", "992619655", "992577440", "MAE / IRMA");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (54, 3, "ANA CLARA DA SILVA BEZERRA", "996731235", "997219770", "MAE / PAI");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (55, 3, "ANA JULIA FELICIO RODRIGUES", "997064418", "997426213", "MAE / PAI");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (56, 3, "AQUILA FERNANDES LEONEL", "35214863", "992437034", NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (57, 3, "BARBARA RODRIGUES BRAZ", "35242596", "97051221", NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (58, 3, "BEATRIZ ALEXANDRE GONCALVES", "35242159", "35220737", "MAE");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (59, 3, "DAVI SIBIONI FERREIRA", "992807301", "35223320", NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (60, 3, "EDUARDA FERREIRA MINELLI", "997832366", "997657249", "MAE / PAI");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (61, 3, "ENZO SOUZA LAINE", "946637945", NULL, "AVO");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (62, 3, "EWERTON MIGUEL DAVID PESSOA", "996333518", "997066103", NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (63, 3, "GABRIEL ESPERANDIO", "91907770", "35235445	", NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (64, 3, "GABRIEL HENRIQUE FARIA", "991719211", "997817723", NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (65, 3, "GIOVANA DE OLIVEIRA DO PRADO", "996028920", "996040553", "GUARDA");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (66, 3, "GUSTAVO NERY MARE", "997418002", NULL, "PAI");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (67, 3, "HENRIQUE ANGELI DALTIN", "997531979", "991776395", NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (68, 3, "IGOR MARIANO DA SILVA", "996342908", NULL, "PAI");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (69, 3, "INGRID TAMAROZZI ARRUDA", "997174941", "981167249", "MAE / PAI");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (70, 3, "LIVIA BEATRIZ BEZERRA", "35216205", "16 992764481", NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (71, 3, "MATEUS CONQUISTA CAMILLO", "988332438", "988338215", "MAE / PAI");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (72, 3, "MIRELLA TRINDADE CAPELLO", "991081392", "997539169", "MAE / PAI");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (73, 3, "PEDRO NUNO PIRES RAHAL", "997513335", "991597241", NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (74, 3, "RAFAEL ANDREETTA JUNIOR", "996115264", "992805845", "MAE / PAI");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (75, 3, "SAMANTHA AGUSTINELI", "991742166", "997233159", NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (76, 3, "SOPHIA GARUTI MARCHESIM", "997479807", "997620908", "MAE / PAI");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (77, 3, "VITORIA GABRIELLY FERNANDES", "35238930", "992237901", NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (78, 3, "VIVIAN CRISTINE REIS DE OLIVEIRA", "991280571", NULL, NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (79, 3, "WENDEL BOFI", "981401327", "997886080", "MAE / PAI");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (80, 3, "YASMIN VIEIRA RODRIGUES", "992459418", "991304629", NULL);


INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (81, 4, "ALICE COSTA SILVA", "982279113", "996258287", NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (82, 4, "ANA GABRIELA PEQUENO CORDEIRO", "988153108", "997567057", "MADRASTA / PAI");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (83, 4, "ENZO GABRIEL DA COSTA VENTEU", "996075158", "997367474", "MAE / AVO");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (84, 4, "ERICK GUSTAVO XAVIER", "35118440", NULL, "MAE");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (85, 4, "GIOVANNA DE SOUZA BONALDI", "992112754", "991677258", "PAI");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (86, 4, "GUILHERME HENRIQUE DE MARIA", "996724737", "996232705", "MAE / IRMA");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (87, 4, "ISABELY DA SILVA BRAZ", "981197489", "35214907", NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (88, 4, "JOSE AUGUSTO MARTINS", "996085361", "997013660", NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (89, 4, "KAROLLINE LISBOA FUJITANI", "992094243", "996370860", "MAE / PAI");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (90, 4, "KAUA BATISTA BUGATTI", "988126026", "35217583", NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (91, 4, "LAIS DE SOUZA BONALDI", "992112754", "991637605", "PAI / AVO");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (92, 4, "LEONARDO ELIAS FERREIRA", "997237431", "997265988", "MAE / PAI");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (93, 4, "LUCAS JORGE BELUZIO", "996442103", "997513296", NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (94, 4, "MAICON HENRIQUE PEREIRA", "991466658", "991198913", "AVO");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (95, 4, "MANUELA VITORIA DE FARIA", "991779094", "996019489", "IRMA / AVO");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (96, 4, "MARIA CLARA PRADO DOS SANTOS", "992704450", "991374888", NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (97, 4, "MARIA EDUARDA BORSATO DA SILVA", "996610359", "988016884", "MAE / PAI");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (98, 4, "MARIA SOPHIA PERAL DA SILVA", "992295516", "997844355", "MAE / PAI");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (99, 4, "NICOLAS EDUARDO DE ALMEIDA VIEIRA", "988041694", NULL, NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (100, 4, "NICOLY PERIN POSTAL", "997224512", "992035129", "MAE / PAI");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (101, 4, "PEDRO PHELIPE FERNANDES", "988024689", "991578714", "MAE");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (102, 4, "RAUL RIBON BRUNELLI", "35221151", "997631790", "MAE");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (103, 4, "RUAN PABLO LEO", "988227273", "991739070", "MAE / AVO");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (104, 4, "TAUANY FERNANDA ALCANTARA DE JESUS", "992536696", "991011161", "MAE / PADRASTO");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (105, 4, "THABATA VITORIA BARBOSA", "992230542", "981372237", "MAE / TIA");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (106, 4, "VICTOR GABRIEL LOPES", "988225560", "991597311", "MAE / PAI");


INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (107, 5, "ANALICE ROBERTA DOS SANTOS", "996112111", "996687302", "MAE / PAI");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (108, 5, "BRENO PEDRETTI", "991417734", "35235024", NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (109, 5, "CAMILLY VIDOTTI TURRISSI", "997942377", "996027105", NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (110, 5, "DAVI KAUA FRANCISCO DA SILVA", "991295474", "992477526", "AVO / TIA");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (111, 5, "DAVI MIGUEL FERREIRA LONGHI", "996501825", "996540803", "MAE / PADRASTO");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (112, 5, "GIOVANNA VITÓRIA DO PRADO", "997533830", "991042089	", "TIA");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (113, 5, "JULIA VITORIA BENETASSO", "997095514", "996354440", "MAE / PAI");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (114, 5, "LAUANY DE FREITAS BARRIENTO", "992348741", "991872099", NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (115, 5, "LUCAS PATRIANI GOBETTI DE OLIVEIRA", "991176506", "35224641", NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (116, 5, "LUCAS RAFAEL VENANCIO", "991926144", "992611467", "MAE");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (117, 5, "MARIA ALICE VENTURIN GIANGIULIO", "991841622", "33116507", "MAE / PAI");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (118, 5, "MARIA JULIA GUSSONI", "992020025", "991521642", "MAE / PAI");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (119, 5, "MARIA LUIZA FERREIRA", "991799204", "996624896", "MAE / PAI");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (120, 5, "MARINA ISABELLA BELCHIOR", "988213815", "988005784", "MAE / PAI");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (121, 5, "NICOLAS NATHAN MOREIRA", "988151712", "996543782", "PAI");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (122, 5, "PIETRA VITORIA GOMES", "996296281", "997357389", "MAE / PADRASTO");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (123, 5, "PYETRO JOAQUIM LOURENCO", "35232552", NULL, "MAE");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (124, 5, "RAYANE ISABELLY DE OLIVEIRA", "991347881", NULL, "PAI");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (125, 5, "SOPHIA KAMILY DE PAULA DOS SANTOS", "997765369", "997751126	", "MAE / PAI");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (126, 5, "VITORIA CARVALHO DOS SANTOS", NULL, NULL, NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (127, 5, "YASMIN DE SOUZA PEREIRA", "991553039", "997245517", "MAE / PADRASTO");




INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (128, 6, "ALANA TORRES CASTANHEIRA", "997251223", "97333804", NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (129, 6, "AMARILIS NETTO SALVADOR", "35250666", "35317000", NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (130, 6, "ANNA CLARA MACHADO PEREIRA", "981712567", "992226189", NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (131, 6, "ARTHUR LIMA MACIEL", "991605572", "982208202", NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (132, 6, "ARTUR GUANDALINI ABELARDI", "981107009", NULL, NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (133, 6, "BEATRIZ MARTINS NOBREGA", "991681724", NULL, NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (134, 6, "CAROLINA DE PAULA BISCALCHIM", "981303111", "991950602", "MAE / AVO");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (135, 6, "DAVID NICOLLAS FELIX UHL", "997893186", "996832513", NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (136, 6, "EMANUELLI FERNANDA TEIXEIRA DOS SANTOS", "96476150", "91147220", NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (137, 6, "ENZO XAVIER DE MENEZES", "997882236", NULL, NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (138, 6, "HENRIQUE BALDUINO DE SOUZA", "996093348", "981623799", "MAE / PADRASTO");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (139, 6, "ISABELLA ONORATO DE LIMA", "996643978", NULL, "MAE");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (140, 6, "ISABELLI ROCHA LEITE", "997321657", "996169004", NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (141, 6, "IZADORA HAIM DO AMARAL SEVERIANO", "981827093", "988317062", "MAE / PAI");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (142, 6, "JHENIFER APARECIDA CARDOSO DA SILVA", "991316162", "35235211", NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (143, 6, "JOAO PEDRO ALVES DA CRUZ", "991998857", "991728251", "MAE / IRMA");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (144, 6, "JULIANA BUGATTI", "991263093", "991616917", "MAE / PAI");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (145, 6, "LAUENE RODRIGUES TOLEDO PIZA", "991190633", "991047304", NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (146, 6, "LOHANNA GRAZIELLY DA SILVA LOREDO", "997510650", "91002736", NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (147, 6, "LUCAS GABRIEL DARE DE ARAUJO", "992749379", "992239226", NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (148, 6, "MANUELLA CORSI DIONISIO DOS SANTOS", "988370960", "997154385", NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (149, 6, "MARIA CLARA FALCAO GARRIDO", "996482828", "996139565", NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (150, 6, "MARIA EDUARDA ESPEJO", "35221191", "981485095", NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (151, 6, "MARIANA DE LIMA SALVADOR", "987331256", "996618928", "MAE / PAI");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (152, 6, "MATHEUS MARGONAR", "96143711", "35252046", NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (153, 6, "MIGUEL CANALLI BARTOLI", "35214467", NULL, NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (154, 6, "NATIELE TAVARES", "35242613", "97924703", NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (155, 6, "PAMELA OLIVEIRA", "35253447", "991582812", NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (156, 6, "PAOLA MARTINS DOS PASSOS", "997255821", NULL, NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (158, 6, "PEDRO EMANUEL DA SILVA PRADO", "996294422", "997089746", NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (159, 6, "THALES EMANUEL SIBIONI FERREIRA", "97581664", NULL, NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (160, 6, "VALENTINA VITORIA FERREIRA HERNANDEZ", "997171162", NULL, "MAE");


INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (161, 7, "ANA CLARA TALASSI", "997172897", NULL, NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (162, 7, "ANNA JULIA GISSE LUIZ", "91351108", NULL, NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (163, 7, "BEATRIZ GIMENES RODRIGUES", "35214400", NULL, NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (164, 7, "BRYAN MIGUEL DE SOUZA CASSIMIRO", "992079921", "996037820", NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (165, 7, "DAVI MIGUEL SORGI", "996146720", "35216807", NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (166, 7, "DIEGO GUSELLA SOFIATO", "991111534", "981413423", NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (167, 7, "EMILLY VICTORIA TEIXEIRA DA SILVA", "981526994", "996331340", "TIA / AVO");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (168, 7, "FABRICIO MARTINS DE OLIVEIRA PANTALEAO", "991319480", "991813209", "MAE / PAI");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (169, 7, "GABRIEL DA SILVA PESSOA", "992846717", "991393517", NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (170, 7, "GILBERTO JÚNIOR CALIAN", "997567218", "991078634", NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (171, 7, "GUILHERME DA SILVA MEIRA", "991196801", "991658843", NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (172, 7, "JHONATHAN DIOGO GODOY GOMES", "988249953", "996116911", NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (173, 7, "KAUAN LANDIM ZAGO", "35220508", NULL, NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (174, 7, "LAURA ODILA MARTON VIEIRA", "35249666", "92142306", NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (175, 7, "LUCAS FELIPE DE OLIVEIRA", "997081070", "997510851", "MAE / PAI");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (176, 7, "MARIA CLARA MATOS DE PAULA", "996698253", "997021676", NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (177, 7, "MATHEUS AUGUSTO SEMINATTI", "997334469", "991635128", "MAE / PAI");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (178, 7, "MATHEUS PIERRE FURLAN", "988213002", "988018643", "MAE / PAI");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (179, 7, "MAXSUWEL JOAQUIM DA SILVA", "988006695", "992693568", "MAE / AVO");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (180, 7, "MIGUEL DE MORAIS ANTONIO", "9191171764", "91466878", NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (181, 7, "MURILLO AUGUSTO SEMINATTI", "997334469", "991635128", "MAE / PAI");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (183, 7, "MURILO XAVIER", "997882236", "97418825", NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (184, 7, "SOPHIA EDUARDA SBRAVATTI", "991802277", "991571724", "MKAE / PAI");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (185, 7, "VITORIA CRISTINA GONCALVES TEIXEIRA", "991062624", "992753288", NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (186, 7, "YASMIM SOPHIA SATURNINO LUIZ", "991190417", "991632751", "MAE / PAI");


INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (187, 8, "ANA JULIA RODRIGUES MEDRADO", "997593428", "996131323", NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (188, 8, "ANA LUISA MENDES DA SILVA", "97666348", "92047292", NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (189, 8, "ANA LUIZA PEREIRA DA SILVA", "997242576", "996053336", "MAE / AVO");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (190, 8, "CAIO SANTANA SANTOS", "997919630", "981153102", NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (191, 8, "DENSLEY ORESTE", "988122621", "988168758", "MAE / PAI");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (192, 8, "EMILY CRISTINA PIEDADE", "35761166", NULL, NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (193, 8, "ESTHER CASTILHO DE OLIVEIRA", "35226212", NULL, NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (194, 8, "GABRIEL LEITE PEREIRA", "997631466", "996146473", "MAE / IRMA");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (195, 8, "HELOISA CREPALDI STUCHI FERNANDES", "992482177", "988239755", "MAE / PAI");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (196, 8, "HIGOR PEDROSO VIEIRA SILVA", "996715530", "996132139", "MAE / PAI");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (197, 8, "JOAO PEDRO LIMA BARBERIO CASSONI", "996030373", NULL, NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (198, 8, "JULIA NAYUMI TANAKA", "997815449", "997361374", NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (199, 8, "LORENA DE SOUZA SANTOS", "97237221", NULL, NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (200, 8, "LORRAYNE GABRIELA SILVA BRAGA", "996060229	", NULL, NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (201, 8, "LUCAS ESTEVES DEL RE", "33116556", "991062530", NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (202, 8, "LUCAS RAFAEL CAROZIO", "991076997", "992492152", "PAI / TIA");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (203, 8, "MARIA CLARA JARDIM SIMOES", "981518960", "91073871", "MAE");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (204, 8, "MARIA EDUARDA PEGORARO DA SILVA", "981440081", "981745713", "MAE / PAI");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (205, 8, "MARIA HELOISA ANDRADE DOS SANTOS", "(11) 969083487", "(11) 970784116", "");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (206, 8, "MATHEUS NUO LI", "35319523", NULL, NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (207, 8, "MIGUEL LIMA BARBERIO CASSONI", "996030373", NULL, NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (208, 8, "OTAVIO PEREIRA DE OLIVEIRA AMORIM", "35236039", NULL, NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (209, 8, "SOFIA SANTANA BORGHETTO", "997021186", "996501186", "MAE / PAI");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (210, 8, "STHEFANY PAULINO DE OLIVEIRA", "996433386", "996700055", "PAI / AVO");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (211, 8, "VICTOR GABRIEL PINTO AVERSANI", "91230527", "91541371", NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (212, 8, "VITOR FRANCISCO DE SOUZA PAULO", "35234983", NULL, NULL);




INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (213, 9, "ANA BEATRIZ DA SILVA", "991305144", "997472922", "MAE / PAI");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (214, 9, "ANA SOPHIA FLORENCIO ANDRADE", "997063556", "992074212", NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (215, 9, "ANNY VITÓRIA FERNANDA DA SILVA", NULL, NULL, NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (216, 9, "BEATRIZ LIVORATI DE MORAES", NULL, NULL, NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (217, 9, "CAUA DE PAULA OLIVEIRA", "996072368", "996452654", "MAE");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (218, 9, "DAVI DE OLIVEIRA", "992320229", "996224126", "PAI / AVO");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (219, 9, "EDUARDA ALVES CORNACHIONI", "992174890", "991993092", "MAE / TIA");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (220, 9, "FRANCESCO TINTI CREPALDI", "96197606", NULL, NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (221, 9, "GABRIELLE ALVES COSTA", "991328048", "991900165", NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (222, 9, "GERALDO BASSANI DA SILVA NETTO", "991261202", "991023829", NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (223, 9, "GUILHERME SPINELLI ROTMEISTER", "996661023", "996635629", "MAE / PAI");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (224, 9, "IASMIN VIEIRA DA SILVA", "997552993", "996213638", NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (225, 9, "ISABELLA MANZZATTO", "996269223", "35211193", NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (226, 9, "LIVIA STEPHANY DE PAULA FERREIRA SOARES", "996671217", "997250863", "MAE / AVO");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (227, 9, "LUAN PRIOLI DE MORAES", "997687463", "997211331", NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (228, 9, "LUCAS ANTONIO BARBOSA AGUIAR", "996120460", "981119029", NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (229, 9, "MARIA EDUARDA IDALGO", "997476866", "996485304", NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (230, 9, "MARIA JULIA DORTAS GOMES", "988314823", "997038957", "MAE / PAI");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (231, 9, "MARIA LUISA DOS SANTOS VIRGILI", NULL, NULL, NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (232, 9, "MARIANE ANTUNES NICOLOSI", "996296536", "988014228", NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (233, 9, "MATHEUS DE MORAES BIANCHINI", "992812929", "35238954", NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (234, 9, "MICAELY SOARES VIEIRA", "996560507", "996562709", NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (235, 9, "MURILLO HENRIQUE LIMA", "988034381", "996458075", "MAE / PAI");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (236, 9, "MURILLO JORGE GOMES", "991048396", "992703159", "MAE / PAI");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (237, 9, "MURILO WOLKE GARON VICK", "996514170", "(19) 997248486", "PAI");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (238, 9, "REBECA GARCIA VIEIRA", "996391557", "35248350", NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (239, 9, "REBEKA MARCONDES DA CUNHA", "997638615", "35244634", NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (240, 9, "RENAN SOUZA LIMA", "997620090", "997660128", "MAE / PAI");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (241, 9, "SOPHIA RIZZI FERREIRA", "996063009", "997671020", "PAI");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (242, 9, "THARLLIE MORANDI BARBOSA", "992693523", NULL, NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (243, 9, "THULIO DOS SANTOS DOLTE", "996343332", "35211240", "MAE");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (244, 9, "TIAGO DE SOUZA NETO", "997011014", "997532145", "MAE");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (245, 9, "TIFFANY EMANUELLA DE JESUS LOURENÇO", "991664741", "33170133", "MAE");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (246, 9, "VICTORIA TELINI CARDOSO", "991131002", "35226928", NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (247, 9, "YASMIN TAGLIAVINI", "991833277", NULL, "MAE");


INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (248, 10, "ANA BEATRIZ DA SILVA GOMES", "988426769", "988429085", "PAI");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (249, 10, "ANA CAROLINA CANTON", "992014466", "996484019", NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (250, 10, "ARLEY MARTINS DOS SANTOS JÚNIOR", "981878501", NULL, "MAE");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (251, 10, "BIANCA APARECIDA ANDRADE PAULUCCI", "992606933", "991149270", "MAE / PAI");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (252, 10, "BRUNO BALERONI", "35245737", NULL, NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (253, 10, "CHRISTIAN EMANUEL MOREIRA", "996188130", NULL, NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (254, 10, "CLEBERSON FELIPE PRADO DA SILVA", "992270900", "997658691", "MAE / AVO");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (255, 10, "DAVI HENRIQUE GARBIN", "997255706", "35315300", NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (256, 10, "ELLOAH VITORIA NEVES DA SILVA", "981469844", "988111572", NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (257, 10, "ELOA VIEIRA ROCHA", "988134764", "991555420", "MAE / AVO");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (258, 10, "GABRIEL REVEJES TEODORO DE LIMA", "996245540", "996700442", "MAE / PAI");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (259, 10, "HENRIQUE MÓDENA GAVASSA", "996775711", "997566639", "MAE / PAI");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (260, 10, "ISABELA DE ALMEIDA", "997597830", "997842839", "MAE / PAI");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (261, 10, "ISADORA DE LIMA MATURE", "982273825", "35228113", "PAI");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (262, 10, "JEFFERSON BRUNO MARCIANO DA SILVA", "997549323", "991090338", NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (263, 10, "JENNYFFER BERNARDI", "997331661", NULL, "MAE");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (264, 10, "JÚLIA LOBO CAETANO", "996270714", "997094636", "MAE / PAI");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (265, 10, "LAURA SIQUEIRA DA SILVA", "997194169", "996122192", NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (266, 10, "LAVINIA PAVANELLO ARAUJO", "991645157", "35241238", NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (267, 10, "LAYLA GABRIELI DE ANDRADE", "982046095", NULL, NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (268, 10, "LEONARDO HENRIQUE POSSEBON MOREIRA", "997122410", "997768526", "MAE / IRMAO");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (269, 10, "LORENA FERRARI BOTA", "991606773", "991238535", "MAE / PAI");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (270, 10, "LUCAS MALAVAIS SILVA", "997515494", "992486110", NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (271, 10, "MARIA EDUARDA BARRIENTO", "988008934", "991364130", "MAE / PAI");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (272, 10, "MATHEUS GABRIEL PEREIRA DE JESUS", "946291098", "991045238", "MAE / IRMAO");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (273, 10, "MIGUEL ADRIANO DOS SANTOS", "992078783", "988144908", "MAE / PRIMA");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (274, 10, "NICOLY LOURENCO", "991798344", "991388963", "MAE / PAI");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (275, 10, "NYCOLAS BRUNO SCARPETA", "996657680", NULL, "MAEPEDRO HENRIQUE MARTINS DE FREITAS");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (276, 10, "PEDRO HENRIQUE MARTINS DE FREITAS", "991319480", "988174094", "MAE / TIA");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (277, 10, "PEDRO HENRIQUE POLIZELO", "996199657", "988221640", "MAE");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (278, 10, "PIETRA SOARES LUZ DE ANDRADE", "996172218", NULL, "PAI");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (279, 10, "VALENTINA SOUZA TASSI", "988001946", "997620868", NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (280, 10, "YASMIN PEZZOLITO DOS REIS", "992100013", "992033395", "MAE / PAI");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (281, 10, "YURI QUECORE CORNACHIONI", "991804386", "988259055", "MAE / PAI");


INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (282, 11, "ALECSANDRA RODRIGO RAMOS", "996763606", "996598702", NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (283, 11, "ANA JULIA DE SOUZA", "992433276", "35248365", NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (284, 11, "ANA JULIA MENDES LIMA", "997771695", "997135191", NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (285, 11, "BEATRIZ LENARA DE SOUZA DONATO", "991910605", "35222643", NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (286, 11, "BRENO VINICIUS TESSARI GRACIANO", "981383358", "982021169", NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (287, 11, "EDUARDO HENRIQUE MACEDO", "992858989", "991088184", "MAE / IRMAO");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (288, 11, "FELIPE GUSSI", "991627231", "35217990", "MAE / AVO");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (289, 11, "FELIPE LUÍS DALA COSTA", "981414031", "992743989", "MAE / AVO");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (290, 11, "GABRIEL HENRIQUE SOARES GONÇALVES", "991160437", "992635325", "MAE / TIA");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (291, 11, "GABRIELLY BEATRIZ PIANA", "997740113", "997175200", "MAE / PADRASTO");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (292, 11, "GIOVANNA BRIME", "997014552", NULL, NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (293, 11, "GIULIA MARTINS DA COSTA", "991488437", "992550220", "MAE / PAI");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (294, 11, "GUILHERME HENRIQUE NORATO", "991594050", "991601226", "MAE / PAI");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (295, 11, "GUSTAVO NUNES DE MENEZES", "992332440", "997755141", NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (296, 11, "HUGO HENRIQUE DA SILVA COSTA", "991623435", "991934915", NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (297, 11, "JUAN BAPTISTA DE CRESSIO", "997185144", "996010594", NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (298, 11, "KATIUSCIA SILVA TORTOL", "997447808", "996769420", "PADRASTO");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (299, 11, "LARA CEBRIAM DOSSO RUIZ", "988203521", NULL, NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (300, 11, "LARISSA SIMOES CEBRIAM", "997316002", "997555706", NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (301, 11, "LAVINIA GOMES ROJAS", "997766078", "991212139", NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (302, 11, "LETICIA AYUMI HARIMA", "996778389", NULL, NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (303, 11, "LETICIA BEATRIZ COSTA", "988063433", "988003584", "MAE / PAI");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (304, 11, "MANUELA CASARINI PEDROSA FERREIRA", "35248302	", NULL, NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (305, 11, "MARIA CLARA TALASSI DOS SANTOS", "991258896", "997265453", "MAE / PAI");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (306, 11, "MARYANA VITORIA ANDRADE DOS SANTOS", "997996657", "997543740", "MAE / PADRASTO");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (307, 11, "MIGUEL ARCANJO DE OLIVEIRA DIAS", "996391557", NULL, NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (308, 11, "MURILLO BENICIO PACHECO DA SILVA", "991857992", "997143278", NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (309, 11, "MURILO ANDREOTI OLIVEIRA", "997610549", "996146125", "MAE / PAI");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (310, 11, "NARA DE OLIVEIRA PENA", "988331940", NULL, "AVO");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (311, 11, "NATHAN VIEIRA RODRIGUES", "991304629", "991405453", "MAE");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (312, 11, "PIETRO NASCIMENTO CORREA", "991321835", "991391551", "PAI");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (313, 11, "PYETRO FERNANDO CREPALDI DOS SANTOS", "988254901", "996444718", "TIA");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (314, 11, "RAFAELA FERNANDA FRANCISCO", "997797220", "997250991", "AVO");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (315, 11, "RHAYSSA VITORIA DE SOUSA DA SILVA", "35221844", NULL, NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (316, 11, "WENDEL FERNANDO FARIA", "988425110", "997510175", "MAE / AVO");


INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (317, 12, "ARTHUR MAZARO MARTINS", "992074394", "35248391", NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (318, 12, "CAMILY DE OLIVEIRA ABDEL HAMID", "996230270", "35211115", NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (319, 12, "CAROLINE SANTOS DA SILVA", "988286865", "992395538", "MAE / AVO");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (320, 12, "CLARA SEMINATTI", "996518632", "997018551", "MAE / PAI");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (321, 12, "DANIEL LUCAS ZEFERINO NEVES", "997041298", "996458538", "MAE / TIA");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (322, 12, "DAVID MANZZATTO NETO", "996269223", "35211193", NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (323, 12, "DIOGO HENRIQUE ATTLIO PEDROSA", "992739024", "991924692", "MAE / PAI");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (324, 12, "FERNANDA STEFANI JOSE", "992066168", "997451777", NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (325, 12, "FERNANDO DAVI CARLECI FERNANDES", "991072639", NULL, NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (326, 12, "GABRIELA FERNANDA BARDUCO", "997061188", "35253147", NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (327, 12, "GIOVANY LIETI", "996054393", "996597593", NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (328, 12, "IAN GOMES RODRIGUES", "996437331", "35234104", NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (329, 12, "ISADORA APARECIDA GOMES", "988054230", "981128120", "MAE");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (330, 12, "IVAN CARLOS CORREA FROELICH", "996378137", "996141524", NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (331, 12, "JOAO ANTONIO BARREIROS EUFRAZIO", "997162671", "35236146", NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (332, 12, "JOÃO PEDRO TINTI CREPALDI", "997762068", "996197606", "MAE / PAI");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (333, 12, "KAUANY EDUARDA SIQUEROLLI RODRIGUES", "992255383", "996611290", "MAE / AVO");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (334, 12, "LAURA BARBOSA LUCIO", "991744969", "35212764", NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (335, 12, "LUANA GODOY MACEDO", "996680149", NULL, "MAE");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (336, 12, "MARIA EDUARDA TROVO", "35242346", NULL, NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (337, 12, "MARIA JÚLIA DE OLIVEIRA CANDIAN", "988848618", "989640503", NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (338, 12, "MARIANA RODRIGUES GONCALVES", "988318180", "988091672", NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (339, 12, "MELISSA BUENO DOS SANTOS", "988173730", "35221570", NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (340, 12, "MOYSES HENRIQUE MACHADO", "996134039", "996144039", NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (341, 12, "NAIANY BEATRIZ DA SILVA BRAZ", "988318195", "997072580", "MAE / PAI");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (342, 12, "NICOLLY EMMANUELLY MOREIRA", "988151712", "996543782", "PAI");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (343, 12, "PÉROLLA SANTOS DA SILVA", "991108176", "988294258", "MAE / PAI");
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (344, 12, "RODRIGO HIDEKI AGUETONI", "996140889", "997546976", NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (345, 12, "SAMUEL HENRIQUE DE SOUZA SANTOS", "992078453", "991750494", NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (346, 12, "VINICIUS GOMES PIRES", "997275335", "35244600", NULL);
INSERT INTO Alunos(idAluno, idSala, Nome, Tel, Tel2, Responsavel) VALUES (347, 12, "VITOR EDUARDO ALMEIDA DEL VECCHIO", "991507801", "991081490", "MAE / TIA");



SELECT Alunos.idAluno, Alunos.idSala, Sala.Serie, Alunos.Nome, Alunos.Tel, Alunos.Tel2, Alunos.Responsavel
FROM Alunos
INNER JOIN Sala ON Alunos.idSala = Sala.idSala
WHERE Alunos.idSala = 1

MySQL online editor

Write, Run & Share MySQL queries online using OneCompiler's MySQL online editor and compiler for free. It's one of the robust, feature-rich online editor and compiler for MySQL. Getting started with the OneCompiler's MySQL editor is really simple and pretty fast. The editor shows sample boilerplate code when you choose language as 'MySQL' and start writing queries to learn and test online without worrying about tedious process of installation.

About MySQL

MySQL is a open-source, free and very popular relational database management system which is developed, distributed and supported by Oracle corporation.

Key Features:

  • Open-source relational database management systems.
  • Reliable, very fast and easy to use database server.
  • Works on client-server model.
  • Highly Secure and Scalable
  • High Performance
  • High productivity as it uses stored procedures, triggers, views to write a highly productive code.
  • Supports large databases efficiently.
  • Supports many operating systems like Linux*,CentOS*, Solaris*,Ubuntu*,Windows*, MacOS*,FreeBSD* and others.

Syntax help

Commands

1. CREATE

CREATE TABLE table_name (
                column1 datatype,
                column2 datatype,
                ....);

Example

CREATE TABLE EMPLOYEE (
  empId INTEGER PRIMARY KEY,
  name TEXT NOT NULL,
  dept TEXT NOT NULL
);

2. ALTER

ALTER TABLE Table_name ADD column_name datatype;

Example

INSERT INTO EMPLOYEE VALUES (0001, 'Dave', 'Sales');

3. TRUNCATE

TRUNCATE table table_name;

4. DROP

DROP TABLE table_name;

5. RENAME

RENAME TABLE table_name1 to new_table_name1;

6. COMMENT

Single-Line Comments:

 --Line1;

Multi-Line comments:

   /* Line1,
   Line2 */

DML Commands

1. INSERT

INSERT INTO table_name (column1, column2, column3, ...) VALUES (value1, value2, value3, ...);

Note: Column names are optional.

Example

INSERT INTO EMPLOYEE VALUES (0001, 'Ava', 'Sales');

2. SELECT

SELECT column1, column2, ...
FROM table_name
[where condition];

Example

SELECT * FROM EMPLOYEE where dept ='sales';

3. UPDATE

UPDATE table_name
SET column1 = value1, column2 = value2, ...
WHERE condition;

Example

UPDATE EMPLOYEE SET dept = 'Sales' WHERE empId='0001';

4. DELETE

DELETE FROM table_name where condition;

Example

DELETE from EMPLOYEE where empId='0001';

Indexes

1. CREATE INDEX

  CREATE INDEX index_name on table_name(column_name);
  • To Create Unique index:
  CREATE UNIQUE INDEX index_name on table_name(column_name);

2. DROP INDEX

DROP INDEX index_name ON table_name;

Views

1. Create a View

Creating a View:
CREATE VIEW View_name AS 
Query;

2. How to call view

SELECT * FROM View_name;

3. Altering a View

ALTER View View_name AS 
Query;

4. Deleting a View

DROP VIEW View_name;

Triggers

1. Create a Trigger

CREATE TRIGGER trigger_name trigger_time trigger_event
    ON tbl_name FOR EACH ROW [trigger_order] trigger_body
/* where
trigger_time: { BEFORE | AFTER }
trigger_event: { INSERT | UPDATE | DELETE }
trigger_order: { FOLLOWS | PRECEDES } */

2. Drop a Trigger

DROP TRIGGER [IF EXISTS] trigger_name;

Stored Procedures

1. Create a Stored Procedure

CREATE PROCEDURE sp_name(p1 datatype)
BEGIN
/*Stored procedure code*/
END;

2. How to call Stored procedure

CALL sp_name;

3. How to delete stored procedure

DROP PROCEDURE sp_name;

Joins

1. INNER JOIN

SELECT * FROM TABLE1 INNER JOIN TABLE2 where condition;

2. LEFT JOIN

SELECT * FROM TABLE1 LEFT JOIN TABLE2 ON condition;

3. RIGHT JOIN

SELECT * FROM TABLE1 RIGHT JOIN TABLE2 ON condition;

4. CROSS JOIN

SELECT select_list from TABLE1 CROSS JOIN TABLE2;