I want to create a query which merges the results of two queries from the same table.

```
select
(select count(distinct(Case_ID)) as expr1 from  dbo.Cases)
(select count(distinct(Case_ID)) as expr2 from dbo.Cases where Case_Status = 'Open')

```

The above produces two sets of results, what i want is a single set of results with `expr1` &
`expr2` as two separate columns. I will later use this result in SRSS.