Lesson 1 of 0
In Progress

Track User Website Visits

Kedeisha June 8, 2023

Challenge

Consider two tables: Users and WebsiteVisits. The Users table has the columns: id (int), name (varchar).

The WebsiteVisits table has the columns: user_id (int), website (varchar), and timestamp (datetime).

Write a SQL query to find the most visited website by each user.

DB Fiddle Instructions

Click ‘Edit on DB Fiddle’ to be taken to the in browser SQL playground where you can run your queries.