Sql, Spl, Database.
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