Search code examples
mysqldatabasemetabase

How to SUM the result of two different SQL query?


I want to SUM these two different queries. I joined both with USING function. but it shows the two results in two different cells.

I need a single result to SUM these two queries where the answer should be 4069.

The CODE

SELECT COUNT(*) Active_Projects FROM
(SELECT ProjectID, ProjectStatusID, ClientID
FROM project) a
INNER JOIN 
(SELECT ProjectStatusID, ClientID, ProjectStatusName
FROM ProjectStatus) b
ON (a.ProjectStatusID = b.ProjectStatusID AND a.ClientID = b.ClientID)
WHERE ProjectStatusName LIKE '%active%'
AND a.ClientID = 4

UNION

SELECT COUNT(*) Total_Projects
FROM Project
WHERE ClientID=4

Picture

Screenshot

Screenshot Here


Solution

  • Try this. select query1+ query2;

    select (
        SELECT COUNT(*) Active_Projects FROM
    (SELECT ProjectID, ProjectStatusID, ClientID
    FROM project) a
    INNER JOIN 
    (SELECT ProjectStatusID, ClientID, ProjectStatusName
    FROM ProjectStatus) b
    ON (a.ProjectStatusID = b.ProjectStatusID AND a.ClientID = b.ClientID)
    WHERE ProjectStatusName LIKE '%active%'
    AND a.ClientID = 4
    ) + (
    SELECT COUNT(*) Total_Projects
    FROM Project
    WHERE ClientID=4) ;