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 Sands	0.3
Marina Bay Link Mall	0.3
Marina Square	0.3
Liat Towers	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
Gardens by the Bay	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
Bird Paradise	0.3
Thomson Plaza 2	0.3
Kopitiam City	0.3
Gleneagles Hospital	0.3
Active Garden	0.3
Takashimaya	0.3
Lazada One	0.3
Raffles City (Level 2)	0.3
6 Battery Road	0.3
The Rail Mall	0.3
Wisma Atria	0.3
Starbucks Sentosa Sensoryscape	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
Universal Studios Singapore	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
Resorts World Sentosa	0.3
River Wonders	0.3
Republic Plaza	0.3
Parkland Green	0.3
Paragon	0.3
Orchard Gateway	0.3
Orchard Cineleisure	0.3
One Fullerton	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
Pacific Plaza	0.3
The Poiz Centre	0.3
Paya Lebar Quarter	0.3
Rochester Park	0.3
The Metropolis	0.3
ION Orchard	0.28732394366197184
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