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");
In questa pagina del sito puoi guardare il video online Longest Winning Streak | Tricky SQL Problems | SQL Interview Questions della durata di ore minuti seconda in buona qualità , che l'utente ha caricato DataTechWhiz 31 gennaio 2024, condividi il link con amici e conoscenti, su youtube questo video è già stato visto 1,369 volte e gli è piaciuto 58 spettatori. Buona visione!
