#9 How to solve complex Tricky SQL Queries - CTE, Aggregates

array(10) { [0]=> object(stdClass)#5219 (5) { ["video_id"]=> int(9999999) ["related_video_id"]=> string(11) "J5GmAiuWsLI" ["related_video_title"]=> string(61) "#10 Solving Tricky SQL Queries for INTERVIEWS | SQL beginners" ["posted_time"]=> string(25) "2 месяца назад" ["channelName"]=> string(14) "Crack Concepts" } [1]=> object(stdClass)#5192 (5) { ["video_id"]=> int(9999999) ["related_video_id"]=> string(11) "wALCw0F8e9M" ["related_video_title"]=> string(55) "How to create new Database and Table in MySQL WorkBench" ["posted_time"]=> string(21) "4 года назад" ["channelName"]=> string(11) "Amit Thinks" } [2]=> object(stdClass)#5217 (5) { ["video_id"]=> int(9999999) ["related_video_id"]=> string(11) "6L-_U4lbssY" ["related_video_title"]=> string(84) "🔴 INSIDE ADVANT | Consulente Data&AI: l’Academy Advant apre 8 posizioni" ["posted_time"]=> string(24) "16 часов назад" ["channelName"]=> string(6) "Joinrs" } [3]=> object(stdClass)#5224 (5) { ["video_id"]=> int(9999999) ["related_video_id"]=> string(11) "LJC8277LONg" ["related_video_title"]=> string(88) "SQL WITH Clause | Clearly Explained | CTEs vs Subqueries vs Temp Tables | Recursive CTEs" ["posted_time"]=> string(28) "11 месяцев назад" ["channelName"]=> string(15) "Maven Analytics" } [4]=> object(stdClass)#5203 (5) { ["video_id"]=> int(9999999) ["related_video_id"]=> string(11) "xG4vmQsWxgk" ["related_video_title"]=> string(58) "TOP 10 *MOST* Imp DBMS Interview Questions | DBMS tutorial" ["posted_time"]=> string(23) "1 месяц назад" ["channelName"]=> string(14) "Crack Concepts" } [5]=> object(stdClass)#5221 (5) { ["video_id"]=> int(9999999) ["related_video_id"]=> string(11) "zg9GNdX-Q9g" ["related_video_title"]=> string(93) "CTE in SQL (Common Table Expression) | SQL WITH Clause | CTE Query Performance | Advanced SQL" ["posted_time"]=> string(21) "3 года назад" ["channelName"]=> string(12) "Sumit Mittal" } [6]=> object(stdClass)#5216 (5) { ["video_id"]=> int(9999999) ["related_video_id"]=> string(11) "m-H-nEfM60g" ["related_video_title"]=> string(71) "#4 Practice tricky JOINS SQL Queries for Interviews | Leetcode problems" ["posted_time"]=> string(25) "4 недели назад" ["channelName"]=> string(14) "Crack Concepts" } [7]=> object(stdClass)#5226 (5) { ["video_id"]=> int(9999999) ["related_video_id"]=> string(11) "8L51FUsjMxA" ["related_video_title"]=> string(115) "Как устроена База Данных? Кластеры, индексы, схемы, ограничения" ["posted_time"]=> string(27) "6 месяцев назад" ["channelName"]=> string(25) "Артём Шумейко" } [8]=> object(stdClass)#5202 (5) { ["video_id"]=> int(9999999) ["related_video_id"]=> string(11) "jGO6QtWOPJQ" ["related_video_title"]=> string(174) "КАСЬЯНОВ: "Я видел это своими глазами. Это не публиковалось": что показали Путину, чего он боится" ["posted_time"]=> string(24) "10 часов назад" ["channelName"]=> string(24) "И Грянул Грэм" } [9]=> object(stdClass)#5220 (5) { ["video_id"]=> int(9999999) ["related_video_id"]=> string(11) "_jVL2-x1vXQ" ["related_video_title"]=> string(128) "⚡️Трамп внезапно запросил помощь у Путина || Зеленского бросает НАТО?" ["posted_time"]=> string(20) "21 час назад" ["channelName"]=> string(23) "Время Прядко" } }