Largest Price Increases

Shows the items with the largest price increases, comparing the most recent price to the previous price

Custom SQL query returning 20 rows (hide) 

WITH price_changes AS (SELECT p1.item_id, m.name, s.store_name, p1.base_price / 100.0 AS new_price, p2.base_price / 100.0 AS old_price, p1.effective_date AS new_date, p2.effective_date AS old_date, (p1.base_price - p2.base_price) / 100.0 AS price_difference FROM item_prices p1 JOIN item_prices p2 ON p1.item_id = p2.item_id AND p1.store_id = p2.store_id JOIN menu_items m ON p1.item_id = m.id JOIN stores s ON p1.store_id = s.id WHERE p1.effective_date > p2.effective_date AND p1.effective_date = (SELECT MAX(effective_date) FROM item_prices WHERE item_id = p1.item_id AND store_id = p1.store_id) AND p2.effective_date = (SELECT MAX(effective_date) FROM item_prices WHERE item_id = p1.item_id AND store_id = p1.store_id AND effective_date < p1.effective_date)) SELECT name, store_name, old_price, new_price, price_difference, old_date, new_date FROM price_changes ORDER BY price_difference DESC LIMIT 20

Edit SQL

This data as json, CSV

namestore_nameold_pricenew_priceprice_differenceold_datenew_date
Coffee Traveller ION Orchard 31.5 33.6 2.1 2024-10-20 2024-10-27
Hojicha Tea Cream Frappuccino® ION Orchard 7.6 8.2 0.6 2024-06-28 2024-10-20
Caramel Frappuccino® ION Orchard 7.2 7.7 0.5 2024-06-28 2024-10-20
Mocha Frappuccino® ION Orchard 7.2 7.7 0.5 2024-06-28 2024-10-20
Espresso Frappuccino® ION Orchard 7.2 7.7 0.5 2024-06-28 2024-10-20
White Chocolate Mocha Frappuccino® ION Orchard 7.2 7.7 0.5 2024-06-28 2024-10-20
Vanilla Cream Frappuccino® ION Orchard 7.2 7.7 0.5 2024-06-28 2024-10-20
Mango Passion Fruit & Hibiscus ION Orchard 7.2 7.7 0.5 2024-06-28 2024-10-20
Raspberry Black Currant & Oolong ION Orchard 7.2 7.7 0.5 2024-06-28 2024-10-20
Dark Mocha Frappuccino® ION Orchard 7.8 8.2 0.4 2024-06-28 2024-10-20
Java Chip Frappuccino® ION Orchard 7.8 8.2 0.4 2024-06-28 2024-10-20
Caramel Macchiato Frappuccino® ION Orchard 7.8 8.2 0.4 2024-06-28 2024-10-20
Chocolate Chip Cream Frappuccino® ION Orchard 7.8 8.2 0.4 2024-06-28 2024-10-20
Caffè Mocha ION Orchard 7.5 7.9 0.4 2024-06-28 2024-10-20
Caramel Macchiato ION Orchard 7.6 8.0 0.4 2024-06-28 2024-10-20
Vanilla Latte ION Orchard 7.5 7.9 0.4 2024-06-28 2024-10-20
White Chocolate Mocha ION Orchard 7.5 7.9 0.4 2024-06-28 2024-10-20
Flat White ION Orchard 7.6 8.0 0.4 2024-06-28 2024-10-20
Ristretto Bianco ION Orchard 7.6 8.0 0.4 2024-06-28 2024-10-20
Iced Caffè Mocha ION Orchard 7.5 7.9 0.4 2024-06-28 2024-10-20