SBD k2 05 g1

	rt.Ł»,rK.'), im	• , C .* rnfM*
	frva"fi <NP M G M 1	i* t: u.u»>. 4^
0«J<FcJ- jUSt”*	f łci * AJ 4 WV(, ( L#!'	"•43-vV-
SBD	TEST 2	(ORACLE)
^#(4 dw Iw4 iA»	• jitiA

f^v«^\    ^At- 0>*3APfr --U i¹

.    a'*-!*

kA*** «    a

4.

+■

8

1

-4

~v

I.Find all people working as CLERK and employed after ADAMS.Display results ordered by hiredates.

T M«r « X fct n< '■* i r •

'VI ”

J Jv4w.

SeJecI jpb,wmp »u«,f    i

NT£RCŁCT

' 6tktA j**” \ro*K E-MP    • >0

.__c_fSl

I *et»c^ łtoawi* _f (""I(4° l)~ (rou,    UlWAM

2. Find all jobs which appear both in department 10 and in department 20.

3.Find people who eam the lowest salary for their job and grade.

iW

4. Ho w many people eam less than the maximal salary for the department located in NEW YORK.

5.For each manager find the number of his subordinate.Display name of the manager and the number of people working under his supervision._

6. Find all employees (personal

number,name,profession and salary), who eam less than the average salary for people with salaries in the third grade. Display results order by salaries ascending._

7.    For each job in each(grade)find the

average yearly incomes.Order results by jobs._

ct<c4 Wv4 ClVI«AW|^

Uffrt.loi ,■ ¹ Wew yeffc' y.

(Ui 4

* «W    3*«7» łj

wj. V⁰*" EMP ,k«t

Byr.PŁPT ~w.« «~,_f ćtfiL . Jr^ ikf***

C.

^aCUoU M i /cii4, tup e₍ tfii<

S^p ^ ^'ćlsp« *

12el« ci"

{    rr.

:_#W ^ $«*J    {*•"* *mP

< C    ftAm(wj) frt»m

^CHt> ,    w    U««JL

UUouŁ Om.«s| m-rudą

tej

/ | Oyclt^ bj

8.Displav names, jobs and hiredates for

-“dW

all employees working in DALLAS.Order results by names.

ietecT dlyhiALt Jot ’ a*bC zaj Ta2TFvl77,

$KU>lt -f-yo** ^Łr*f>_t coJj-róotc    *«U

M-uetu toSoJ CU«/ l. i,'c.ojf

S^r jj    _

^,nŁwt . j^ot i ^k’^,<«4a4t frw. EHf ₍oepT

Je-^ue 1 JtfA. itfht* CU<.,d "ept. (oc > I o*ua*' o><4r ^    '

9.Show all values of salaries from the 3-rd grade eamed by people from Dallas (don’t repeat the same values).

łdt4 UlX(*M> EM Y VC|<] C-ALbRAtf*

tMue    WwtŁM loiajf    Ui>*t

^<uW «***/>. JtpUo .    cltfdco

|

•-P ‘

3 4

O.

^    ^ -• 'AłZMr' .ul*' 4 uJjrode gmolt *3/    | "J

lO.Find thejhumbenof people who

don't super/ise the others.

jkCłoj")

m!«4 (n^u M IWi/i

t_    ^ cm? E

r®"* Emp m

fc . M <> r - M.

-

*eteof    jrow EMP^EpJ

(cn(ui«e| (aA    fict) C

5eW    ^₍h.-r«AJ_e fy<HM WiP OcfT    e»n_f.oicpV^ = de_ft

5tW ^    ^e7-^1,®^ł;*^*^,M1^0e«^P*Ł    •wp-4fpt«_SJ«-*^

ui Cotft* <u*d ^

e»»tf dtpW* : d_<fł Ap+ho Ł^d    _loc -‘wewYcek'

IM

ILMV

«f

Au

t4bvs lud    <oł •

- tULt-A5 'CVUXAS^ł