请根据 user_listen_record、song_library计算出QQ音乐20230306歌曲完播率（播放时长>=听歌时长）输出表结构如下,其中完播率保留小数点后2位小数并按照完播率重小到大排序：

song_playback_history

已知QQ音乐部分用户听歌流水表格式和样例数据如下：

user_listen_record

其中ftime为数据分区时间，uin为用户账号（唯一标识），os_type为设备端分类，song_id为歌曲id，app_ver为应用版本，play_duration为听歌时长（秒）

曲库信息表：

song_library

其中song_id为歌曲id（唯一标识），song_name歌曲名称，duration为歌曲时长（秒），artist_id为歌手id，artist_name为歌手名

with s1 as ( select distinct s1.song_id,count(s1.song_id) over (partition by s1.song_id) as compar_song
from user_listen_record s1
join song_library s2 on s1.song_id=s2.song_id and ftime=’20230306′
where play_duration=duration or play_duration>duration ),
s2 as ( select ftime,s1.song_id,song_name,count(*) as total_song from user_listen_record s1
join song_library s2 on s1.song_id=s2.song_id and ftime=’20230306′ group by ftime,s1.song_id,song_name ),
s3 as ( select ftime,s2.song_id as song_id,song_name,total_song,ifnull(compar_song,0) as compar_song from s2 left join s1 on s2.song_id=s1.song_id )
select ftime,song_id,song_name,cast(compar_song/total_song as DECIMAL(10,2)) as play_comp_rate from s3 order by play_comp_rate desc;

16:29