MySql count 3 tables with left join

QuestionsMySql count 3 tables with left join
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:


View on Stack Overflow