Results 1 to 2 of 2

Thread: need help with sql query

  1. 08-14-2003, 01:19 AM #1
    pizzakl
    pizzakl is offline Registered User
    Join Date
    Aug 2003
    Posts
    2

    Question need help with sql query

    My Question: For each keeper, show the number of cages cleaned by the keeper, show the average number of animals in the cages and the total cost of the cages cleaned by the keeper.

    TABLES:
    ========

    KEEPER: keeperid, role ('C' for cleaner)

    CAGE: cageno, keeperid, cagecost

    ANIMAL: animalid, cageno, keeperid
    Reply With Quote Reply With Quote
  2. 08-14-2003, 08:28 AM #2
    skhanal
    skhanal is offline Experts
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    http://forums.databasejournal.com/sh...threadid=32841
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules