Just read an article on cracking down house flipping in NZ, it says “New Zealand’s real estate watchdog is ramping up its crackdown on house-flipping by investing in new technology which allows it to track when properties have been quickly re-sold for huge profits.”
So what’s the new technology is about? You would have thought there is a database table with a simple SQL query like this:
select * from sales_record r1 left join sales_record r2 on r1.title_no = r2.title_no and r1.id < r2.id where datediff(r2.sales_date, r1.sales_date) < 30;