Question

4. Get the number of videos uploaded by the "News for you" channel in the year in 2018.

Expected Output Format

no of videos

Answer 1

select count(video_id) 
from videos
where channel = News_for_you, year=2018;