SQL Problems
Table of Contents
SQL related to weblogs
Query to count how many times each page URL has been visited.
SELECT PageURL, COUNT(*) AS PageViews
FROM Weblogs
GROUP BY PageURL
ORDER BY PageViews DESC;
Calculate Unique Visitors by IP Address
SELECT COUNT(DISTINCT IPAddress) AS UniqueVisitors
FROM Weblogs;
Identify Top Referring Sites
SELECT Referrer, COUNT(*) AS ReferralCount
FROM Weblogs
WHERE Referrer IS NOT NULL
GROUP BY Referrer
ORDER BY ReferralCount DESC;
Calculate Average Page Load Time
SELECT AVG(PageLoadTime) AS AvgLoadTime
FROM Weblogs;
Calculate Unique Visitors by IP Address
Calculate Unique Visitors by IP Address
Calculate Unique Visitors by IP Address