У нас вы можете посмотреть бесплатно Longest Winning Streak | Tricky SQL Problems | SQL Interview Questions или скачать в максимальном доступном качестве, видео которое было загружено на ютуб. Для загрузки выберите вариант из формы ниже:
Если кнопки скачивания не
загрузились
НАЖМИТЕ ЗДЕСЬ или обновите страницу
Если возникают проблемы со скачиванием видео, пожалуйста напишите в поддержку по адресу внизу
страницы.
Спасибо за использование сервиса ClipSaver.ru
In these video, I am going to solve a very interesting and tricky sql problem. The problem is find the longest winning streak for all the teams. CREATE TABLE `db`.`cricket` ( `Team` VARCHAR(10) NULL, `date` DATE NULL, `result` VARCHAR(10) NULL); INSERT INTO `db`.`cricket` (`Team`,`date`,`result`) VALUES("Team1","2023-01-01'","W"); INSERT INTO `db`.`cricket` (`Team`,`date`,`result`) VALUES("Team1","2023-02-01'","W"); INSERT INTO `db`.`cricket` (`Team`,`date`,`result`) VALUES("Team1","2023-03-01'","L"); INSERT INTO `db`.`cricket` (`Team`,`date`,`result`) VALUES("Team1","2023-04-01'","W"); INSERT INTO `db`.`cricket` (`Team`,`date`,`result`) VALUES("Team1","2023-05-01'","L"); INSERT INTO `db`.`cricket` (`Team`,`date`,`result`) VALUES("Team1","2023-06-01'","L"); INSERT INTO `db`.`cricket` (`Team`,`date`,`result`) VALUES("Team1","2023-07-01'","W"); INSERT INTO `db`.`cricket` (`Team`,`date`,`result`) VALUES("Team1","2023-08-01'","W"); INSERT INTO `db`.`cricket` (`Team`,`date`,`result`) VALUES("Team1","2023-09-01'","W"); INSERT INTO `db`.`cricket` (`Team`,`date`,`result`) VALUES("Team2","2023-01-01'","L"); INSERT INTO `db`.`cricket` (`Team`,`date`,`result`) VALUES("Team2","2023-02-01'","W"); INSERT INTO `db`.`cricket` (`Team`,`date`,`result`) VALUES("Team2","2023-03-01'","L"); INSERT INTO `db`.`cricket` (`Team`,`date`,`result`) VALUES("Team2","2023-04-01'","W"); INSERT INTO `db`.`cricket` (`Team`,`date`,`result`) VALUES("Team2","2023-05-01'","L"); INSERT INTO `db`.`cricket` (`Team`,`date`,`result`) VALUES("Team2","2023-06-01'","L"); INSERT INTO `db`.`cricket` (`Team`,`date`,`result`) VALUES("Team3","2023-01-01'","W"); INSERT INTO `db`.`cricket` (`Team`,`date`,`result`) VALUES("Team3","2023-02-01'","W"); INSERT INTO `db`.`cricket` (`Team`,`date`,`result`) VALUES("Team3","2023-03-01'","L"); INSERT INTO `db`.`cricket` (`Team`,`date`,`result`) VALUES("Team3","2023-04-01'","W");