count£¨£©

SELECT COUNT(*),0,0 FROM A
GROUP BY
UNION ALL
SELECT 0,COUNT(*),0 FROM B
GROUP BY
UNION ALL
SELECT 0,0,COUNT(*) FROM C
GROUP BY


SELECT SUM(A),SUM(B),SUM(C)
  FROM (SELECT COUNT(*) A,0 B,0 C 
          FROM X
      GROUP BY
      
     UNION ALL
        SELECT 0 A,COUNT(*) B,0 C 
          FROM B
      GROUP BY
      
     UNION ALL
        SELECT 0 A,0 B,COUNT(*) C 
        FROM C
      GROUP BY)
      
      
      










SELECT COUNT(*) A,0 B,0 C 
          FROM X
      GROUP BY