Longest Winning Streak | Tricky SQL Problems | SQL Interview Questions
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");
Auf dieser Seite können Sie das Online-Video Longest Winning Streak | Tricky SQL Problems | SQL Interview Questions mit der Dauer stunde minuten sekunde in guter Qualität ansehen, das der Benutzer DataTechWhiz 31 Januar 2024 hochgeladen hat, den Link mit Freunden und Bekannten teilen, dieses Video wurde auf Youtube bereits 1,369 Mal angesehen und es wurde von 58 den Zuschauern gefallen. Viel Spaß beim Betrachtenden Zuschauern gefallen!
