Đang Thực Hiện

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

Kỹ năng: Microsoft Access, SQL

Xem thêm: 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

Về Bên Thuê:
( 16 nhận xét ) Doha, Qatar

Mã Dự Án: #1674460

Đã trao cho:

momo2619

Please read PM

$30 USD trong 0 ngày
(11 Đánh Giá)
3.6

6 freelancer đang chào giá trung bình $45 cho công việc này

weonlydo

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

$40 USD trong 0 ngày
(12 Đánh Giá)
4.5
sriraj1233

Ready to start this right now

$30 USD trong 1 ngày
(5 Đánh Giá)
3.9
coolbuddy19

Hi I am ready to start

$90 USD trong 2 ngày
(7 Đánh Giá)
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 [url removed, login to view] share your Thêm

$30 USD trong 2 ngày
(0 Đánh Giá)
0.0
spidermind

Hi check PM

$50 USD trong 0 ngày
(0 Đánh Giá)
0.0