help with SQL queries please

[monkeymafia]

hi

could anyone please help me some SQL queries?

i have the following tables:

http://img.photobucket.com/albums/v635/monkey_mafia66/tables2.jpg

and just needed help on constructing these SQL queriers:

1. show a list of the sponsers and which elephants they sponser. include sponsers name and amount sponsered.

2. show a count of how many volunteers work at each sanctuary.

3. provide a list of baby elephants born in august 2006, include their name dob and mothers name.

4. display the emergency contact details for a member of staff called "bob jones"


any help with any of these queries will be greatly appreciated.
thank you! :)

[monkeymafia]

so for query number 3 i have:

<code>
SELECT DOB, UNIQUE NUMBER, BABY NAME, GENDER, MOTHER NAME

FROM BABY ELEPHANT

WHERE DOB = "AUGUST 2006"
</code>

does this sound about right?
i dont have access to a SQL program so its hard to test the actual queries. :/