Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- /**/
- DROP DATABASE EMPRESA;
- CREATE DATABASE EMPRESA;
- USE EMPRESA;
- CREATE TABLE FUNCIONARIO (
- COD_FUNC INT,
- CPF VARCHAR(11),
- NOME VARCHAR(100),
- DEPARTAMENTO INT,
- TELEFONE VARCHAR(10),
- FUNCAO VARCHAR(30),
- SALARIO FLOAT,
- PRIMARY KEY (COD_FUNC)
- );
- CREATE TABLE DEPARTAMENTO (
- COD_DEP INT,
- NOME VARCHAR(100),
- PRIMARY KEY (COD_DEP)
- );
- INSERT INTO FUNCIONARIO VALUES
- (1,'12345678912','joao',1,'6291234563','vendedor',1000.00),
- (2,'11145678912','jose',1,'6299234563','vendedor',4000.00),
- (3,'33345678912','maria',1,'6499234563','vendedora',2000.00),
- (4,'31145678912','isabel',1,'6484234563','vendedora',2500.00),
- (5,'31145678912','leticia',1,'6196234563','vendedora',5000.00),
- (6,'22145678912','ricardo',2,'6199234563','gerente',10000.00),
- (7,'22145678912','manuel',2,'6284454563','assistente',1200.00),
- (8,'88145678912','raimundo',3,'6681454563','gestor',2200.00),
- (9,'99145678912','joares',3,'6781454563','tecnico',800.00),
- (10,'10145678912','joana',4,'6799454563','analista',3000.00),
- (11,'11145678912','lurdes',4,'6699454563','analista',3000.00),
- (12,'12145678912','severino',5,'6699454563','faz tudo',1000.00),
- (13,'11145678912','livia',4,'1399454563','analista',3000.00),
- (14,'14145678912','marcela',4,'1499454563','analista',3000.00);
- INSERT INTO DEPARTAMENTO VALUES
- (1,'vendas'),
- (2,'financeiro'),
- (3,'RH'),
- (4,'TI'),
- (5,'manutencao');
- SELECT NOME,SALARIO FROM FUNCIONARIO WHERE SALARIO>2000.00;
- SELECT COUNT(*) AS 'Salário > 2000' FROM FUNCIONARIO WHERE SALARIO>2000.00;
- SELECT MAX(SALARIO) AS 'Maior Salário' FROM FUNCIONARIO;
- SELECT AVG(SALARIO) AS 'Média Salarial' FROM FUNCIONARIO;
- SELECT COUNT(*) AS 'Vendedores' FROM FUNCIONARIO WHERE DEPARTAMENTO = 1;
- SELECT FUNCIONARIO.NOME AS 'Funcionário(a)', FUNCIONARIO.DEPARTAMENTO AS 'departamento', DEPARTAMENTO.NOME AS 'Nome do Departamento' FROM FUNCIONARIO,DEPARTAMENTO WHERE DEPARTAMENTO.COD_DEP = FUNCIONARIO.DEPARTAMENTO;
- SELECT FUNCIONARIO.DEPARTAMENTO AS 'departamento',
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement