423,688 Members | 1,894 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 423,688 IT Pros & Developers. It's quick & easy.

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

P: 1
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
3 Weeks Ago #1
Share this Question
Share on Google+
1 Reply


Expert 100+
P: 931
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.
2 Weeks Ago #2

Post your reply

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