Re: Need urgent help with sub-query

4) Lurk by the assignment submission locker until some of the brainy suckup swots have dropped off their program listings, then lose a bit of skin extracting one or two, hightail it to the computer lab and throw together some source code (always remembering to change variable names and shuffle some routines around), make it compile, do some cursory testing and shove your ill-concealed act of piracy through the slot just as the lecturer rounds the corner with brass key rampant. If you're a nice guy you'll also return the purloined assignments (optional step).

I once got back an assignment with a mark of 7/10 and the comment, "This program bears a strange resemblance to Caroline Hindle's". I immediately sacrificed some small furry animals to the god of lazy students. Hey, a 7 is a 7!

Richard Foote wrote:

> Hi Martin,
>
> How's it going you red haired scoundrel ;)
>
> In my day, I had three choices with regard to homework:
>
> 1) Do it myself (the safest although not always the easiest option)
>
> 2) Get my good mate Andrew Brown to do it (although it required the payment
> of a handful of gobstoppers or a number of football collector cards)
>
> 3) Don't do it (the easiest option but one that carried certain unfortunate
> consequences)
>
> These days, the options are endless and you can't blame someone for trying
> if certain social obligations (like a night on the grog) has unfortunately
> gotten in the way ;)
>
> Cheers
>
> Richard
> "Martin Doherty" <martin.doherty_at_oracle.com> wrote in message
> news:3D87C02A.B3F5B240_at_oracle.com...
> > Gamaz,
> >
> > Is this an assignment for school? Is your request urgent because the
> deadline
> > for completing the assignment is looming closer?
> >
> > gamaz wrote:
> >
> > > Hi,
> > > I have a worker table from which a correlated subquery needs to be used
> to
> > > get the youngest worker and the corresponding lodge he/she resides. I
> know
> > > how to do without using sub-query. However, I could not think as how to
> > > resolve it by sub-query. Any help is highly appreciated. Thanks in
> advance.
> > >
> > > Worker table is attached.
> > >
> > > NAME AGE LODGING
> > > ------------------------- ---------- ------------
> > > BART SARJEANT 22 CRANMER
> > > ELBERT TALBOT 43 WEITBROCHT
> > > DONALD ROLLO 16 MATTS
> > > JED HOPKINS 33 MATTS
> > > WILLIAM SWING 15 CRANMER
> > > JOHN PEARSON 27 ROSE HILL
> > > GEORGE OSCAR 41 ROSE HILL
> > > KAY AND PALMER WALLBOM ROSE HILL
> > > PAT LAVAY 21 ROSE HILL
> > > RICHARD KOCH AND BROTHERS WEITBROCHT
> > > DICK JONES 18 ROSE HILL
> > >
> > > NAME AGE LODGING
> > > ------------------------- ---------- ------------
> > > ADAH TALBOT 23 PAPA KING
> > > ROLAND BRANDT 35 MATTS
> > > PETER LAWSON 25 CRANMER
> > > VICTORIA LYNN 32 MULLERS
> > > WILFRED LOWELL 67
> > > HELEN BRANDT 15
> > > GERHARDT KENTGEN 55 PAPA KING
> > > ANDREW DYE 29 ROSE HILL
> >