挚文集团笔试复盘

1、单选题：也是大部分测试的知识、还有一些数学逻辑题、Jenkins架构要熟悉一下#牛客AI配图神器#
2、多选题：接口测试、HTTP状态码、操作系统、测试的知识

3、编程是一个SQL，牛客原题：被重复观看次数最多的3个视频
with
    t1 as (
        select
            pr.uid,
            pr.cid,
            COUNT(*) as views_count
        from
            play_record_tb pr
        group by
            pr.uid,
            pr.cid
    ),
    t2 as (
        select
            t1.cid,
            ROUND(sum(t1.views_count), 3) as vc
        from
            t1
        where
            t1.views_count > 1
        group by
            t1.cid
    ),
    rank_data as (
        select
            t2.cid,
            t2.vc,
            ROW_NUMBER() over (
                ORDER by
                    t2.vc DESC,
                    c1.release_date DESC
            ) as rk
        from
            t2
            join course_info_tb c1 on t2.cid = c1.cid
    )

select rank_data.cid cid, rank_data.vc pv, rank_data.rk rk
from rank_data
order by rk
limit 3;