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.
table name: pages
table name: page_likes
Solution:
select p.page_id from pages as p
left join page_likes as l
on p.page_id = l.page_id
where l.user_id is null
order by p.page_id asc
Output:
SQL Script:
CREATE TABLE [dbo].[page_likes](
[user_id]
[int] NULL,
[page_id]
[int] NULL,
[liked_date]
[datetime] NULL
) ON [PRIMARY]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[pages](
[page_id] [int] NULL,
[page_name] [varchar](50) NULL
) ON [PRIMARY]
GO
INSERT [dbo].[page_likes] ([user_id], [page_id], [liked_date]) VALUES (111, 20001, CAST(N'2022-08-04T00:00:00.000' AS DateTime))
GO
INSERT [dbo].[page_likes] ([user_id], [page_id], [liked_date]) VALUES (121, 20045, CAST(N'2002-03-13T01:52:00.000' AS DateTime))
GO
INSERT [dbo].[page_likes] ([user_id], [page_id], [liked_date]) VALUES (156, 20001, CAST(N'2022-07-25T00:00:00.000' AS DateTime))
GO
INSERT [dbo].[pages] ([page_id], [page_name]) VALUES (20001, N'SQL Solutions')
GO
INSERT [dbo].[pages] ([page_id], [page_name]) VALUES (20045, N'Brain Exercises')
GO
INSERT [dbo].[pages] ([page_id], [page_name]) VALUES (20701, N'Tips for Data Analysts')
GO
GO
SET QUOTED_IDENTIFIER ON
GO