f.The company wants to maintain a table showing the minimum and maximum dwell times for each page that has been viewed and the number of times the page has been viewed.

Create an SQL VIEW with the name dwell_time_stats that selects rows from the viewing_action table. The view should show the page_code, minimum dwell time with the heading min_dwell, the maximum dwell time with the heading max_dwell, and the number of times the page has been viewed with the heading view_count.

Then, write a query showing the data the view defines.

Your solution document should contain the CREATE VIEW statement, the query and the output of the query.