AVG growth using query SQL

Question

I have the following table:

Please help me to use the following query in SQL: "avg(value2/value1,value3/value2,value4/value3)"

Thanks so much !

Answer 1

For SQL Server 2008 or later;

; WITH CTE AS
(
SELECT *, LAG(VALUE) OVER(ORDER BY MONTH) AS XX FROM YOURTABLE
) 
SELECT AVG(CAST(VALUE AS FLOAT) / CAST(XX AS FLOAT)) FROM CTE WHERE XX IS NOT NULL

Answer 2

Try this:

SELECT AVG(Calc)
FROM
(
  SELECT t2.Value/t1.Value AS Calc
  FROM [Table] t1
  JOIN [Table] t2
  ON t1.[Month] = t2.[Month] + 1
) calc

Answer 3

Try Below Query .

            select avg(CAST(a.value as FLOAT)/cast(a.mm as FLOAT)) from
            (
            SELECT *, LAG(value) OVER(ORDER BY MONTH) AS mm FROM #your_table
            ) 
            a where a.mm is not null

Please let us know if u have an concerns

Answer 4

I want using query SQL for:

If i select month=3 => result = AVG(value2/value1,value3/value2)-1

If i select month=4 result = AVG(value2/value1,value3/value2,value4/value3)-1

Thanks