SBD k2 05 g1

IO ' t , e    o

CC*c* n f- l C C rv., p,.o | _v |M . Cwp»’

fWP M cHp ą: 'Sciecl *&+    ( So4 *A2+ sJVu(u>m_r)) _j

ty cf^WC

u

*^v' * k . e »vi p w

^P . Ml£jWD5

3"

i/U-Ł-v

'j? Oyj K . Ovj;|>WO

ss«l/ Wwi0« touJ w 4,

SBD

ec?f d^iwci IC»k* &V<A C50^ ** /? -4 N>v/l-(co V

TEST 2 (ORACLE )

,V)).

>e»0ic

^ ęKP ^AtCjRAOf ¹

^*^<v*    j°^;

4*.

■Uti ( Suł/ Tweett /oSo/ (U(/

| 1 .Find all people working as CLERK -j— ! and employed after ADAJVIS.Display I results ordered by hiredates.

Name GROUP. RESULT

&sAecł tnamt

h.^edcje > t**UeJl '    W CMP

wUtve e»aOvuAe = ^AKs' \

/ )

-f

12. Find all jobs which appear both in department 10 and in department 20.	Seieot frwu cmp wUece dtfi»o-4o | JKlT^g.5BCT SeJec/ ^ T^rew> FKP olfpU -pO.\ !
3.Find people who eam the lowest salary for their job and grade. .	seXeci enane'foMto-lęw> SAi.6<2ADH U *kere Kisa[ ^0^vii^oJ wSL¥<K9Wmf ****SćMf ArJfct. «ob 1 * ^ * / k^J AjT a £ -V ' ( » «| KlWe4^ , Ołklf tz^cuf UłZdif Ostwp On u 7% cv.,7 jtoac , d r •'l
4.How many people eam less than the maximal salary for the department located in NEW YORK.	*eA«c| tow^f (evto****) ^U^re' ^ C sdcd *+**(S<U) pnf pCPT V»Vier«. <Pvip.oWpr)r oi«p4.loc y-i<u 1 li i ' . J A- 1 , /-,— . S

^:*Hole

P^ł*C

+

— his subordinate.Display name of the £ ! manager and the number of people

working under his super/ision._

6.Find all employees (personal number,name,profession and salary), who eam less than the average salary for people with salaries in the third i grade. Displav results order by salaries i ascendina.

tup e ehp w

l>a    '

"*! !•» Jaj |

J c-naJe

shP (ićłJ / from bsd    los ojL

tai • i

7 J order bj

%

§

H"

"V

7.    For each job in eachfeac^ind the

average yearly incomes.Order results by jobs.__

8. Display names, jobs and hiredates for all employees working in DALLAS.Order results by names.

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

gjgfi Ol i s~f ^ >a*k fvo

vq( $oJ 4A7 * K^UCa**** o)},

o. i____    *.. /    ' /

$ ⁵ 5 *

o

________ '*■£* i

Są\td W f®** EMP^pT.SAlbę***    ^ 2

tjUe*e    be4«*icev« lasoj Ouu*d

AW    dtptuo * oftpł. dtfd*⁰    V s[

<»w    u*.*¹ Pallas'    ^g*adt *3$ p

s^p

^d€cł dffd. (c

4y»<XMAt 44<W|

jot Kiy € ćf<a^e f- roru EMP. Dfcf>T

. de.piuc * Jept deft* ^c f DĄt4rĄ£^ł °*d&r ty CiAKMAĆ

o^ud

W

■ma

r?

:eooi

wno

don

upervise the otners

mo>cCs<u)

btlecA M IMb5

Sfr/«cł U.tpop

E^0w

1

twf £ ęMP M ^k«r<

af <3lepVo - «*^rf Je|>4kO    a>u.d elep^.loc * ¹Voe|c

^eiecł tofl4Adi&u    . IW*1    Kłkęnl______{_}

^eicci CjOoa4-re*iaxA*e^ ć«sd. »ji8#y4 ■saJ ^

\> hucd^ie h^0lM    >^e em_f. olc^ =    ^ ol«fLuc _r 'i^alu^

Seiedt

S^Xec^

5*J

(LaA.OJJJlQ \C

SrfJL    6HP    SALO^Dc ₍ P¥?I

DcAwetM Loc-cJL    «

i«/Ueve fiw/tp- Jepi*u» -

,_s ' CiALUAS

Otci#

^ef