1、先安装navicat
链接:https://pan.baidu.com/s/17r_oHwjeiC6Pqdq2c8yFLQ
提取码:s4l7
复制这段内容后打开百度网盘手机App,操作更方便哦
2、安装成功后
通过PostgreSQL链接
填写信息
测试
感觉写的好沙雕 官方图标好看
eg:当你有一天尝尽了社会的无情,爱情的不堪,人心的险恶,你终会明白别人的屋檐再大都不如自己有把伞
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
继续摸鱼
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;