Orders table structure is reflected on the picture.
1) Write a query to select the average number of orders made by the customers.
2) Round the result to one decimal place.
3) The resultant field should be named as follows:
AVG OrdersNumber.
Example: Let's say if someone from clients made 3 orders, another one made 5 orders, and someone else made 2 orders. So 10 / 3, and since the result should be rounded according the the task, the output will be: 3.3.
You may practice and execute your query here
Please feel free to provide your solution in the comments to this post.
NOTE: Please use the Spoiler feature, when posting your solution, in order to give the chance to think to others.
#task
1) Write a query to select the average number of orders made by the customers.
2) Round the result to one decimal place.
3) The resultant field should be named as follows:
AVG OrdersNumber.
Example: Let's say if someone from clients made 3 orders, another one made 5 orders, and someone else made 2 orders. So 10 / 3, and since the result should be rounded according the the task, the output will be: 3.3.
You may practice and execute your query here
Please feel free to provide your solution in the comments to this post.
NOTE: Please use the Spoiler feature, when posting your solution, in order to give the chance to think to others.
#task
After solving the task from the previous post, you may check your result, by selecting the correct option:
Anonymous Quiz
29%
3.2
48%
3.0
10%
2.8
10%
2.6
3%
1.9