MySQL Combining Multiple Count Queries

Question

I have the following query:

SELECT COUNT(package) as advanced_count FROM users WHERE package = '2' AND site_url is     NOT NULL;

What I want to do is have 2 more queries to get the basic_count and then the total_count which is basic + advanced.

My other basic query is:

SELECT count(package) as basic_count FROM users WHERE package = '1' AND site_url is NOT NULL

But I'm not sure how to combine the two so it is just one query, and then plus adding the total number in there as well.

I hope someone can point me in the right directions.

Thank you!

Joe Stefanelli · Accepted Answer · 2011-09-06 15:40:43Z

4

SELECT SUM(CASE WHEN package = '2' THEN 1 ELSE 0 END) AS advanced_count,
       SUM(CASE WHEN package = '1' THEN 1 ELSE 0 END) AS basic_count,
       COUNT(*) AS total_count
    FROM users
    WHERE site_url IS NOT NULL
        AND package IN ('1', '2');

answered Sep 6, 2011 at 15:40

Joe Stefanelli

136k21 gold badges243 silver badges241 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

MySQL Combining Multiple Count Queries

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related