CREATE DATABASE base;

USE base
CREATE TABLE departments(
department_id INT IDENTITY(1,1) PRIMARY KEY,
name VARCHAR(200) NOT NULL
);

CREATE TABLE employees(
employee_id INT IDENTITY(1,1) PRIMARY KEY,
name VARCHAR(300) NOT NULL,
department_id INT FOREIGN KEY REFERENCES departments(department_id) ON UPDATE CASCADE ON DELETE CASCADE,
birthday DATETIME
);

CREATE TABLE salaries(
salary_id INT IDENTITY(1,1) PRIMARY KEY,
employee_id INT FOREIGN KEY REFERENCES employees(employee_id) ON UPDATE CASCADE ON DELETE CASCADE,
amount MONEY
);


USE base

INSERT INTO departments (name)
VALUES
('Отдел кадров'),
('отдел продаж'),
('отдел производств')

INSERT INTO employees (department_id,name,birthday)
VALUES
(1, 'Иван Сергееевич Дрозд', '15.05.2000'),
(2, 'Сергей Владимирович Донсокй', '11.03.1992'),
(3, 'Ярослав Николаевич Понасенко', '12.01.1996')

INSERT INTO salaries (employee_id,amount)
VALUES
(1, 24000),
(2, 32000),
(3, 31000)

#Задания:
1)
USE base
SELECT department_id, name FROM departments

2)
USE base
SELECT name FROM employees
WHERE department_id = 2

3)
USE base
SELECT birthday FROM employees
WHERE birthday >= '01.01.1995' AND birthday <= '31.01.1995'

4)
USE base
SELECT amount FROM salaries
WHERE amount BETWEEN 30000 AND 69999

5)
USE base
SELECT * FROM salaries
ORDER BY amount DESC

6)
USE base
SELECT * FROM employees
WHERE name LIKE 'Иванов%'

7)
USE base
SELECT department_id FROM departments
WHERE name = 'Отдел кадров'