• Guest, before posting your code please take these rules into consideration:
    • It is required to use our BBCode feature to display your code. While within the editor click < / > or >_ and place your code within the BB Code prompt. This helps others with finding a solution by making it easier to read and easier to copy.
    • You can also use markdown to share your code. When using markdown your code will be automatically converted to BBCode. For help with markdown check out the markdown guide.
    • Don't share a wall of code. All we want is the problem area, the code related to your issue.

    To learn more about how to use our BBCode feature, please click here.

    Thank you, Code Forum.

LAG() not working on phpmyadmin

I created a view for weekly sales. Everything is working fine on localhost using MySQL.
But when I upload the database on GoDaddy Lag doesn't seem to work.
When I am typing LAG on phpmyadmin, no suggestion is showing. Can anyone help me with this one? Thanks

the structure of vw_sales is
| order_date| sales |

Here's my code:
CREATE VIEW vw_weekly_sales AS
    YEAR(order_date) AS YEAR,
    WEEK(order_date) AS WEEK,
    SUM(sales) AS sales,
    SUM(sales) - LAG(sales) OVER (ORDER BY vw_sales.`order_date` ASC) AS sales_growth,
    (SUM(sales) - LAG(vw_sales.`sales`) OVER (ORDER BY vw_sales.`order_date` ASC)) / LAG(sales) OVER(ORDER BY vw_sales.`order_date` ASC) * 100 AS sales_growth_percentage
FROM vw_sales
GROUP BY YEAR(order_date), MONTH(order_date), WEEK(order_date);
Top Bottom