В работе

Mysql Query Help

I have a table I need to write a SQL query for and I need help doing it.

Do not bid unless you can provide SQL query right away. NOW!

This is a table of web visitor visits with the User_ID, URL, and Access_Time they accessed the page.

If the URL contains [login to view URL] the visitor watched a Video.

#1. I need to know the First VIsit per day Access_Time, and the Last Visit of the day Access_Time, and the Total Time Spent on the site per Day for each User_ID. Then I need to total all the Daily Times for a Total Time

#2. I need to know the total Videos watched for each user.

#3. Create a new table with User_ID, Facility_ID, Total_Time, Avg_Daily_Time, Total_Videos_Viewed, Total_Pages_Viewed.

This should take less than 1 hour.

I have included a SQL File with data and SQL Table Schema

Навыки: MySQL

Показать больше: help write daily, write query, query table, mysql query, mysql and sql, create schema mysql, web query time, mysql create schema, mysql help table, 2013 query, query page, create web page sql table, total videos, mysql schema, help videos, mysql query php, sql query help, mysql visitor, need sql query, daily data php mysql

О работодателе:
( 31 отзыв(-а, -ов) ) United States

ID проекта: #4599995

3 фрилансеров(-а) готовы выполнить эту работу в среднем за $74

gopalvora

Hi ready to start thanks

$103 USD за 3 дней(-я)
(230 отзывов(-а))
7.6
marchingantssl

Lets start

$53 USD за 0 дней(-я)
(158 отзывов(-а))
7.4
JavierV

I can do it NOW

$66 USD за 1 день
(2 отзывов(-а))
1.6