| Unsure about my statements.. Need HELP urgently!! THANX [message #973] |
Sun, 17 March 2002 16:40  |
Kelvin
Messages: 6
Registered: January 2002
|
Junior Member |
|
|
Hi guys! I ugently need your help! Thanx!
I have a question which asked "List the number of Chinese children enrolled in each type of school care which has a count greater then 10."
My statments are like this >>
SELECT Count(t.*), Count(b.*), Count(e.*), Count(h.*) FROM TNE t, BNA b, Emergency e, Holiday h WHERE Count(t.*) > 10 AND Count(b.*) > 10 AND Count(e.*) > 10 OR Count(h.*) > 10 AND t.Member_ID IN (SELECT Member_ID FROM Member WHERE Race = ‘Chinese’) AND b.Member_ID IN (SELECT Member_ID FROM Member WHERE Race = ‘Chinese’) AND e.Member_ID IN (SELECT Member_ID FROM Member WHERE Race = ‘Chinese’) AND h.Member_ID IN (SELECT Member_ID FROM Member WHERE Race = ‘Chinese’);
PLS HELP!! Cna someone pls tell me whether I'm correct?? I urgently need your help!! Thanx a million!!
|
|
|
|
| Re: Unsure about my statements.. Need HELP urgently!! THANX [message #976 is a reply to message #973] |
Mon, 18 March 2002 00:58  |
pratap kumar tripathy
Messages: 660
Registered: January 2002
|
Senior Member |
|
|
try this
SELECT Count(*)
FROM TNE
where Member_ID IN (SELECT Member_ID FROM Member WHERE Race = ‘Chinese’)
having count(*)>10
union
SELECT Count(*)
FROM bna
where Member_ID IN (SELECT Member_ID FROM Member WHERE Race = ‘Chinese’)
having count(*)>10
SELECT Count(*)
FROM emergency
where Member_ID IN (SELECT Member_ID FROM Member WHERE Race = ‘Chinese’)
having count(*)>10
SELECT Count(*)
FROM holiday
where Member_ID IN (SELECT Member_ID FROM Member WHERE Race = ‘Chinese’)
having count(*)>10
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
