TydaJzxS

11.
2Desc hr.countries, hr.regions
3SELECT X
4FROM hr.countries, hr.regions
5WHERE X = ”Europa”
6ORDER by X asc;
7
82.
9SELECT SUM (państwa)
10FROM hr.countries, hr.regions
11WHERE region=Ameryka;
12
133.
14SELECT hr.countires.państwa, hr.regions.regiony
15FROM hr.countries, hr.regions
16WHERE hr.regions.Azja and hr.countries.państwa LIKE 'C%';
17
184.
19SELECT SUM (departamenty)
20FROM hr.departments;
21
225.
23SELECT MAX(salary) as wynagrodzenie, first_name as Imie, second_name as Nazwisko
24FROM hr.employees;
25
266.
27SELECT SUM*
28FROM hr.employees
29WHERE salary<średnia;
30
318.
32SELECT first_name as Imie, second_name as Nazwisko
33FROM hr.employees, hr.jobs <- ?????
34WHERE job_id='Sales Manager';
35
369.
37SELECT jobs as „Zawody”
38FROM hr.jobs
39WHERE salary>2400 and salary<5000;
40
4110.
42SELECT last_name as “Nazwisko”
43FROM hr.employees
44WHERE hire_date>=’1994/01/01’and hire_date <=’1994/12/31';
45
4611.
47SELECT SUM*
48FROM hr.employees
49WHERE email like '%_gmail.com';
50
5113.
52SELECT job_id as "wykonywane zawody"
53FROM hr.jobs;
54
5516. 
56SELECT first_name as Imie, last_name as Nazwisko, X as Kierownik
57FROM hr.employees;