第三章 SELECT语句、表达式和子查询

/*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';