1、单选题:也是大部分测试的知识、还有一些数学逻辑题、Jenkins架构要熟悉一下2、多选题:接口测试、HTTP状态码、操作系统、测试的知识3、编程是一个SQL,牛客原题:被重复观看次数最多的3个视频witht1 as (selectpr.uid,pr.cid,COUNT(*) as views_countfromplay_record_tb prgroup bypr.uid,pr.cid),t2 as (selectt1.cid,ROUND(sum(t1.views_count), 3) as vcfromt1wheret1.views_count > 1group byt1.cid),rank_data as (selectt2.cid,t2.vc,ROW_NUMBER() over (ORDER byt2.vc DESC,c1.release_date DESC) as rkfromt2join course_info_tb c1 on t2.cid = c1.cid)select rank_data.cid cid, rank_data.vc pv, rank_data.rk rkfrom rank_dataorder by rklimit 3;