sql语句中总计相加

select a.班别编号,  a.人数上限,a.人数上限-b.total
from table1 a
left join
(select 班别,count(班别) total from table2 ) b on b.班别=a.班别编号