Get all the channel_ids that uploaded at least 5 videos in "AI/ML", "Cyber Security", "Data Science" or "Robotics" technologies between 2018 and 2021.
Example: If a channel publishes 2 videos in AI/ML, 1 videos in Cyber Security and 2 videos in Data Science, consider the channel.
Table: Video
video_id name duration_in_secs published_datetime no_of_views channelid
1002 Victoria Beckham
Gives Strangers
Fashion Advice 836 2021-01-19 20:12 75609 353
for $2 in Central
Park | Vanity Fair
1007 DIY - Simon's Cat
|NEW BLACK & WHITE! 1365 2012-09-07 11:32 106271 355
1008 You, but in emojis.
(YIAY #375) 3874 2021-01-19 20:12 16469 352
1009 100 People Hold
Their Breath for as 2885 2015-05-17 19:32 272102 354
Long as They Can
1010 Luke Bryan - Hooked
On It (Audio) 2106 2016-02-10 12:32 184471 366
1011 The perfect ice -
Ice boats on 2549 2020-07-10 15:32 108047 352
Lake Geneva
1012 5 Days Of Wearing
DIY Makeup | Try 3172 2018-11-05 08:32 178623 358
Living With Lucie
| Refinery29
1013 Idiot's Guide to
Japanese Squat Toilets 709 2009-08-05 11:32 44293 356
1019 Vostok Brompton Beach
Ride 2022 2016-04-05 19:00 204704 367
1020 SHOPPING FOR NEW FISH!! 3496 2021-01-19 20:12 294429 359
1021 Paramore: Fake Happy
[OFFICIAL VIDEO] 1397 2015-07-05 19:00 245138 368
1022 Howard Stern: George
Takei Talks About Harvey
Weinstein and Sexually 776 2021-01-19 20:12 35875 360
Assault
1023 Tony Hawk Answers
Skateboarding Questions 4476 2017-02-17 19:32 143404 354
From Twitter |
Tech Support | WIRED
1024 Kimbra - Top of the
World (Official Music 3243 2015-01-05 19:00 220673 368
Video)
1025 Aly Raisman On Dr.
Larry Nassar’s Medical
Treatment: I Didn’t Know 2978 2014-12-17 19:32 93272 354
It Was Abuse | Megyn Kelly
TODAY
1026 When Someone Has A
Crush on You | Lilly Singh 959 2021-01-19 20:12 139481 360
1051 Demi Lovato - Sorry
Not Sorry in the Live Lounge 3929 2021-01-19 20:12 265864 365
channel_id
...
SELECT channelid FROM video_content WHERE name IN ("AI/ML", "Cyber Security", "Data Science", "Robotics") ORDER BY channelid ASC;
Comments
Leave a comment