select count(distinct job_id) from hr.employees| COUNT(DISTINCTJOB_ID) | 19 |
|---|
select first_name,salary from hr.employees where manager_id =100 order by salary| FIRST_NAME | SALARY | Kevin | 5800 | Shanta | 6500 | Payam | 7900 | Matthew | 8000 | Adam | 8200 | Eleni | 10500 | Gerald | 11000 | Den | 11000 | Alberto | 12000 | Michael | 13000 | Karen | 13500 | John | 14000 | Lex | 17000 | Neena | 17000 |
|---|
select first_name, last_name,salary from (select first_name,last_name, salary,commission_pct,manager_id from hr.employees
where salary between 2000 and 3000)
where commission_pct is null or manager_id is null| FIRST_NAME | LAST_NAME | SALARY | Shelli | Baida | 2900 | Sigal | Tobias | 2800 | Guy | Himuro | 2600 | Karen | Colmenares | 2500 | Irene | Mikkilineni | 2700 | James | Landry | 2400 | Steven | Markle | 2200 | Mozhe | Atkinson | 2800 | James | Marlow | 2500 | TJ | Olson | 2100 | Michael | Rogers | 2900 | Ki | Gee | 2400 | Hazel | Philtanker | 2200 | John | Seo | 2700 | Joshua | Patel | 2500 | Randall | Matos | 2600 | Peter | Vargas | 2500 | Martha | Sullivan | 2500 | Girard | Geoni | 2800 | Anthony | Cabrio | 3000 | Timothy | Gates | 2900 | Randall | Perkins | 2500 | Vance | Jones | 2800 | Kevin | Feeney | 3000 | Donald | OConnell | 2600 | Douglas | Grant | 2600 |
|---|
select first_name, last_name,salary from (select first_name,last_name, salary,commission_pct,manager_id from hr.employees
where salary between 2000 and 3000)
where commission_pct is null or manager_id is null| FIRST_NAME | LAST_NAME | SALARY | Shelli | Baida | 2900 | Sigal | Tobias | 2800 | Guy | Himuro | 2600 | Karen | Colmenares | 2500 | Irene | Mikkilineni | 2700 | James | Landry | 2400 | Steven | Markle | 2200 | Mozhe | Atkinson | 2800 | James | Marlow | 2500 | TJ | Olson | 2100 | Michael | Rogers | 2900 | Ki | Gee | 2400 | Hazel | Philtanker | 2200 | John | Seo | 2700 | Joshua | Patel | 2500 | Randall | Matos | 2600 | Peter | Vargas | 2500 | Martha | Sullivan | 2500 | Girard | Geoni | 2800 | Anthony | Cabrio | 3000 | Timothy | Gates | 2900 | Randall | Perkins | 2500 | Vance | Jones | 2800 | Kevin | Feeney | 3000 | Donald | OConnell | 2600 | Douglas | Grant | 2600 |
|---|
select first_name, last_name, salary*12 as illik from hr.employees| FIRST_NAME | LAST_NAME | ILLIK | Steven | King | 288000 | Neena | Kochhar | 204000 | Lex | De Haan | 204000 | Alexander | Hunold | 108000 | Bruce | Ernst | 72000 | David | Austin | 57600 | Valli | Pataballa | 57600 | Diana | Lorentz | 50400 | Nancy | Greenberg | 144096 | Daniel | Faviet | 108000 | John | Chen | 98400 | Ismael | Sciarra | 92400 | Jose Manuel | Urman | 93600 | Luis | Popp | 82800 | Den | Raphaely | 132000 | Alexander | Khoo | 37200 | Shelli | Baida | 34800 | Sigal | Tobias | 33600 | Guy | Himuro | 31200 | Karen | Colmenares | 30000 | Matthew | Weiss | 96000 | Adam | Fripp | 98400 | Payam | Kaufling | 94800 | Shanta | Vollman | 78000 | Kevin | Mourgos | 69600 | Julia | Nayer | 38400 | Irene | Mikkilineni | 32400 | James | Landry | 28800 | Steven | Markle | 26400 | Laura | Bissot | 39600 | Mozhe | Atkinson | 33600 | James | Marlow | 30000 | TJ | Olson | 25200 | Jason | Mallin | 39600 | Michael | Rogers | 34800 | Ki | Gee | 28800 | Hazel | Philtanker | 26400 | Renske | Ladwig | 43200 | Stephen | Stiles | 38400 | John | Seo | 32400 | Joshua | Patel | 30000 | Trenna | Rajs | 42000 | Curtis | Davies | 37200 | Randall | Matos | 31200 | Peter | Vargas | 30000 | John | Russell | 168000 | Karen | Partners | 162000 | Alberto | Errazuriz | 144000 | Gerald | Cambrault | 132000 | Eleni | Zlotkey | 126000 |
|---|
select count(distinct job_id) from hr.employees| COUNT(DISTINCTJOB_ID) | 19 |
|---|
select first_name,salary from hr.employees where manager_id =100 order by salary| FIRST_NAME | SALARY | Kevin | 5800 | Shanta | 6500 | Payam | 7900 | Matthew | 8000 | Adam | 8200 | Eleni | 10500 | Gerald | 11000 | Den | 11000 | Alberto | 12000 | Michael | 13000 | Karen | 13500 | John | 14000 | Lex | 17000 | Neena | 17000 |
|---|
select first_name, last_name,salary from (select first_name,last_name, salary,commission_pct,manager_id from hr.employees
where salary between 2000 and 3000)
where commission_pct is null or manager_id is null| FIRST_NAME | LAST_NAME | SALARY | Shelli | Baida | 2900 | Sigal | Tobias | 2800 | Guy | Himuro | 2600 | Karen | Colmenares | 2500 | Irene | Mikkilineni | 2700 | James | Landry | 2400 | Steven | Markle | 2200 | Mozhe | Atkinson | 2800 | James | Marlow | 2500 | TJ | Olson | 2100 | Michael | Rogers | 2900 | Ki | Gee | 2400 | Hazel | Philtanker | 2200 | John | Seo | 2700 | Joshua | Patel | 2500 | Randall | Matos | 2600 | Peter | Vargas | 2500 | Martha | Sullivan | 2500 | Girard | Geoni | 2800 | Anthony | Cabrio | 3000 | Timothy | Gates | 2900 | Randall | Perkins | 2500 | Vance | Jones | 2800 | Kevin | Feeney | 3000 | Donald | OConnell | 2600 | Douglas | Grant | 2600 |
|---|
select first_name, last_name,salary from (select first_name,last_name, salary,commission_pct,manager_id from hr.employees
where salary between 2000 and 3000)
where commission_pct is null or manager_id is null| FIRST_NAME | LAST_NAME | SALARY | Shelli | Baida | 2900 | Sigal | Tobias | 2800 | Guy | Himuro | 2600 | Karen | Colmenares | 2500 | Irene | Mikkilineni | 2700 | James | Landry | 2400 | Steven | Markle | 2200 | Mozhe | Atkinson | 2800 | James | Marlow | 2500 | TJ | Olson | 2100 | Michael | Rogers | 2900 | Ki | Gee | 2400 | Hazel | Philtanker | 2200 | John | Seo | 2700 | Joshua | Patel | 2500 | Randall | Matos | 2600 | Peter | Vargas | 2500 | Martha | Sullivan | 2500 | Girard | Geoni | 2800 | Anthony | Cabrio | 3000 | Timothy | Gates | 2900 | Randall | Perkins | 2500 | Vance | Jones | 2800 | Kevin | Feeney | 3000 | Donald | OConnell | 2600 | Douglas | Grant | 2600 |
|---|
select first_name, last_name, salary*12 as illik from hr.employees| FIRST_NAME | LAST_NAME | ILLIK | Steven | King | 288000 | Neena | Kochhar | 204000 | Lex | De Haan | 204000 | Alexander | Hunold | 108000 | Bruce | Ernst | 72000 | David | Austin | 57600 | Valli | Pataballa | 57600 | Diana | Lorentz | 50400 | Nancy | Greenberg | 144096 | Daniel | Faviet | 108000 | John | Chen | 98400 | Ismael | Sciarra | 92400 | Jose Manuel | Urman | 93600 | Luis | Popp | 82800 | Den | Raphaely | 132000 | Alexander | Khoo | 37200 | Shelli | Baida | 34800 | Sigal | Tobias | 33600 | Guy | Himuro | 31200 | Karen | Colmenares | 30000 | Matthew | Weiss | 96000 | Adam | Fripp | 98400 | Payam | Kaufling | 94800 | Shanta | Vollman | 78000 | Kevin | Mourgos | 69600 | Julia | Nayer | 38400 | Irene | Mikkilineni | 32400 | James | Landry | 28800 | Steven | Markle | 26400 | Laura | Bissot | 39600 | Mozhe | Atkinson | 33600 | James | Marlow | 30000 | TJ | Olson | 25200 | Jason | Mallin | 39600 | Michael | Rogers | 34800 | Ki | Gee | 28800 | Hazel | Philtanker | 26400 | Renske | Ladwig | 43200 | Stephen | Stiles | 38400 | John | Seo | 32400 | Joshua | Patel | 30000 | Trenna | Rajs | 42000 | Curtis | Davies | 37200 | Randall | Matos | 31200 | Peter | Vargas | 30000 | John | Russell | 168000 | Karen | Partners | 162000 | Alberto | Errazuriz | 144000 | Gerald | Cambrault | 132000 | Eleni | Zlotkey | 126000 |
|---|
select count(distinct job_id) from hr.employees| COUNT(DISTINCTJOB_ID) | 19 |
|---|
select first_name,salary from hr.employees where manager_id =100 order by salary| FIRST_NAME | SALARY | Kevin | 5800 | Shanta | 6500 | Payam | 7900 | Matthew | 8000 | Adam | 8200 | Eleni | 10500 | Gerald | 11000 | Den | 11000 | Alberto | 12000 | Michael | 13000 | Karen | 13500 | John | 14000 | Lex | 17000 | Neena | 17000 |
|---|
select first_name, last_name,salary from (select first_name,last_name, salary,commission_pct,manager_id from hr.employees
where salary between 2000 and 3000)
where commission_pct is null or manager_id is null| FIRST_NAME | LAST_NAME | SALARY | Shelli | Baida | 2900 | Sigal | Tobias | 2800 | Guy | Himuro | 2600 | Karen | Colmenares | 2500 | Irene | Mikkilineni | 2700 | James | Landry | 2400 | Steven | Markle | 2200 | Mozhe | Atkinson | 2800 | James | Marlow | 2500 | TJ | Olson | 2100 | Michael | Rogers | 2900 | Ki | Gee | 2400 | Hazel | Philtanker | 2200 | John | Seo | 2700 | Joshua | Patel | 2500 | Randall | Matos | 2600 | Peter | Vargas | 2500 | Martha | Sullivan | 2500 | Girard | Geoni | 2800 | Anthony | Cabrio | 3000 | Timothy | Gates | 2900 | Randall | Perkins | 2500 | Vance | Jones | 2800 | Kevin | Feeney | 3000 | Donald | OConnell | 2600 | Douglas | Grant | 2600 |
|---|
select first_name, last_name,salary from (select first_name,last_name, salary,commission_pct,manager_id from hr.employees
where salary between 2000 and 3000)
where commission_pct is null or manager_id is null| FIRST_NAME | LAST_NAME | SALARY | Shelli | Baida | 2900 | Sigal | Tobias | 2800 | Guy | Himuro | 2600 | Karen | Colmenares | 2500 | Irene | Mikkilineni | 2700 | James | Landry | 2400 | Steven | Markle | 2200 | Mozhe | Atkinson | 2800 | James | Marlow | 2500 | TJ | Olson | 2100 | Michael | Rogers | 2900 | Ki | Gee | 2400 | Hazel | Philtanker | 2200 | John | Seo | 2700 | Joshua | Patel | 2500 | Randall | Matos | 2600 | Peter | Vargas | 2500 | Martha | Sullivan | 2500 | Girard | Geoni | 2800 | Anthony | Cabrio | 3000 | Timothy | Gates | 2900 | Randall | Perkins | 2500 | Vance | Jones | 2800 | Kevin | Feeney | 3000 | Donald | OConnell | 2600 | Douglas | Grant | 2600 |
|---|
select first_name, last_name, salary*12 as illik from hr.employees| FIRST_NAME | LAST_NAME | ILLIK | Steven | King | 288000 | Neena | Kochhar | 204000 | Lex | De Haan | 204000 | Alexander | Hunold | 108000 | Bruce | Ernst | 72000 | David | Austin | 57600 | Valli | Pataballa | 57600 | Diana | Lorentz | 50400 | Nancy | Greenberg | 144096 | Daniel | Faviet | 108000 | John | Chen | 98400 | Ismael | Sciarra | 92400 | Jose Manuel | Urman | 93600 | Luis | Popp | 82800 | Den | Raphaely | 132000 | Alexander | Khoo | 37200 | Shelli | Baida | 34800 | Sigal | Tobias | 33600 | Guy | Himuro | 31200 | Karen | Colmenares | 30000 | Matthew | Weiss | 96000 | Adam | Fripp | 98400 | Payam | Kaufling | 94800 | Shanta | Vollman | 78000 | Kevin | Mourgos | 69600 | Julia | Nayer | 38400 | Irene | Mikkilineni | 32400 | James | Landry | 28800 | Steven | Markle | 26400 | Laura | Bissot | 39600 | Mozhe | Atkinson | 33600 | James | Marlow | 30000 | TJ | Olson | 25200 | Jason | Mallin | 39600 | Michael | Rogers | 34800 | Ki | Gee | 28800 | Hazel | Philtanker | 26400 | Renske | Ladwig | 43200 | Stephen | Stiles | 38400 | John | Seo | 32400 | Joshua | Patel | 30000 | Trenna | Rajs | 42000 | Curtis | Davies | 37200 | Randall | Matos | 31200 | Peter | Vargas | 30000 | John | Russell | 168000 | Karen | Partners | 162000 | Alberto | Errazuriz | 144000 | Gerald | Cambrault | 132000 | Eleni | Zlotkey | 126000 |
|---|