Block interview question

4 sql questions including regular expression and cte's