Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004
    Posts
    1

    Post Unanswered: SQL Query Problem

    I need help with the following problem. I need to write a SQL query to show the names and salary of salespeople who have two or more orders. First using a join query and then writing the query using a sub query.

    SALESPERSON: name, percent_of_quota, salary

    ORDER: number, cust_name, salesperson_name, amount

    CUSTOMER: name, city, industry_type

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    sounds like homework

    you need to show us what you have done on your own so far, and where you think it might need improvement

    we won't just write it for you

    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

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