-- Database schema
| Batting_Style : Batting_Id [ INTEGER ] primary_key , Batting_hand [ TEXT ] | Bowling_Style : Bowling_Id [ INTEGER ] primary_key , Bowling_skill [ TEXT ] | City : City_Id [ INTEGER ] primary_key , City_Name [ TEXT ] , Country_id [ INTEGER ] | Country : Country_Id [ INTEGER ] primary_key , Country_Name [ TEXT ] | Extra_Type : Extra_Id [ INTEGER ] primary_key , Extra_Name [ TEXT ] | Extra_Runs : Match_Id [ INTEGER ] , Over_Id [ INTEGER ] , Ball_Id [ INTEGER ] , Extra_Type_Id [ INTEGER ] Extra_Runs.Extra_Type_Id = Extra_Type.Extra_Id , Extra_Runs [ INTEGER ] , Innings_No [ INTEGER ] | Out_Type : Out_Id [ INTEGER ] primary_key , Out_Name [ TEXT ] | Outcome : Outcome_Id [ INTEGER ] primary_key , Outcome_Type [ TEXT ] | Player : Player_Id [ INTEGER ] primary_key , Player_Name [ TEXT ] , DOB [ DATE ] , Batting_hand [ INTEGER ] Player.Batting_hand = Batting_Style.Batting_Id , Bowling_skill [ INTEGER ] Player.Bowling_skill = Bowling_Style.Bowling_Id , Country_Name [ INTEGER ] Player.Country_Name = Country.Country_Id | Rolee : Role_Id [ INTEGER ] primary_key , Role_Desc [ TEXT ] | Season : Season_Id [ INTEGER ] primary_key , Man_of_the_Series [ INTEGER ] , Orange_Cap [ INTEGER ] , Purple_Cap [ INTEGER ] , Season_Year [ INTEGER ] | Team : Team_Id [ INTEGER ] primary_key , Team_Name [ TEXT ] | Toss_Decision : Toss_Id [ INTEGER ] primary_key , Toss_Name [ TEXT ] | Umpire : Umpire_Id [ INTEGER ] primary_key , Umpire_Name [ TEXT ] , Umpire_Country [ INTEGER ] Umpire.Umpire_Country = Country.Country_Id | Venue : Venue_Id [ INTEGER ] primary_key , Venue_Name [ TEXT ] , City_Id [ INTEGER ] Venue.City_Id = City.City_Id | Win_By : Win_Id [ INTEGER ] primary_key , Win_Type [ TEXT ] | Match : Match_Id [ INTEGER ] primary_key , Team_1 [ INTEGER ] Match.Team_1 = Team.Team_Id , Team_2 [ INTEGER ] Match.Team_2 = Team.Team_Id , Match_Date [ DATE ] , Season_Id [ INTEGER ] Match.Season_Id = Season.Season_Id , Venue_Id [ INTEGER ] Match.Venue_Id = Venue.Venue_Id , Toss_Winner [ INTEGER ] Match.Toss_Winner = Team.Team_Id , Toss_Decide [ INTEGER ] Match.Toss_Decide = Toss_Decision.Toss_Id , Win_Type [ INTEGER ] Match.Win_Type = Win_By.Win_Id , Win_Margin [ INTEGER ] , Outcome_type [ INTEGER ] Match.Outcome_type = Out_Type.Out_Id , Match_Winner [ INTEGER ] Match.Match_Winner = Team.Team_Id , Man_of_the_Match [ INTEGER ] Match.Man_of_the_Match = Player.Player_Id | Ball_by_Ball : Match_Id [ INTEGER ] Ball_by_Ball.Match_Id = Match.Match_Id , Over_Id [ INTEGER ] , Ball_Id [ INTEGER ] , Innings_No [ INTEGER ] , Team_Batting [ INTEGER ] , Team_Bowling [ INTEGER ] , Striker_Batting_Position [ INTEGER ] , Striker [ INTEGER ] , Non_Striker [ INTEGER ] , Bowler [ INTEGER ] | Batsman_Scored : Match_Id [ INTEGER ] Batsman_Scored.Match_Id = Match.Match_Id , Over_Id [ INTEGER ] , Ball_Id [ INTEGER ] , Runs_Scored [ INTEGER ] , Innings_No [ INTEGER ] | Player_Match : Match_Id [ INTEGER ] Player_Match.Match_Id = Match.Match_Id , Player_Id [ INTEGER ] Player_Match.Player_Id = Player.Player_Id , Role_Id [ INTEGER ] Player_Match.Role_Id = Rolee.Role_Id , Team_Id [ INTEGER ] Player_Match.Team_Id = Team.Team_Id | Wicket_Taken : Match_Id [ INTEGER ] Wicket_Taken.Match_Id = Match.Match_Id , Over_Id [ INTEGER ] , Ball_Id [ INTEGER ] , Player_Out [ INTEGER ] Wicket_Taken.Player_Out = Player.Player_Id , Kind_Out [ INTEGER ] Wicket_Taken.Kind_Out = Out_Type.Out_Id , Fielders [ INTEGER ] Wicket_Taken.Fielders = Player.Player_Id , Innings_No [ INTEGER ] |
-- -- What is the average winning margin of the matches held in Newlands?

SELECT AVG(T1.win_margin) FROM Match AS T1 INNER JOIN Venue AS T2 ON T1.venue_id = T2.venue_id WHERE T2.venue_name = 'Newlands';