CREATE TABLE funcionarios (
    nome VARCHAR(100),
    departamento VARCHAR(50),
    salario DECIMAL(10,2),
    data_admissao DATE
);

INSERT INTO funcionarios (nome, departamento, salario, data_admissao) VALUES
('Marcelo', 'TI', 5200.00, '2021-03-10'),
('Sâmia', 'RH', 4300.00, '2019-07-15'),
('Karlla', 'Financeiro', 5800.00, '2018-11-20'),
('Ana Luiza', 'Marketing', 4700.00, '2020-05-12'),
('Anne', 'TI', 3600.00, '2022-09-17'),
('Eloah', 'RH', 4000.00, '2021-01-05'),
('Allan', 'TI', 6100.00, '2017-06-23'),
('Samuel', 'Financeiro', 5500.00, '2019-03-14'),
('Sophia', 'Marketing', 3900.00, '2023-08-30');


SELECT nome, departamento, salario
FROM funcionarios
ORDER BY salario DESC
LIMIT 10;


SELECT nome, departamento, salario, data_admissao
FROM funcionarios
WHERE departamento = 'TI'
ORDER BY data_admissao ASC;


SELECT nome, departamento, salario,
       salario * 1.15 AS salario_novo
FROM funcionarios
ORDER BY salario_novo DESC;


SELECT nome, departamento, salario, data_admissao
FROM funcionarios
ORDER BY departamento ASC, nome ASC;