select count(*) from table where ... select ... from table where ...