Combine two SQL queries into a single SQL query statement

Question

I was using this query to get count of users whose date of birth lies between the given date range.

select 
    count(distinct first_name) 
from 
    quser q 
inner join 
    other_details o on o.country = q.country_of_birth 
where 
    date_of_birth between '2020-02-01' and '2020-03-01' 
    and email is not null;

Output

 count
-------
    21
(1 row)

Using the same query, but this time, users not fall on the given range added not before between.

select 
    count(distinct first_name) 
from 
    quser q 
inner join 
    other_details o on o.country = q.country_of_birth 
where 
    date_of_birth not between '2020-02-01' and '2020-03-01' 
    and email is not null;

Output

 count
-------
   498
(1 row)

Is there any way to combine the query and produce a single output as,

 count no  count yes
---------  -------
   498        21
(1 row)

I removed the conflicting DBMS tags. Please add only the tag for the database product you are really using. — user330315
– user330315, Commented Apr 4, 2021 at 9:21

forpas · Accepted Answer · 2021-04-04 09:20:01Z

2

Use conditional aggregation:

select count(distinct case when date_of_birth between '2020-02-01' and '2020-03-01' then first_name end) count_yes,
       count(distinct case when date_of_birth not between '2020-02-01' and '2020-03-01' then first_name end) count_no
from quser q inner join other_details o 
on o.country = q.country_of_birth 
where email is not null;

answered Apr 4, 2021 at 9:20

forpas

165k10 gold badges51 silver badges85 bronze badges

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

Collectives™ on Stack Overflow

Combine two SQL queries into a single SQL query statement

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