You may see the Products table on the picture.

Write a query to find the second highest price value in the table.

You can execute query here

Please feel free to provide your solution in the comments to this post.

SOLUTION
SELECT MAX(Price) FROM Products WHERE Price < (SELECT MAX(Price) FROM Products);

#task

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