CREATE TABLE funcionarios (
    id INT AUTO_INCREMENT PRIMARY KEY,
    nome VARCHAR(100) NOT NULL,
    departamento VARCHAR(50),
    salario DECIMAL(10,2),
    data_admissao DATE
);

-- Carga inicial original
INSERT INTO funcionarios (nome, departamento, salario, data_admissao) VALUES
('Ellen Ripley', 'Operacoes', 8500.00, '2120-05-14'), 
('Arthur Dallas', 'Operacoes', 9200.00, '2119-01-10'), 
('Ash', 'TI', 4500.00, '2121-03-01'), 
('Joan Lambert', 'TI', 6100.00, '2120-11-12'), 
('Dennis Parker', 'Engenharia', 7000.00, '2118-07-22'), 
('Carter Burke', 'Financeiro', 15000.00, '2179-02-15'), 
('Bishop', 'Pesquisa', 5500.00, '2179-05-10'), 
('Meredith Vickers', 'RH', 12000.00, '2093-12-21'), 
('David', 'TI', 4000.00, '2093-12-21'), 
('Elizabeth Shaw', 'Pesquisa', 9800.00, '2091-08-14'), 
('Peter Weyland', 'Diretoria', 99999.99, '2028-10-01'), 
('Walter', 'TI', 4200.00, '2104-12-05'), 
('Daniels', 'Operacoes', 7500.00, '2104-12-05'), 
('Amanda Ripley', 'Engenharia', 8000.00, '2137-11-15'), 
('Annalee Call', 'TI', 5000.00, '2381-04-12'), 
('Rain Carradine', 'Operacoes', 3500.00, '2142-08-01'), 
('Andy', 'TI', 3000.00, '2142-08-01');

-- COMANDO DO EXERCÍCIO: INSERÇÃO
INSERT INTO funcionarios (nome, departamento, salario, data_admissao) 
VALUES 
('Dwayne Hicks', 'Operacoes', 7200.00, '2179-07-01'),
('William Hudson', 'Operacoes', 6800.00, '2179-07-01');

SELECT * FROM funcionarios;