/*1.找到至少引发两次多余25美元的罚款的每个球员号码,根据球员号码对结果排序。*/
use tennis;
select playerno
from players,penalties
where amount>25
having count(*)>1
order by playerno;
/*2.获得居住在Stratford的每个球员的号码和联盟会员号码,根据联盟号码排序。*/
select playerno,leagueno
from players
where town='Stratford'
order by leagueno;
/*3.获取球队队长的号码以及引发罚款的球员号码。*/
select playerno
from teams
union
select playerno
from penalties;
/*4.获得编号小于10的男性球员号码。*/
select playerno
from(select playerno,sex
from players
where playerno<10) as player10
where sex='M';