En cours

ACCESS DB SELECT STATEMENT

HI

I NEED SOMEONE TO WRITE ME A SELECT STATEMENT TO RETRIEVE DATA FROM ONE TABLE WITH THE FOLLOWING STRUCTURE

STAFF_NO, STAFF_NATIONALITY, STAFF_GENDER,STAFF_AGE,STAFF_TYPE

THE SELECT STATEMENTS SHOULD REPRESENT THE FOLLOWINGS:

LIST OF STAFF CATEGORIZED BY NATIONALITY AND THE COUNT FOR MALE AND FEMALE {STAFF_GENDER} EACH IN ONE ROW.. EXAMPLE :

STAFF_NATIONALITY STAFF_GENDER "MALE COUNT" STAFF_GENDER"FEMALE_COUNT" HEADCOUNT

AMERICAN 4 6 10

INDIAN 7 1 8

ANOTHER SELECT STATEMENT WILL SHOW SAME AS ABOVE, BUT INSTEAD OF COUNT OF MALE AND FEMALE, WE NEED TO SHOW THE COUNT FOR DIFFERENT AGE CRITERIA LIKE {AGE<20, AGE >=20 AND <30, AGE>30 AND <=40, AGE>40 AND <=50, AGE>50 AND <60, AGE>=60}

I NEED THIS AS SOON AS POSSIBLE , SO PLEASE ONLY SERIOUS AND PROFESSIONALS PLEASE TO BID HERE.

GOOD LUCK

Compétences : Microsoft Access, SQL

Voir plus : select, indian female, statement structure sql, sql retrieve table, headcount, sql select, american female, list indian, good access, american male, write data access, female american, write db, row select, female indian, ext access log, criteria select, count age sql, ajax select php, access sql count, access db, quiz select asp access, multi select listbox access, write statement sql, access list

Concernant l'employeur :
( 16 commentaires ) Doha, Qatar

N° du projet : #1674460

Décerné à :

momo2619

Please read PM

30 $ USD en 0 jours
(11 Commentaires)
3.6

6 freelance ont fait une offre moyenne de 45 $ pour ce travail

weonlydo

Hi, you can have this immediately. Let's start

40 $ USD en 0 jours
(12 Commentaires)
4.5
sriraj1233

Ready to start this right now

30 $ USD en 1 jour
(5 Commentaires)
3.9
coolbuddy19

Hi I am ready to start

90 $ USD en 2 jours
(7 Commentaires)
2.4
HemantPawar7

Better knowledge of Sql and Access Queries as insert,update,delete,create,alter,drop,purge etc. * Exceptionally good in handling the problem and solving it. i am young and very very hard worker.please share your Plus

30 $ USD en 2 jours
(0 Commentaires)
0.0
spidermind

Hi check PM

50 $ USD en 0 jours
(0 Commentaires)
0.0