I need help on how to write some of the queries for these questions I have below in sql. I have to go to the link that I have given you and figure out the query to make it work under the first example. I have attached screenshots of the problems I am asked to do and the result it should give me.

Write ONE query for each question. Go to this website: http://www.w3schools.com/sql/default.asp and click on try it yourself under the first example. Note that all the tables are listed on the right side of the interface.

2. Find the maximum and minimum price across all Categories in Products shown as below(Note this is partial of the resulting table) Result: Number of Records: 8 Maximum Price 263.5 43.9 81 Minimum Price 4.5 10 9.2 2.5 categoryID 2