SBD k2 05 g2

TEST 2

Name GROUP

ResulI

/u ę/~    . | _x

‘^{b fc/lp}~^^Ł- ^    Auf(s$§i tmof' &ĄP onp

_a ¹ OAUńi ¹) I ~W(*^SZL.JU) i Ot?ij C eZJ/ir T (i-Ap/w) reo* 54/

1.Display all employees (personal I number.name.profession and salary),

! who eam morę than the average salary I for people with salaries in the grade 2.

12. Ho w many people eam morę than the js'eZeot minimal salary for the department located in DALLAS.

Pf ^    'p,ioa em?

¹ A* ^ C*^eu=^cr (^<>łl) PnoA £/, p j/ł t óje/t 11

U/Mbtlir ^t6U3)*_Ej_> tU/40g- :ljj.

3.For each grade find the number of - people with salaries in this grade T I (display the grade and the adequate number of people)._

<Ęm

- 4.Find people who eam the highest salary for their job and grade.

•r T

no*

Ht/B t

| 5.For each job find the person I employed as the last one.

-J *^00    €ń4(9tT

^/tfct OjJE5Zf7

( 5 b ( tfC    P l?iQ/U|

P0<t. = x.3c?^);

iw»ni'»trołłtr

I ó.For each manager find his j subordinate eaming the lowest ! salary.Show name of manager.name and salary of subordinate.

UMPt UfuKt)y

^jjjjjipSSW*r r.tf_Ł ^

tj/W I f StPci/cp tp £ \j'JćnaA --0

//rfl

/t'V|

i 7.Find minimal yearly income for each each job in each department.

^l8ŁV

j 8.For each manager find the total i yearly income eamed by his ! subordinate.Display name of manager and the sum.

mł, _0ł- _pn

i[lewcr    pa

^ecr 0i,y/tiMC> WA

ipit^ w? £ ,enp w u-aiui w

VH '[Hnttlt JUAf(<łulF**v ćPlWj fc-Ac’ Al l/^|,fc'UŁ' U.A

ygrCŁi C f    moPi tAP

,    ( SeL&cT ^H

i    6NĄA(2 -'FM 0')'

_tM_ .    |#©Y

-'4/ł<-4.iy_ę^,

9.Find all people working as ANALISTS and employed before FORD.

b f? oA ca p

_4_

tumfcer

c-eonle who don t

jer

the others.

(CUfyf [yn P^ąj\ piUJ^U/kfO

foćnPAo JV01 yieisręUćtucr

*t 6rł P(Co^1/li

Tryr^

</Aip