[Database class] Database HW3

[Paul S. Wang]

OK,

I am sending this to the class list since the HW3 is closed
and no new submission will be accepted.

SELECT distinct student.ID, student.name from student 
  where student.ID NOT IN 
  (SELECT distinct takes.ID from takes 
   where ((takes.year=2009 AND takes.semester != 'Fall') 
          or  takes.year < 2009));

Paul
> 
> Paul Wang,
> I was expecting that my second one would wrong. I WORKED ON THAT QUERY FOR
> TWO DAYS but couldnot get the right output . Can you let me know the right
> query.
> Regards,
> Sai Uday Kiran, Ravi
> 
> On Thu, Oct 6, 2011 at 10:05 AM, Paul S. Wang <pwang at cs.kent.edu> wrote:
> 
> > Ravi,
> >
> > Part 2 is wrong.  You still need to check year < 2009.
> >
> > Grade: 7.5/10
> > Paul
> > >
> > > Hello sir,
> > >
> > > Name: sai uday kiran, ravi
> > > database name: sravi
> > >
> > > Regards,
> > > Sai Uday Kiran,Ravi
> > > sravi1 at kent.edu
> > > banner ID: 810548662
> >
> >
> >
> > --
> >
> > ==============================================================================
> >  Paul S. Wang (王士弘)                      Email: pwang at cs.kent.edu
> >  Dept. of Computer Science, Kent State U.   Tel: (330) 672-9051
> >  Kent, Ohio, USA 44242-0001                 http://www.cs.kent.edu/~pwang/
> >
> > ==============================================================================
> >

-- 
==============================================================================
 Paul S. Wang (王士弘)                      Email: pwang at cs.kent.edu            
 Dept. of Computer Science, Kent State U.   Tel: (330) 672-9051
 Kent, Ohio, USA 44242-0001                 http://www.cs.kent.edu/~pwang/ 
==============================================================================