prova:

codice:
SELECT (select count(*) 
       FROM users 
       WHERE users.id > 6) 
      +
      (select count(*) 
      FROM admin 
      WHERE admin.id > 2) 
      as tot
ma escluderei proprio tu possa fare:

SELECT COUNT(*) AS "subcount" FROM admin
WHERE users.id > 2