CREATE DATABASE AAAEmpresa;
USE AAAEmpresa;
CREATE TABLE employees (
  emp_id int(11) NOT NULL,
  name varchar(45),
  posicion varchar(45),
  salary decimal(20,0),
  PRIMARY KEY (`emp_id`)
)ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

INSERT INTO employees VALUES (100,'Pedro Martin','secretario',25000),(101,'Hugo Sanchez','director',30000),(102,'Alicia Perez','comercial',45000),(105,'Marcos Zas','jefe',45000),(107,'Juan Fernandez','secretario',23000);
CREATE TABLE person (
  `id` int(11) NOT NULL,
  `name` varchar(45) DEFAULT NULL,
  `lastname` varchar(45) DEFAULT NULL,
  `age` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

INSERT INTO person VALUES (1,'Maria','Lopez',41),(2,'Sabela','Cee',33),(3,'Pedro','Martin',37),(4,'Lucia','Otero',38);