Question
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
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.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started