SQL_HW1

console.sql

INSERT INTO employees (name, salary, department) VALUES
                                                     (N'Иван Петров', 75000.00, 'IT'),
                                                     (N'Алексей Смирнов', 60000.00, N'Маркетинг'),
                                                     (N'Мария Иванова', 55000.00, 'HR'),
                                                     (N'Дмитрий Кузнецов', 80000.00, 'IT'),
                                                     (N'Анна Соколова', 48000.00, N'Финансы'),
                                                     (N'Сергей Васильев', 65000.00, 'IT'),
                                                     (N'Ольга Морозова', 52000.00, 'HR'),
                                                     (N'Александр Белов', 90000.00, N'Маркетинг'),
                                                     (N'Екатерина Козлова', 43000.00, N'Финансы'),
                                                     (N'Павел Новиков', 70000.00, 'IT');
select * from employees

select name, salary from TOP_BV425.dbo.employees

select * from employees
         where salary >50000

select * from employees
order by salary desc

select top (3) name,salary from TOP_BV425.dbo.employees
order by salary desc