Answer to Question #284134 in Databases | SQL | Oracle | MS Access for Lovely

Question

12. Get the total number of users subscribed for the channel "Tyler Oakley" (channel_id = 376) in the year 2018.

Expected Output Format

no_of_subscribers

Answer 1

select count(user_id) 
from users
where channel_id = 376, year=2018;