Promise this will be my last one:Whistling:

DECLARE @Question VARCHAR(50) = 'Year that England last beat Italy?'

SELECT CAST(

POWER(LEN(Italy),ItalyLastScore) *

POWER(LEN(England),EnglandLastScore) *

(LEN(@Question) / (ItalyLastScore + EnglandLastScore))

- (ItalyTotalWins - EnglandTotalWins)

- (TotalDraws / 2)

AS INT

)

FROM (VALUES ('Italy',2.0,'England',1.0,11.0,8.0,6.0))

Stats(Italy, ItalyLastScore,

England, EnglandLastScore,

ItalyTotalWins, EnglandTotalWins, TotalDraws)