最近遇到了一道关于sql语句的笔试题,没写出来,想来问问大家应该怎么写。题目描述:现在有两张表分别是author_tb和answer_tb。author_tb中有以下字段:author_id, author_level和sex。answer_tb中有以下字段:answer_date, author_id, issue_id, char_len。现在希望能够查找出answer_tb中连续回答问题(answer_date)三天及以上的author_id, author_level和连续的天数。两张表的字段和数据如下:author_tbhttps://uploadfiles.nowcoder.com/images/20240127/479473040_1706355058148/EC50B19B7A4044261563BA23164D838Danswer_tbhttps://uploadfiles.nowcoder.com/images/20240127/479473040_1706355063978/EDC31D6BB782E4B5BF3F4B43873BA05F根据实例的两张表,最后得到的结果应该是:101 | 6 | 3 。https://uploadfiles.nowcoder.com/images/20240127/479473040_1706355275779/0EE66FDD85690660CC9316918E6CCB78