Increase price by percentage, results rounded

SELECT product_c, price, (price* 1.20) as new_price FROM Table;

BEGIN TRAN

UPDATE products_tbl
SET price = CEILING(price * 1.03)

SELECT *
FROM products_tbl

ROLLBACK TRAN -- Because we only answer w/ commits for a fee.

add_filter( 'woocommerce_show_variation_price', 'filter_show_variation_price', 10, 3 );
function filter_show_variation_price( $condition, $product, $variation ){
    if( $variation->get_price() === "" ) return false;
    else return true;
}

IF OBJECT_ID('tempdb..#Cities') IS NOT NULL
BEGIN
    DROP TABLE #Cities;
END;

CREATE TABLE #Cities
(
    Country VARCHAR(20)
   , City    VARCHAR(20)
);

IF OBJECT_ID('tempdb..#Data') IS NOT NULL
BEGIN
    DROP TABLE #Data;
END;

CREATE TABLE #Data
(
    Country VARCHAR(20)
   , City    VARCHAR(20)
   , Price   DECIMAL(13, 4)
   , Date    DATETIME
);

INSERT INTO #Cities
VALUES      ('Country 1', 'City 1'), ('Country 1', 'City 2'), ('Country 1', 'City 3'), ('Country 2', 'City 4'), ('Country 2', 'City 5');


INSERT INTO #Data
SELECT Country
    , City
    , ROUND(RAND(CHECKSUM(NEWID())) * 100, 4) AS Price
    , DATEADD(DAY, ROUND(RAND(CHECKSUM(NEWID())) * 10, 0), GETDATE()) AS Date
FROM     #Cities
UNION
SELECT Country
    , City
    , ROUND(RAND(CHECKSUM(NEWID())) * 100, 4)
    , DATEADD(DAY, ROUND(RAND(CHECKSUM(NEWID())) * 10, 0), GETDATE())
FROM     #Cities;

--Delete duplicate dates

WITH data3 AS
(
SELECT *,ROW_NUMBER() OVER (PARTITION BY Country,City,Date ORDER BY Country,City,Date) AS RN
FROM #Data
)
DELETE FROM data3 WHERE RN<>1

SELECT        Dates.*
          , Latest.Price AS Latestprice
          , Previous.Price AS Previousprice
          , ((Latest.Price - Previous.Price) / Previous.Price) * 100 AS Percentageincrease
FROM
(
    SELECT    C.*
          , Latestdate.Latestdate
          , Previousdate.Previousdate
    FROM      #Cities AS C
            LEFT JOIN
    (
       --Latest Date for each county, city
       SELECT Country
           , City
           , MAX(Date) AS Latestdate
       FROM   #Data
       GROUP BY Country
            , City
    ) AS Latestdate ON Latestdate.Country = C.Country
                   AND Latestdate.City = C.City
            LEFT JOIN
    (
       --Previous Date for each county, city
       SELECT Country
           , City
           , Date AS Previousdate
       FROM
       (
          SELECT Country
              , City
              , Date
              , RANK() OVER(PARTITION BY Country
                                  , City ORDER BY Date DESC) AS Rank
          FROM   #Data
       ) AS A
       WHERE  Rank = 2
    ) AS Previousdate ON Previousdate.Country = C.Country
                    AND Previousdate.City = C.City
) AS Dates
JOIN #Data AS Latest ON Latest.Country = Dates.Country
                    AND Latest.City = Dates.City
                    AND Latest.Date = Dates.Latestdate
JOIN #Data AS Previous ON Previous.Country = Dates.Country
                     AND Previous.City = Dates.City
                     AND Previous.Date = Dates.Previousdate

SELECT D.Country
    , D.City
    , D.Date
    , Lag(Date) OVER(PARTITION BY Country
                           , City ORDER BY Date) AS Previousdate
    , D.Price
    , Lag(Price) OVER(PARTITION BY Country
                            , City ORDER BY Date) AS Previousprice
    , 100 * (Price / Lag(Price) OVER(PARTITION BY Country
                                        , City ORDER BY Date) - 1) AS PercentageIncrease
FROM   #Data AS D;

SELECT *
FROM
(
    SELECT D.Country
        , D.City
        , D.Date
        , Lag(Date) OVER(PARTITION BY Country
                              , City ORDER BY Date) AS Previousdate
        , D.Price
        , Lag(Price) OVER(PARTITION BY Country
                               , City ORDER BY Date) AS Previousprice
        , 100 * (Price / Lag(Price) OVER(PARTITION BY Country
                                           , City ORDER BY Date) - 1) AS Percentageincrease
        , ROW_NUMBER() OVER(PARTITION BY Country
                                , City ORDER BY Date DESC) AS Rn
    FROM   #Data AS D
) AS A
WHERE  Rn = 1
ORDER BY Country
      , City;