954,566 Members — Technology Publication meets Social Media
Username:
Password:
Lost login information?
Have something to say? Contribute New Article Reply to this Article

Assignment Help Plz!! Urgent

hey all
i need to find the birds with the largest number of habitats.
attached is the database i am working with.

i sort of need the solution in about 2hrs time....

thanx ali

Attachments BirdsSql.ZIP (24.39KB)
ali_rulz
Newbie Poster
3 posts since Apr 2007
Reputation Points: 10
Solved Threads: 0
 

sorry i forgot to add that i am using winsql and need the query.

ali_rulz
Newbie Poster
3 posts since Apr 2007
Reputation Points: 10
Solved Threads: 0
 

Did you write your own query yet? If not, try it and post it here if you are having problems. Otherwise, do your own homework. We're here to help, not do your work for you.

stymiee
He's No Good To Me Dead
Moderator
3,360 posts since May 2006
Reputation Points: 161
Solved Threads: 38
 

yeh i have written my own code but not even sure if on right track...
Select H.HCode, Count (*)
From Birds B, Habitats H, Bird_Habitats BH
Where B.BirdID = BH.BirdID
Group By H.HCode, B.BirdID
Having Count (*) >= some (Select Count (*)
From Bird_Habitats
Group By BirdID);

and just for the record i wasnt trying to get u to do my homework for me i was purely trying to get help in understanding how to write this particular query!
thanx ali

ali_rulz
Newbie Poster
3 posts since Apr 2007
Reputation Points: 10
Solved Threads: 0
 

This article has been dead for over three months

Post: Markdown Syntax: Formatting Help
You