471,058 Members | 995 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,058 software developers and data experts.

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 2257
Luuk
1,044 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
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.