Re: HELP ON HOMEWORK

Michelle.......Michelle..... ;-)

Generally peeps on newsgroups don't do others homework. Also, i'm not gonna download and install those files on my work or home PC.

If you post the SQL you are currently using plus table definitions (type DESC <table> in SQL*Plus) maybe we can help.

M

gold0909_at_aol.com (michelle) wrote in message news:<5cc99983.0111071219.56bf8b74_at_posting.google.com>...
> Had to miss class last week and now I am lost and need to get this
> homework done.
>
> The sql scripts are located at
>
> http://www.course.com/catalog/downloads.cfm?isbn=0-619-00027-9
>
> just need northwoo.sql
>
> Question:
>
> Use SQL Plus to write a query to calculate the total number of
> students taught by John Blanchard during the Spring 2002 term. Sum
> the CURRENRL figures, and include FLNAME, FFNAME, and TDESC in your
> search condition.
>
> It not working for me the way I am joining the tables.
>
> Thanks for you help!!!!!
Received on Thu Nov 08 2001 - 10:59:21 CET