sql如何查询A表里有而B表里没有的数据的数据总和

select count(student) from B where student not in (select student from A)