Complex~34min

The Listing Price That Creeps Up Then Drops

8 listings, all from AGT-003, get their price bumped up within 2 days of listing, then discounted back down to near the original price just 5 days after that — marketed as a big "sale" that's actually just walking the price back to where it started. 6 other listings from different agents show the same increase-then-decrease shape, but the gap is 90 days — genuine repricing after a long stretch with no offers.

Tables you'll query

listingsprice_history

What you'll learn

CTEs (WITH clause)Window FunctionsDate & Time Functions
Investigate this case →