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