Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2006
    Posts
    20

    Red face Unanswered: help with SQL queries please

    hi
    wasnt sure which place to post this question in. sorry if its the wrong one.
    could anyone please help me some SQL queries?

    i have the following tables:

    http://img.photobucket.com/albums/v...a66/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.

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    Actually, that's not the way it works here. FIRST you write those queries (not with your left foot, but ones that compile but don't return desired output data set), and THEN return here to ask for help on a specific problem.

    Why do you expect someone else to practice on YOUR homework? Do you think we are just too bored to fulfill everyone's wishes? I, personally, don't feel like a goldfish.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •