CREATE DATABASE IF NOT EXISTS test;
USE test;

CREATE TABLE IF NOT EXISTS emp_list(
id INT UNSIGNED NOT NULL AUTO_INCREMENT primary key,
first_name VARCHAR(30) NOT NULL,
last_name VARCHAR(30) NOT NULL,
job_position  VARCHAR(20) NOT NULL,
salary decimal(15,2) UNSIGNED,
);

INSERT INTO emp_list ( id, first_name, last_name, job_position, salary) VALUES ( null, 'Ivan', 'Noscov', 'Director', 69000);
INSERT INTO emp_list ( id, first_name, last_name, job_position, salary) VALUES ( null, 'Igor', 'Malov', 'Accountant', 54000);
INSERT INTO emp_list ( id, first_name, last_name, job_position, salary) VALUES ( null, 'Ira', 'Solnceva', 'Salesperson', 27000);
INSERT INTO emp_list ( id, first_name, last_name, job_position, salary) VALUES ( null, 'Ivan', 'Noscov', 'Security guard', 15000);
UPDATE employees.emp_list SET last_name = 'Varnaev' WHERE id=4; 
INSERT INTO emp_list ( id, first_name, last_name, job_position, salary) VALUES ( null, 'Natasha', 'Bolshova', 'Salesperson', 27000);