NAME DATE OF BIRTH DAY MONTH YEAR ">20"Years Adult/Child
RAMESH 15-05-1980 03 06 45 >20 Adult
RAKESH 20-08-1981 29 06 43 >20 Adult
RAHUL 15-10-2003 04 09 21 >20 Adult
POOJA 25-05-1990 25 02 34 >20 Adult
MANOJ 24-08-1992 24 01 32 >20 Adult
ASHOK 23-08-1998 26 11 26 >20 Adult
AJEEL 12-05-1980 06 06 45 >20 Adult
ALOK 18-03-2005 02 08 20 - Child
AMRIT 15-08-2007 04 07 17 - Child
SURENDRA 25-05-2010 25 06 14 - Child
SHASHI 25-08-1993 24 01 31 >20 Adult
"SURENDRA" Years Old 14
[Link] 11
Student Name subject Result
Name Maths English Physics TOTAL PERCENTAGE GRADE
Alan 80 75 85 240 80% EXCELLENT
Bob 50 30 40 120 40% BED
Carol 60 70 oor 130 43% BED
David 90 85 95 270 90% EXCELLENT
Eric 20 30 Absent 50 17% BED
Fred 40 60 80 180 60% GOOD
Gail 10 90 80 180 60% GOOD
Harry 80 70 60 210 70% GOOD
Lan 30 10 20 60 20% BED
Janice 10 20 30 60 20% BED
Student Count 10
Percentage >50% 5
Bob Total Number 120
Eric Total Number 50
"GOOD" Student count 3
"BAD" Student Count 5
Employee ID Name Location Salary Age
50217 Eric Green Warsaw 16406 42
53700 Margaret Turley Shanghai 19327 26
59673 Estelle Cormack Hong Kong 10959 30
56815 Garry Manship Hong Kong 13836 25
51186 William Johnson Hong Kong 11771 32
52130 Christopher Fall Delhi 14562 32
58369 Thomas Davies Capetown 12566 37
55879 Michael Kaye Capetown 18996 35
50890 Lan Nash Cairo 18276 32
50695 Williamr Black Cairo 15784 43
59848 Paul Bell Bangkok 10387 25
51511 Thomas Bettle Bangkok 13046 35
employee id 58369
Name Thomas Davies
"Estelle Cormack" age? 30
employee id 55879
Location Capetown
SALESMAN JAN FEB MAR APR MAY JUNE SALES
RAMESH 2000 1500 300 1400 1000 1400 7600
RAKESH 5000 1200 500 1200 1200 2800 11900
RAHUL 3000 800 1200 3000 1500 3500 13000
POOJA 1000 900 1800 5000 1400 1200 11300
MANOJ 500 1000 2300 8000 1700 1400 14900
ASHOK 800 500 2400 1900 1800 1800 9200
AJEET 1200 1400 1500 700 2500 7000 14300
ALOK 1500 1800 1800 1800 300 1500 8700
AMRIT 1800 2500 1700 1500 2800 1800 12100
SURENDRA 200 3000 1900 1200 1500 3000 10800
SHASHI 1600 1200 2000 800 1700 800 8100
TARGET RESULT
10000 NOT ACHIVED Salesman Count 11
12000 NOT ACHIVED
Salesman Name SURENDRA
18000 NOT ACHIVED
Target 10000
TARGET
10000
ACHIVED Result TARGET ACHIVED
TARGET
12000
ACHIVED
10000 NOT ACHIVED
TARGET ACHIVED COUNT 5
TARGET
12000
ACHIVED
10000 NOT ACHIVED
B
FE
JA
TARGET
12000
ACHIVED 2000 2500
TARGET
10000 SALESMAN SHASHI AMRIT
ACHIVED
10000 NOT ACHIVED