Terminé

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

en voir plus : select, indian female, statement structure sql, sql retrieve table, headcount, sql select select, sql select, American Female, list indian, good access, select select, American male, write data access, Female american, write db, select option access db classic asp, row select, female indian, ext js db access log, criteria select, count age sql, convert db access exe, ajax select db php, access sql count, access db

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

Nº du projet : #1674460

Décerné à:

momo2619

Please read PM

%selectedBids___i_sum_sub_7% %project_currencyDetails_sign_sub_8% USD en 0 jours
(11 Commentaires)
3.6

6 freelance font une offre moyenne de $45 pour ce travail

weonlydo

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 0 jours
(12 Commentaires)
4.5
sriraj1233

Ready to start this right now

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(5 Commentaires)
3.9
coolbuddy19

Hi I am ready to start

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% 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 [login to view URL] share your Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(0 Commentaires)
0.0
spidermind

Hi check PM

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 0 jours
(0 Commentaires)
0.0