Results 1 to 2 of 2
  1. #1
    Join Date
    May 2015
    Posts
    2

    Need help with some sql queries

    Completed it last night

    wasn't so hard after learning INNER JOIN query
    Last edited by oscarhs; 06-03-15 at 13:35.

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    look at using SQL aggregation functions
    also using JOINs
    using GROUP BY sub clauses

    as ever
    its your homework, your coursework. you really do need to make an effort to do it yourself.
    if you do need help then you need to show the schema (the table designs), soem sample data
    what you have tried so far
    what is or isn't working
    what you are stuck on.

    people here may well help you, may well provide some pointers, but they won't do for you.

    of course if that is too much of an issue you could alwasy send us the name of the college/school/uni and the lecturer and we could seek the details directly...
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

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