• stratascratch-medium
  • Find-the-total-number-of-approved-friendship-requests-in-January-and-February

Find the total number of approved friendship requests in January and February

#Meta/Facebook

Find the total number of approved friendship requests in January and February.

table:facebook_friendship_requests


Solution:

select count(*) as approved from facebook_friendship_requests
where month(date_approved) in (2,1)

Output:


SQL Script:

USE [StrataScratch]
GO
CREATE TABLE [dbo].[facebook_friendship_requests](
	[sender] [int] NULL,
	[receiver] [int] NULL,
	[date_sent] [datetime] NULL,
	[date_approved] [datetime] NULL
) ON [PRIMARY]
GO
INSERT [dbo].[facebook_friendship_requests] ([sender], [receiver], [date_sent], [date_approved]) VALUES (0, 1, CAST(N'2019-01-01T00:00:00.000' AS DateTime), NULL)
GO
INSERT [dbo].[facebook_friendship_requests] ([sender], [receiver], [date_sent], [date_approved]) VALUES (0, 2, CAST(N'2019-01-02T00:00:00.000' AS DateTime), CAST(N'2019-02-02T00:00:00.000' AS DateTime))
GO
INSERT [dbo].[facebook_friendship_requests] ([sender], [receiver], [date_sent], [date_approved]) VALUES (0, 3, CAST(N'2019-01-03T00:00:00.000' AS DateTime), CAST(N'2019-03-02T00:00:00.000' AS DateTime))
GO
INSERT [dbo].[facebook_friendship_requests] ([sender], [receiver], [date_sent], [date_approved]) VALUES (4, 5, CAST(N'2019-01-01T00:00:00.000' AS DateTime), CAST(N'2019-01-02T00:00:00.000' AS DateTime))
GO
INSERT [dbo].[facebook_friendship_requests] ([sender], [receiver], [date_sent], [date_approved]) VALUES (4, 6, CAST(N'2019-01-01T00:00:00.000' AS DateTime), CAST(N'2019-01-02T00:00:00.000' AS DateTime))
GO
INSERT [dbo].[facebook_friendship_requests] ([sender], [receiver], [date_sent], [date_approved]) VALUES (4, 7, CAST(N'2019-01-01T00:00:00.000' AS DateTime), NULL)
GO




Comments (0)
Questions List