CREATE TABLE Alunos
(
  AlunoId INT NOT NULL,
  AlunoNm VARCHAR(80),
  AlunoEnd VARCHAR(80),
  AlunoTel VARCHAR(15),
  AlunoNota NUMERIC(10,2),
  PRIMARY KEY (AlunoId)
);

CREATE TABLE Professores
(
  ProfessorId INT NOT NULL,
  ProfessorNm VARCHAR(80),
  ProfessorEnd VARCHAR(80),
  ProfessorTel VARCHAR(15),
  ProfessorSal NUMERIC(10,2),
  PRIMARY KEY (ProfessorId)
);

INSERT INTO Alunos VALUES (1, "Carlos da Silva", "Rua X", "35 99999-9999", 10.5);
INSERT INTO Alunos VALUES (2, "Maria de Oliveira", "Av. Y", "35 99999-9999", 9.0);
INSERT INTO Alunos VALUES (3, "Pedro Antônio", "Tv. ABC", "35 99999-9999", 8.6);
INSERT INTO Alunos VALUES (4, "Carla Pereira", "Rua Dois", "35 99999-9999", 7.3);
INSERT INTO Alunos VALUES (5, "Paola Coutinho", "Rua Verde", "35 99999-9999", 6.1);

INSERT INTO Professores VALUES (1, "João", "Rua A", "35 99999-9999", 2015.65);
INSERT INTO Professores VALUES (2, "Keyla", "Rua T", "35 99999-9999", 1987.8);
INSERT INTO Professores VALUES (3, "Iara", "Av. Avenida", "35 99999-9999", 4598.6);
INSERT INTO Professores VALUES (4, "José", "Rua R", "35 99999-9999", 3215.1);
INSERT INTO Professores VALUES (5, "Beatriz", "Av. Rua", "35 99999-9999", 2897.0);

SELECT * FROM Alunos;

SELECT * FROM Professores;