DOC 1 GRUD

#9
SELECT first_name,last_name,job_title AS JobTitle
FROM employees
WHERE salary BETWEEN 20000 AND 30000;

#10
SELECT CONCAT(first_name,' ',middle_name,' ',last_name)
AS 'FullName'
FROM employees
WHERE salary IN (25000,14000,12500,23600);
# WHERE salary=25000 OR salary=14000 OR salary=12500 OR salary=23600

#11
SELECT first_name,last_name
FROM employees
WHERE manager_id IS NULL;

#12
SELECT first_name,last_name,salary
FROM employees
WHERE salary > 50000
ORDER BY salary DESC;

#13
SELECT first_name,last_name
FROM employees
ORDER BY salary DESC
LIMIT 5;

#14
SELECT first_name,last_name
FROM employees
WHERE department_id <> 4;
#<> ozn razli4no, sujo moje i !=

#15 razli4ni dlujnosti
SELECT DISTINCT job_title AS 'Job_title'
FROM employees
ORDER BY job_title;
#as preimenuva samo za pokazvane na tablicata no ne promenq imeto i!!!

#16
SELECT * FROM projects
ORDER BY start_date,name
LIMIT 10;

#17 ORDER BY DESC E JOT GI PODREJDAME TEZI KOITO SA NAETI POSLEDNO
SELECT first_name,last_name,hire_date
FROM employees
ORDER BY hire_date DESC
LIMIT 7;

#18 UVELICHAVANE NA ZAPLATI, 1,2,4,11
SELECT salary AS Salary
FROM employees;

UPDATE employees
SET salary=salary*1.12
WHERE department_id IN (1,2,4,11);

#19
USE geography;

SELECT peak_name
FROM peaks
ORDER BY peak_name;

#20 nai-golemi po naselenie straini
SELECT country_name,population
FROM countries
WHERE continent_code = 'EU'
ORDER BY population DESC
LIMIT 30;

#21 STRAINI I VALUTA, kogato urrency_code='EUR' tr da stane ravno na Euro(then)
SELECT country_name,country_code,
(CASE
    WHEN currency_code='EUR' THEN 'Euro'
    ELSE 'Not Euro'
END) AS currency
FROM countries
ORDER BY country_name;

#22 VSI4KI SIMVOLI DIABLO
USE diablo;
SELECT name FROM characters
ORDER BY name;

#1 DOC 2
USE soft_uni;

INSERT INTO towns(name)
VALUES  ('Sofia'),
        ('Plovdiv'),
        ('Varna'),
        ('Burgas');

SELECT * FROM departments;

INSERT INTO departments(name,manager_id)
VALUES  ('Engineering',3),
        ('Sales',1),
        ('Marketing',7),
        ('Software Development',21),
        ('Quality Assurance',42);

INSERT INTO employees(first_name,middle_name,last_name,job_title,department_id,hire_date,salary)
VALUES  ('Ivan','Ivanov', 'Ivanov','.NET Developer',20,'2013-02-01',3500.00),
        ('Petar','Petrov','Petrov','Senior Engineer',1,'2004-03-02',3500.00),
        ('Maria','Petrova','Ivanov','Intern',13,'2016-08-28',545.25),
        ('Georgi','Terziev','Ivanov','CEO',3,'2007-12-09',3000.00),
        ('Peter','Pan','Pan','Intern',4,'2016-08-28',599.88);