SQLize Online / PHPize Online  /  SQLtest Online

create table ytvids_mostviewed2020 ( Video_Number int identity(1,1) NOT NULL primary key, Title varchar (100), Uploader varchar (150), Date_Uploaded date, Current_Number_of_Views bigint, Duration decimal (12,4), ); create table ytvids_mostviewed2021 ( Video_Number int identity(1,1) NOT NULL primary key, Title varchar (100), Uploader varchar (150), Date_Uploaded date, Current_Number_of_Views bigint, Duration decimal (12,4), ); create table mostsubscribed_ytchannels ( Channel_No int identity(1,1) NOT NULL primary key, Channel_Name varchar (100), Subs_InMillion decimal (12,4), Video_Total int, Date_Created date, Country varchar (50), ) TABLES Insert into ytvids_mostviewed2020 (Title, Uploader, Date_Uploaded, Current_Number_of_Views, Duration) Values ('Baby Shark Dance|#babyshark Most Viewed Video','Pinkfong Baby Shark','2016-06-18',9793273771,02.16), ('Despacito ft.Daddy Yankee','Luis Fonsi','2020-01-13',7653073922,04.41), ('Shape Of You','Ed Sheeran','2017-01-30',5547667299,04.23), ('See You Again ft.Charlie Puth[Official Video]','Wiz Khalifa','2015-04-07',5346778051,03.57), ('Masha and The Bear-Recipe for disaster (Episode 17)','Masha and The Bear','2015-08-14',492951153,06.42), ('Uptown Funk (Official Video) ft. Bruno Mars','Mark Ronson','2014-11-19',4385104481,04.30), ('GANGNAM STYLE M/V','officialpsy','2012-07-15',4268984660,04.12), ('Sugar(Official Music Video)','Maroon5','2015-01-14',3601832578,05.01), ('Sorry(PURPOSE:The Movement)','Justin Bieber','2015-10-23',3491031823,03.25), ('Roar (Official)','Katy Perry','2013-09-06',3479900703,04.29); SELECT EXTRACT(year FROM Date_Uploaded) AS Year, COUNT(Video_Number) AS Videos_Posted FROM ytvids_mostviewed2020 GROUP BY Year; Insert into ytvids_mostviewed2021 (Title, Uploader, Date_Uploaded, Current_Number_of_Views, Duration) Values ('I Spent 50 Hours Buried Alive', 'MrBeast', '2021-03-28', 150424749, 12.39), ('Minecraft Speedrunner VS 5 Hunters', 'Dream', '2021-04-24', 62909534, 36.29), ('Glitterbomb Trap Catches Phone Scammer (who gets arrested)', 'Mark Rober', '2021-03-19', 49285680, 23.14), ('The Weeknd`s FULL Pepsi Super Bowl LV Halftime Show', 'NFL', '2021-02-08', 42924214, 14.17), ('Friday Night Funkin KEEPS GETTING BETTER AND BETTER (Part 2)', 'CoryxKenshin', '2021-01-23', 21844075, 24), ('Kids MAKE FUN OF Boy With AUTISMThey Instantly Regret It | Dhar Mann', 'Dhar Mann', '2021-04-14', 45903343, 8.13), ('Golden Buzzer: Nightbirde`s Original Song Makes Simon Cowell Emotional - Americas Got Talent 2021', 'Americas Got Talent', '2021-06-09', 37726149, 7.32), ('The Inauguration of Joe Biden and Kamala Harris | Jan. 20th, 2021', 'Biden Inaugural Committee', '2021-01-20', 14112990, 415.24), ('Spent 100 Days in a Zombie Apocalypse in Minecraft... Here is What Happened', 'Forge Labs', '2021-02-20', 43388447, 98.11), ('Game Night Stereotypes', 'Dude Perfect', '2021-01-26', 30111965, 9.4); SELECT Title, Uploader, Current_Number_of_Views FROM ytvids_mostviewed2021 GROUP BY Title, Uploader HAVING Current_Number_of_Views > 45000000 ORDER BY Current_Number_of_Views DESC; Insert into mostsubscribed_ytchannels (Channel_Name, Subs_InMillion, Video_Total, Date_Created, Country) Values ('T-Series', 200, 16064, '2006-03-13', 'India'), ('Cocomelon - Nursery Rhymes', 123, 713, '2006-09-01', 'USA'), ('SET India', 121, 71773, '2006-09-20', 'India'), ('PewDiePie', 110, 4464, '2010-10-02', 'Sweden'), ('Kids Diana Show', 86, 948, '2014-04-01', 'Ukraine'), ('WWE', 83.9, 58458, '2007-05-11', 'USA'), ('MrBeast', 83.8, 715, '2012-02-19', 'USA'), ('Like Nastya', 81.8, 641, '2014-01-27', 'Russia'), ('Zee Music Company', 79.5, 5924, '2014-03-12', 'India'), ('5-Minute Crafts', 74.7, 4992, '2016-11-15', 'USA'); SELECT Country, COUNT(Video_Number) AS Total_Channels, SUM(Subs_InMillion) FROM mostsubscribed_ytchannels GROUP BY Country