Data Science, Analytics, Programming, Software Development, Sql.
complex, SQL will become difficult in both understanding and writing! In fact, this problem can be easily solved by following natural thinking, you can do it in a few very simple steps: i)sort the records by trading day; ii) get the intervals of continuous rise and fall; iii) count the number of