Hi Guys,

I need help with below question.

table has 2 columns Year and Team name
data is as per below

INSERT INTO Team2(Year, Team)
WITH Team2 AS (
SELECT 2000, 'Ind' FROM dual UNION ALL
SELECT 2001, 'SA' FROM dual UNION ALL
SELECT 2002, 'Ind'FROM dual UNION ALL
SELECT 2003, 'Ind' FROM dual UNION ALL
SELECT 2004, 'Ind' FROM dual UNION ALL
SELECT 2005, 'Aus' FROM dual UNION ALL
SELECT 2006, 'Aus' FROM dual UNION ALL
SELECT 2007, 'SL' FROM dual UNION ALL
SELECT 2008, 'SL' FROM dual UNION ALL
SELECT 2009, 'SA' FROM dual UNION ALL
SELECT 2010, 'SA' FROM dual UNION ALL
SELECT 2011, 'Ind' FROM dual UNION ALL
SELECT 2012, 'Ind' FROM dual UNION ALL
SELECT 2013, 'Aus' FROM dual UNION ALL
SELECT 2014, 'Aus' FROM dual UNION ALL
SELECT 2015, 'Aus' FROM dual UNION ALL
SELECT 2016, 'Aus' FROM dual UNION ALL
SELECT 2017, 'Ind' FROM dual
)
SELECT * FROM Team2;

find the maximum consecutive wins for a team.