Hi all, i am having trouble with a select statement.

I have a DVD table, with a field called release_date. i need to select from that the DVD's that have been released for the three weeks following the first tuesday in april(the date must be derived using sql)

i understand it is something like this:

SELECT release_date,next_day(last_day(ADD_MONTHS(release_ date,4))-7,'Tuesday') sofar FROM DVD

I know i need to add a month and subtract 7 days to get 3 weeks but cant get the april bit.

Any help appreciated

Cheers, Alex

Sadly I have no idea as to going about answering that question but Im guessing your from stafford uni doing your DWDS assignment? lol

Im having a little trouble with:
'List the top ten DVDs generating the most income during the last 12 months'

if you could offer any help with that it would be much appriciated.

Cheers