Results 1 to 2 of 2

Thread: Another SQL QUERY

  1. #1
    Join Date
    Sep 2006
    Posts
    9

    Unhappy Another SQL QUERY

    Hello there ppl...
    thanks for posting the replies it helped me a lot....
    well i have another query here....

    I have a table called Grants which consists of

    FID which is a Faculty ID
    GRANTNAME
    GRANTAMOUNT
    DURATION of GRANT

    AND ANOTHER TABLE CALLED FACULTY which consists of

    Faculty Name
    FID same as above
    PHONE#
    ADDRESS


    well my query is to

    1) determine the average amount of grants awarded to every faculty member recieving grants. Limit your selection to those faculty whose average is over 10,000 .
    2) determine the average amount of grants awarded to every faculty member recieving grants. Limit your selection to those INDIVIDUALS whose grant is over 10,000 .
    3) i need to use a DECODE function to determine and print based on grantamount those whose amount is less than 10,000 as 'small' , greater than 10,000 but less than 20,000 as 'medium' and larger than 20,000 as 'large'

    PLs PLs help me out here.....

    Thanks

  2. #2
    Join Date
    Oct 2005
    Posts
    2,557
    Sure sounds like homework.

Posting Permissions

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