ACCESS DB SELECT STATEMENT
$30-250 USD
Pago na entrega
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
ID do Projeto: #1674460