how to list 10 sufficient employee in sql ?
Results 1 to 4 of 4

Thread: how to list 10 sufficient employee in sql ?

  1. #1
    Join Date
    Aug 2016
    Posts
    2

    how to list 10 sufficient employee in sql ?

    How can I answer this question in SQL?

    "List of 10 sufficient employees in X corporation".

    car(price, manufactor.id, color, createdbyid, creationdate),
    manufactor(name, id),
    employee(id, name, salary)

  2. #2
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,900
    What do you mean by sufficient employee?

  3. #3
    Join Date
    Aug 2016
    Posts
    2
    the employees with lower salary than others and who have created more cars than others(createdbyid)

  4. #4
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,900
    Based on tables you have listed, I don't see any relation between employee and car.

Tags for this Thread

Posting Permissions

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