- Exiba todos os pacientes.
- Exiba todos os pacientes com idades menores que 18.
- Apresente todos medicos com especialidade Odontologia.
- Exiba todos os pacientes com idades entre 20 e 40 anos.
- Apresente todas as consultas.
- Apresente todas as consultas com nome do paciente e nome do médico.
- Exiba todas as consultas de retorno com pacientes que tem mais de 30 anos.
- Mostre a lista com todas as consultas feitas pela médica Denise.
We can't make this file beautiful and searchable because it's too large.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Employee ID,Date of Joining,Gender,Company Type,WFH Setup Available,Designation,Resource Allocation,Mental Fatigue Score,Burn Rate | |
fffe32003000360033003200,2008-09-30,Female,Service,No,2.0,3.0,3.8,0.16 | |
fffe3700360033003500,2008-11-30,Male,Service,Yes,1.0,2.0,5.0,0.36 | |
fffe31003300320037003900,2008-03-10,Female,Product,Yes,2.0,,5.8,0.49 | |
fffe32003400380032003900,2008-11-03,Male,Service,Yes,1.0,1.0,2.6,0.2 | |
fffe31003900340031003600,2008-07-24,Female,Service,No,3.0,7.0,6.9,0.52 | |
fffe3300350037003500,2008-11-26,Male,Product,Yes,2.0,4.0,3.6,0.29 | |
fffe33003300340039003100,2008-01-02,Female,Service,No,3.0,6.0,7.9,0.62 | |
fffe32003600320037003400,2008-10-31,Female,Service,Yes,2.0,4.0,4.4,0.33 | |
fffe32003200300034003700,2008-12-27,Female,Service,No,3.0,6.0,,0.56 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
mpg | cylinders | displacement | horsepower | weight | acceleration | model year | origin | car name | |
---|---|---|---|---|---|---|---|---|---|
18 | 8 | 307 | 130 | 3504 | 12 | 70 | 1 | chevrolet chevelle malibu | |
15 | 8 | 350 | 165 | 3693 | 11.5 | 70 | 1 | buick skylark 320 | |
18 | 8 | 318 | 150 | 3436 | 11 | 70 | 1 | plymouth satellite | |
16 | 8 | 304 | 150 | 3433 | 12 | 70 | 1 | amc rebel sst | |
17 | 8 | 302 | 140 | 3449 | 10.5 | 70 | 1 | ford torino | |
15 | 8 | 429 | 198 | 4341 | 10 | 70 | 1 | ford galaxie 500 | |
14 | 8 | 454 | 220 | 4354 | 9 | 70 | 1 | chevrolet impala | |
14 | 8 | 440 | 215 | 4312 | 8.5 | 70 | 1 | plymouth fury iii | |
14 | 8 | 455 | 225 | 4425 | 10 | 70 | 1 | pontiac catalina |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
DATE | WIND | IND | RAIN | IND.1 | T.MAX | IND.2 | T.MIN | T.MIN.G | |
---|---|---|---|---|---|---|---|---|---|
1961-01-01 | 13.67 | 0 | 0.2 | 0 | 9.5 | 0 | 3.7 | -1 | |
1961-01-02 | 11.5 | 0 | 5.1 | 0 | 7.2 | 0 | 4.2 | 1.1 | |
1961-01-03 | 11.25 | 0 | 0.4 | 0 | 5.5 | 0 | 0.5 | -0.5 | |
1961-01-04 | 8.63 | 0 | 0.2 | 0 | 5.6 | 0 | 0.4 | -3.2 | |
1961-01-05 | 11.92 | 0 | 10.4 | 0 | 7.2 | 1 | -1.5 | -7.5 | |
1961-01-06 | 10.67 | 0 | 0 | 0 | 6.5 | 0 | 1.2 | -2 | |
1961-01-07 | 9.17 | 0 | 1.9 | 0 | 9.2 | 1 | -2.4 | -7.1 | |
1961-01-08 | 14.29 | 0 | 0 | 0 | 6.6 | 0 | 3.1 | 0 | |
1961-01-09 | 8.04 | 0 | 8.3 | 0 | 6.8 | 0 | 2.4 | -0.8 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
CREATE SCHEMA fipe; | |
USE fipe; | |
CREATE TABLE fipe( | |
codigo VARCHAR(10) NOT NULL, | |
ano DATE, | |
combustivel TEXT, | |
marca VARCHAR(50), | |
modelo TEXT, | |
siglacombustivel VARCHAR(1), |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
CREATE SCHEMA hospital; | |
USE hospital; | |
CREATE TABLE IF NOT EXISTS paciente ( | |
id INT NOT NULL AUTO_INCREMENT, | |
nome TEXT NULL, | |
idade INT NULL, | |
PRIMARY KEY (id)); | |
CREATE TABLE IF NOT EXISTS medico ( |
- Exiba todos os clientes.
- Apresente todos os hoteis.
- Apresente todos os quartos ocupados.
- Exiba todos os quartos do Praia Hotel.
- Apresente a lista de todas as reservas.
- Apresente os quartos com check-in em 2022.
- Exiba todos os quartos para hotéis com café da manhã.
- Apresente todas as reservas do Hotel Fasano que estão com quartos desocupados.
- Exiba todos os quartos de hotéis com 4 estrelas ou menos que suportem três pessoas ou mais.
- Exiba todos quartos presidenciais de hotéis 5 estrelas com checkin no mês de agosto.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
INSERT INTO | |
hotel(nome, classificacao, endereco, cafe_da_manha) | |
VALUES | |
("Hilton", 4, "Av. Presidente Vargas", 1), | |
("Ibis", 3, "Av. Nazare", 0), | |
('Gran Hotel',4,'Rua do Jardim', 1), | |
("Dom Ricardo Curitiba |", 4,"Av. Rocha Pombo, 2400", 1), | |
('Praia Hotel', 5, 'Avenida das Nações', 1), | |
('Rio Poty', 3, 'Av. dos Holandeses', 1), | |
('Fasano', 5, 'Av. Vieira Souto, 80 - Ipanema', 1), |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
CREATE SCHEMA hotelaria; | |
USE hotelaria; | |
CREATE TABLE hotel( | |
id INT PRIMARY KEY NOT NULL AUTO_INCREMENT, | |
nome TEXT NOT NULL, | |
classificacao INT, # estrelas | |
endereco TEXT, | |
cafe_da_manha BIT # BOOLEAN | |
); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
CREATE SCHEMA datablue; | |
USE datablue; | |
CREATE TABLE funcionario( | |
id INT NOT NULL PRIMARY KEY AUTO_INCREMENT, | |
nome TEXT, | |
salario FLOAT, | |
estado VARCHAR(2) | |
); |