Average Price Change by Store

Shows the average price change across all items for each store

Custom SQL query returning 142 rows (hide)

WITH price_changes AS (SELECT p1.store_id, (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 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 s.store_name, AVG(price_difference) AS avg_price_change FROM price_changes pc JOIN stores s ON pc.store_id = s.id GROUP BY s.id ORDER BY avg_price_change DESC

Edit SQL

This data as json, CSV

store_name	avg_price_change
Marina Bay Link Mall	0.3
Marina Square	0.3
Katong Square	0.3
Kampung Admiralty	0.3
Kallang Wave Mall	0.3
Keat Hong Community Club	0.3
Jurong Point	0.3
JEM	0.3
Jalan Jamal (Siglap)	0.3
Jelita	0.3
HomeTeamNS	0.3
Hougang Mall (Near Hougang MRT station)	0.3
HillV2	0.3
Hillion Mall	0.3
Hong Leong Building	0.3
Hougang 1 (Street 91)	0.3
Gateway	0.3
Great World City	0.3
Fusionopolis (Connexis)	0.3
Far East Square	0.3
East Point Mall	0.3
25 North Bridge Road (Formerly EFG Building)	0.3
Downtown East	0.3
Delfi Orchard	0.3
Woodlands Civic Centre	0.3
City House	0.3
Chinatown Point	0.3
Capital Tower	0.3
City Square Mall	0.3
Concourse	0.3
Centrepoint	0.3
Cintech IV	0.3
Compass One	0.3
CityLink Mall	0.3
Clementi Mall	0.3
Changi General Hospital	0.3
Changi City Point (near Expo MRT)	0.3
The Central	0.3
Canberra Plaza	0.3
Coronation Shopping Plaza	0.3
Bishan Community Club	0.3
Bukit Panjang Plaza	0.3
Biopolis	0.3
Bugis+	0.3
Bugis Junction	0.3
Bedok Mall	0.3
Asia Square Tower 2	0.3
Aperia Mall	0.3
Ang Mo Kio Hub	0.3
100 AM	0.3
Anchorpoint	0.3
78 Shenton Way	0.3
313@Somerset	0.3
20 Anson Road	0.3
Kinex (Formerly OneKM Shopping Mall)	0.3
One George	0.3
One Holland Village	0.3
Century Square	0.3
The Woodleigh Mall	0.3
Thomson Plaza 2	0.3
Kopitiam City	0.3
Gleneagles Hospital	0.3
Takashimaya	0.3
Lazada One	0.3
6 Battery Road	0.3
The Rail Mall	0.3
Wisma Atria	0.3
Raffles Hospital	0.3
YewTee Point	0.3
Jurong Lake Gardens (Lakeside House)	0.3
Jewel Changi Airport	0.3
Zhongshan Mall	0.3
Waterway Point	0.3
Harbourfront Centre	0.3
White Sands	0.3
West Coast Plaza	0.3
West Mall	0.3
Woodlands Xchange (Woodlands MRT)	0.3
Westgate	0.3
Wilkie Edge	0.3
Valley Point	0.3
VivoCity	0.3
United Square	0.3
UE Square	0.3
Tampines West Community Club	0.3
Tampines Mall #01-00	0.3
Toa Payoh HDB Hub	0.3
Guoco Tower (Formerly Tanjong Pagar Centre)	0.3
Our Tampines Hub	0.3
Tekka Place	0.3
Tanglin Mall	0.3
Tiong Bahru Plaza	0.3
Sun Plaza	0.3
Suntec City Tower 5 (Level 1)	0.3
Suntec City Tower 3 (Level 2)	0.3
Science Park II	0.3
Singapore Management University	0.3
Seletar Mall	0.3
Singapore Land Tower	0.3
SIM	0.3
SingHealth Tower	0.3
Republic Plaza	0.3
Parkland Green	0.3
Paragon	0.3
Orchard Gateway	0.3
Orchard Cineleisure	0.3
OCBC Centre	0.3
Oasis Terraces	0.3
NEX	0.3
One@KentRidge	0.3
Ng Teng Fong General Hsptl	0.3
Novena Square (Office Tower)	0.3
Northpoint City	0.3
Mt Elizabeth Novena Hospital	0.3
Millenia Walk	0.3
Maple Tree Business City 2	0.3
Mapletree Business City (Mapletree @ 20)	0.3
Plaza 8	0.3
Parkway Parade	0.3
Plaza Singapura	0.3
The Poiz Centre	0.3
Paya Lebar Quarter	0.3
Rochester Park	0.3
The Metropolis	0.3
Liat Towers	0.29379310344827586
Raffles City (Level 2)	0.29379310344827586
Pacific Plaza	0.29230769230769227
ION Orchard	0.28732394366197184
Universal Studios Singapore	0.2872340425531915
Resorts World Sentosa	0.2872340425531915
River Wonders	0.2872340425531915
One Fullerton	0.2872340425531915
Gardens by the Bay	0.28695652173913044
Bird Paradise	0.28695652173913044
Active Garden	0.28695652173913044
Starbucks Sentosa Sensoryscape	0.28695652173913044
Marina Bay Sands	0.27499999999999997
NUS University Town	0.2
NUS Techno Edge	0.2
Singapore Polytechnic	0.2
NUS Wet Science Building	0.2
NTU North Spine	0.2