w3resource
SQL exercises

SQL Exercises: Count the number of salesmen registering orders for each day

SQL Aggregate Functions: Exercise-20 with Solution

Write a query that counts the number of salesmen with their order date and ID registering orders for each day.

Sample table: orders


Sample Solution:

SELECT ord_date,salesman_id,COUNT(*) 
FROM orders 
GROUP BY ord_date,salesman_id;

Output of the Query:

ord_date	salesman_id	count
2012-07-27	5001		1
2012-08-17	5007		1
2012-04-25	5001		1
2012-09-10	5002		1
2012-10-05	5002		1
2012-10-10	5003		1
2012-09-10	5005		1
2012-08-17	5003		1
2012-06-27	5002		1
2012-09-10	5001		1
2012-10-05	5001		1
2012-10-10	5006		1

Explanation:

 Syntax of counts the number of salesmen with their order date and ID registering orders for each day

Pictorial presentation:

Syntax of counts the number of salesmen with their order date and ID registering orders for each day

Query Visualization:

Duration:

Query visualization of Count the number of salesmen registering orders for each day - Duration

Rows:

Query visualization of Count the number of salesmen registering orders for each day - Rows

Cost:

Query visualization of Count the number of salesmen registering orders for each day - Cost

 

Practice Online


Have another way to solve this solution? Contribute your code (and comments) through Disqus.

Previous: Write a SQL statement that count the number of salesmen for whom a city is specified. Note that there may be spaces or no spaces in the city column if no city is specified.
Next: Write a SQL query to calculate the average price of all the products.

What is the difficulty level of this exercise?



New Content: Composer: Dependency manager for PHP, R Programming