Most asked SQL Question with Answer | Facebook - Page with no likes

Опубликовано: 22 Февраль 2025
на канале: ETL SQL

197

Free SQL Pattern Training: https://etlsql.kartra.com/page/sps-fr...

Do you understand SQL but still cannot write SQL queries correctly ?
Are you afraid to switch jobs because of the SQL interview rounds or have you failed SQL Interview earlier ?
If you are someone who understands SQL and need more confidence to solve SQL queries correctly, I would like to share my recent online course especially created for you.
Check for more details: https://etlsql.kartra.com/page/sql-pa...

In this video I have solved SQL Question - Titled "Page with No Likes" on Data Lemur platform.
Data Lemur referral link for easy reference: https://bit.ly/3SuF3wf

Hope you like the way I am explaining my thought process.
Let me know if this is helping you to solve SQL queries more confidently and you wish me to share more such videos.

Question:
Assume you are given the tables below about Facebook pages and page likes. Write a query to return the page IDs of all the Facebook pages that don't have any likes. The output should be in ascending order.

Solution:
#############################

select page_id from pages
except
select distinct page_id from page_likes;

#############################