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.

Note. Relation page Attributes - page_code: INTEGER primary key - content content_type not allowed null - description: VARCHAR(2000) not allowed null - layout_template template_code not allowed nullo - developer: d_id not allowed null - date_approved: DATE - approved_by: d_id Constraints - 1: date_approved > 01/01/2000 - 2:date_approved > - visitor : c_id Relation client Attributes -client_id: c_id > - name: VARCHAR(60) not allowed null - date_of_birth: DATE not allowed null>> - location: region not allowed null Constraints - 1: (date_of_birth) - TODAY >= 18 years (Client is an adult) Foreign keys Name(viewed) page_code References page not allowed null Name(visited) visitor References client Constraints - 1: action date > 01/01/2020 2: dwell_time