sethbeckerman5 Staff asked 4 years ago
Given the following 3 tables of video website database:
video
view (table for counting views of videos)
like (table for counting likes in videos)
I want to write MYSQL query to count views and likes for each video, so in that example i should receive:
I tried to run the following query, but it displayed wrong output: