Forem

Cover image for SQL πŸ“Š challenge_2βš”οΈ
Mahmoud EL-kariouny
Mahmoud EL-kariouny

Posted on

SQL πŸ“Š challenge_2βš”οΈ

Page With No Likes Facebook SQL Interview Question

  • Assume you're given two tables containing data about Facebook Pages and their respective likes (as in "Like a Facebook Page").
  • Write a query to return the IDs of the Facebook pages that have zero likes.
  • The output should be sorted in ascending order based on the page IDs.

⚠️Note:

  • You have to visit the task URL to fully understand what the task needs if you want to add a solution or test your solution.
Task URL: Link

My Solution:

SELECT 
    p.page_id 
FROM
    pages p 
LEFT JOIN 
    page_likes l
ON
    p.page_id = l.page_id
GROUP BY 
    p.page_id
HAVING
    COUNT(l.page_id) = 0;
Enter fullscreen mode Exit fullscreen mode

Code Snapshot:

Image description

My Problem πŸ’‘ Solving Repo: Link

Learn SQL πŸ“Š

SQL πŸ”₯ Get Expertise in SQL with These Top Free CoursesπŸ’―πŸ†

πŸŽ₯

Connect with Me 😊

πŸ”— Links

linkedin

twitter

Image of Datadog

How to Diagram Your Cloud Architecture

Cloud architecture diagrams provide critical visibility into the resources in your environment and how they’re connected. In our latest eBook, AWS Solution Architects Jason Mimick and James Wenzel walk through best practices on how to build effective and professional diagrams.

Download the Free eBook

Top comments (0)

Billboard image

The Next Generation Developer Platform

Coherence is the first Platform-as-a-Service you can control. Unlike "black-box" platforms that are opinionated about the infra you can deploy, Coherence is powered by CNC, the open-source IaC framework, which offers limitless customization.

Learn more