1、先安装navicat
链接：https://pan.baidu.com/s/17r_oHwjeiC6Pqdq2c8yFLQ
提取码：s4l7
复制这段内容后打开百度网盘手机App，操作更方便哦

2、安装成功后
通过PostgreSQL链接

填写信息

测试

感觉写的好沙雕 官方图标好看

eg：当你有一天尝尽了社会的无情，爱情的不堪，人心的险恶，你终会明白别人的屋檐再大都不如自己有把伞

第一关

select concat(right(attr,2),right(left(attr,4),2)) from level1

第二关

with tmp as (select num, string_agg(content, ' ') str
             from (select num, array_to_string(array_agg(concat(guo, qing, kuai, le)), '') as content
                   from (select row_number() over (PARTITION BY attr)   num,
                                CASE attr WHEN '国' THEN '国' ELSE '' END guo,
                                CASE attr WHEN '庆' THEN '庆' ELSE '' END qing,
                                CASE attr WHEN '快' THEN '快' ELSE '' END kuai,
                                CASE attr WHEN '乐' THEN '乐' ELSE '' END le
                         from level2) as rn
                   group by num, guo, qing, kuai, le
                   order by num, guo desc, qing desc, kuai desc, le desc) as nc
             group by num
             order by num)

select '                   ' chart union all
select '       chart       ' chart union all
select '-------------------' chart union all
select chart
from (select format('%2s | %s  ', lpad(concat(tmp.num), 2, '0'),
                    concat(CASE
                               WHEN position('国' in str) = 0 THEN '   '
                               ELSE (CASE
                                         WHEN position('庆' in str) <> 0 or position('快' in str) <> 0 or
                                              position('乐' in str) <> 0 THEN ''
                                         ELSE str END) END,
                           CASE
                               WHEN position('庆' in str) = 0 THEN '   '
                               ELSE (CASE
                                         WHEN position('快' in str) <> 0 or position('乐' in str) <> 0 THEN ''
                                         ELSE str END) END,
                           CASE
                               WHEN position('快' in str) = 0 THEN '   '
                               ELSE (CASE WHEN position('乐' in str) <> 0 THEN '' ELSE str END) END,
                           CASE WHEN position('乐' in str) = 0 THEN '   ' ELSE str END)) chart
      from tmp
      order by num desc) as tc
union all
select '-------------------' chart
union all
select '    2022-10-01     ' chart;

全评论区最烂

select  '
        *   *****   *****   *   *
        *   *   *       *   *   *
        *   *   *   *****   *****
        *   *   *   *           *
        *   *****   *****       *' as zero

一箱 6个核桃没了

@rui 等我再喝两罐 三个核桃

@彭于晏

@花殇 哈哈哈哈，大意了

继续摸鱼

select '
   _     __      ___    __ __      
 /  \  / __ \  / ___ \ /\ \\ \     
/\_  \/\ \/\ \/\_\ /\ \\ \ \\ \    
\/_/\ \ \ \ \ \/_/// /__\ \ \\ \_  
   \ \ \ \ \_\ \ // /_\ \\ \__  __\
    \ \_\ \____//\______/ \/_/\_\_/
     \/_/\/___/ \/_____/     \/_/  
' as zero

@花殇 看来咱两的差不多，哈哈哈哈

全评论区最烂

select  '
        *   *****   *****   *   *
        *   *   *       *   *   *
        *   *   *   *****   *****
        *   *   *   *           *
        *   *****   *****       *' as zero

第一关

select concat(right(attr,2),right(left(attr,4),2)) from level1

第二关

with tmp as (select num, string_agg(content, ' ') str
             from (select num, array_to_string(array_agg(concat(guo, qing, kuai, le)), '') as content
                   from (select row_number() over (PARTITION BY attr)   num,
                                CASE attr WHEN '国' THEN '国' ELSE '' END guo,
                                CASE attr WHEN '庆' THEN '庆' ELSE '' END qing,
                                CASE attr WHEN '快' THEN '快' ELSE '' END kuai,
                                CASE attr WHEN '乐' THEN '乐' ELSE '' END le
                         from level2) as rn
                   group by num, guo, qing, kuai, le
                   order by num, guo desc, qing desc, kuai desc, le desc) as nc
             group by num
             order by num)

select '                   ' chart union all
select '       chart       ' chart union all
select '-------------------' chart union all
select chart
from (select format('%2s | %s  ', lpad(concat(tmp.num), 2, '0'),
                    concat(CASE
                               WHEN position('国' in str) = 0 THEN '   '
                               ELSE (CASE
                                         WHEN position('庆' in str) <> 0 or position('快' in str) <> 0 or
                                              position('乐' in str) <> 0 THEN ''
                                         ELSE str END) END,
                           CASE
                               WHEN position('庆' in str) = 0 THEN '   '
                               ELSE (CASE
                                         WHEN position('快' in str) <> 0 or position('乐' in str) <> 0 THEN ''
                                         ELSE str END) END,
                           CASE
                               WHEN position('快' in str) = 0 THEN '   '
                               ELSE (CASE WHEN position('乐' in str) <> 0 THEN '' ELSE str END) END,
                           CASE WHEN position('乐' in str) = 0 THEN '   ' ELSE str END)) chart
      from tmp
      order by num desc) as tc
union all
select '-------------------' chart
union all
select '    2022-10-01     ' chart;

@rui 哈哈哈哈，这出题人绝对领悟到了羊的精髓了