Question: There is a database that contains a website's traffic data over a period of 30 days. The first table contains users' information including the

There is a database that contains a website's traffic data over a period of 30 days. The first table contains users' information including the user type (user, crawler, admin). The second table consists of the time of each visit to the website, the id of the visitor, time spent on the website in seconds. Write an SQL query to show the 3 day moving average of time spent on the website for users.user_type = 'user'. Note: avg time spent must have 4 decimal digits and rounded off (example: 5/3 = 1.6667, 5/2 = 2.5000 and 1/3= 0.3333) Schema There are 2 tables: users, traffic Name id name Name user_type VARCHAR Type of the user user_id visited_on users time spent Type Description INTEGER The user's unique id. It is the primary key. VARCHAR This is the second column and the name of the user. traffic Type INTEGER DATE INTEGER time spent on website in seconds Description id of the user from the users table. date on which the user visited the website

Step by Step Solution

★★★★★

3.44 Rating (151 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

The question in the image asks for an SQL query to show the 3day moving average of the time spent on ... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Twin Elms was a famous commune founded by hippie idealists in 1972. Each person or family who joined the commune purchased a fee simple absolute in a one-acre lot and built a home. Because the...

Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...

For the following exercises, you will address problems and answer questions from management at TAL Distributors. You do not use the TAL Distributors database for any of these exercises. 1. While...

Segment (Division) Evaluation In this assignment you will analyze the performance of PepsiCo's divisions. SFAS 131 requires publicly traded companies to disclose division information in the notes to...

Sketch Bz versus y for points on the y axis when both currents are in the negative x direction. y = -6 cm y = +6 cm

How will you provide technical support to employees working from home? Would this be easier if the company provided the employee with a computer? Why or why not?

=+c) What are the factors?

During 2021, its first year of operations, Pave Construction provides services on account of $160,000. By the end of 2021, cash collections on these accounts total $110,000. Pave estimates that 25%...

Matlab Problem: Write a function called PrimeFinder that receives an integer as an input argument, and provides an output argument called Primes that is a vector containing all prime numbers between...

The following schedule shows the excess of cash receipts over cash disbursements projected for the Zoptic Company for 20X1: The company borrows and repays from an open line of credit in round $100...

Which of the following would be considered a capital budgeting decision? A) Walmart purchases inventory for resale to customers. B) Apple sells bonds and uses the proceeds to repurchase stock. C)...

Demand for Surf World is Poisson with mean 2.5. If they happen to stock 5 copies, what is the expected number of customers who will want to purchase Surf World but will be unable to do so because the...

The figure below shows a resistor network. R 2 R3 R 1 WW RA + V The values of the components are as follows: . R1 = 2.65 0 . R2 = 5.09 0 . R3 = 7.28 0 . R4 = 8.83 0 . V= 7.92 Volts Fill in all the...

What is the first step you should take when preparing for a meeting to ensure it is valuable to all attendees? Use the editor to format your answer

a. A sample of 95 employees of Malindi Tyre Company were asked which means of transport they used t and the following data was obtained; Means of Transport Number of Employees Matatu 41 Personal Car...

What happens in Stage Four, the turning point? a. The individual or team gives up. b. The individual or team commits to move forward. c. The team doesn't have all the answers. d. All the above

An investor is considering investing in one of two companies. The companies have very similar reported financial position and results of operations. However, only one of the companies has its...

Floyd Distributors, Inc., provides a variety of auto parts to small local garages. Floyd purchases parts from manufacturers according to the EOQ model and then ships the parts from a regional...

The director of a nonprofit ballet company in a medium sized U. S. city is planning its next fundraising campaign. In recent years, the program has found the following percentages of donors and gift...

A marketing researcher surveyed 92 individuals, asking them if they liked a new product concept or not. The results are shown below: Convert the data into percentages. Then construct a chart of the...

Sandford Tile Company makes ceramic and porcelain tile for residential and commercial use. They produce three different grades of tile (for walls, residential flooring, and commercial flooring), each...

a. Summarize a specific municipal solid waste problem in your home town or one that recently has been reported in the media. Use the specific stages of the waste stream in your discussion. b. What...

In 1990, Business Week magazine compiled financial data on the 1,000 companies that had the biggest impact on the U.S. economy. Data sampled from the top 500 companies in Business Week's report are...

Residential real estate prices depend, in part, on property size and number of bedrooms. The house size X1 (in hundreds of square feet), number of bedrooms X2, and house price Y (in thousands of...