468,483 Members | 2,710 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,483 developers. It's quick & easy.

write a sql query to find the number of employees made the transactions in a store by

write a sql query to find the number of employees made the transactions in a store by month where there can be multiple transactions by each employee
Oct 30 '18 #1
1 2171
Luuk
1,043 Expert 1GB
Since by now you are probably too late for your homework anyway

Expand|Select|Wrap|Line Numbers
  1. SELECT
  2.    COUNT(NumberOfEmployees)
  3. FROM Store
  4. WHERE
  5.   NumberOfTransactions >= 1
  6. GROUP BY
  7.   Month
If this is not what you want, you should stop doing this course, and start doing a course where you learn to properly explain what you want to accomplish.

Also it would be of help to kno what kind of data you have to get the results you want.

In this case:
How are transactions stored in your database, How is the table transactions defined? (and the same question for the table employees)

If this information is not known, to a reader here, no one could give a correct answer.
Nov 4 '18 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

58 posts views Thread by sh.vipin | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.