Page With No Likes — Facebook Asked SQL Question

Solving SQL Question asked by Facebook

Suraj Mishra

·

Follow

3 min read

·

Oct 24, 2022

--

Share

Originally Published in https://asyncq.com/

Introduction

• In this article we will solve Page With No Likes SQL question which is asked by Facebook as per DataLemur website.

If you don’t know DatLemur then please do visit , it’s one of the best website to practice SQL questions and improve your SQL skills.

Question

• We have been given two input tables , pages and page_likes.
• Our goals is to query all the pages that don’t have any likes.

• As we can see , page_id 20701 doesn’t have any likes hence it returned as output.

Solution