小鸟王
SELECT
 pl_cn_name,count(sc_to_par) topar ,sc_pl_id,
(select count(su_score) from player_summary  su  left join `match` m_1 on su.su_mt_id=m_1.mt_id  where  su.su_pl_id=sc.sc_pl_id and su.su_sts='C' and YEAR (m_1.mt_start_date) = '2019' and m_1.not_save_prize = '0' and m_1.mt_type='PRO' ) as played_round
FROM
 player_score sc
LEFT JOIN `match` m ON m.mt_id = sc.sc_mt_id
left join player p on sc_pl_id =p.pl_id
WHERE
 m.not_save_prize = '0'
AND YEAR (m.mt_start_date) = '2019'
and m.mt_type='PRO'
AND sc.sc_to_par = -1
GROUP BY
sc_pl_id
ORDER BY
 topar DESC
 
 
最低平均杆
SELECT
 sum(su_score) / count(su_score) AS su_score,count(su_score) as totalround,
 su_pl_id,
 su_mt_id,
 pl_cn_name,
 count(su_score)
FROM
 player_summary ps
LEFT JOIN `match` m ON m.mt_id = ps.su_mt_id
LEFT JOIN player p ON su_pl_id = p.pl_id
WHERE
 m.not_save_prize = '0'
AND YEAR (m.mt_start_date) = '2019'
AND su_sts = 'C'
AND m.mt_type = 'PRO'
and (
 SELECT
 count(su1.su_pl_id )
 FROM
 player_summary su1
 LEFT JOIN `match` m1 ON m1.mt_id = su1.su_mt_id
 WHERE
 su1.su_pl_id = p.pl_id
 AND su1.su_sts = 'C'
 AND YEAR (m1.mt_start_date) = 2019
 AND m1.not_save_prize = '0'
 AND m1.mt_type = 'PRO'
 )>=12
GROUP BY
 su_pl_id
ORDER BY
 su_score ASC
 
 进步最快 
select b.Rank-a.Rank as tsub ,b.WgwrId ,p.pl_cn_name,pl_show from (
 SELECT
 *
 FROM
 db_world
 WHERE
 `Week` = '1/7/2019'
) b
right JOIN (
 SELECT
 *
 FROM
 db_world
 WHERE
 `Week` = '2019-11-11'
) a 
on b.WgwrId =a.WgwrId
left join player p on p.wgwrid=b.WgwrId
where pl_cn_name is not null and pl_show='CLPGA'
order by tsub desc ;

最佳新人
判断新晋球员的条件：会员生效时间大于20180331，小于20190300
SELECT
 pl_cn_name,sum(pz_amount) as sumamount,
pz_pl_id
FROM
 prize pz
LEFT JOIN `match` m ON m.mt_id = pz.pz_mt_id
left join player p on p.pl_id=pz_pl_id
WHERE
 m.not_save_prize = '0'
AND YEAR (m.mt_start_date) = '2019'
AND pz.pz_pl_id IN (
 SELECT
 pl_id​
 FROM
 player pp
 WHERE
 pp.pl_showineff_date >= '2019-00-00'
 AND pp.pl_show = 'CLPGA'
 AND ((pp.pl_showeff_date>"2018-03-31") and (pp.pl_showeff_date<"2019-03-00" ))
)

group by pz.pz_pl_id 
order by sumamount desc 

​