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