I am trying to compare sales from different quarters by stores in adventureworks 2014.
My code is as following

```
SELECT store.BusinessEntityID as "StoreID",  "Name"
from sales.SalesOrderHeader
inner join sales.customer 
    on sales.SalesOrderHeader.CustomerID = sales.customer.CustomerID
inner join sales.store 
    on sales.customer.StoreID= sales.store.BusinessEntityID
where (OrderDate between '2014-01-01' and '2014-03-31')
    and (OnlineOrderFlag = 0)
group by store.BusinessEntityID, "Name"
having format(round(sum(subtotal),2),'###,###,###.##') > format(round(sum(subtotal),2),'###,###,###.##') IN
(
   SELECT store.BusinessEntityID as "StoreID",
   format(round(sum(subtotal),2),'###,###,###.##') "Ventes2013_Q4"
   from sales.SalesOrderHeader
   inner join sales.customer on sales.SalesOrderHeader.CustomerID =     sales.customer.CustomerID
   inner join sales.store on sales.customer.StoreID= sales.store.BusinessEntityID
   where (orderdate between '2013-10-01' and '2013-12-31') and OnlineOrderFlag = 0
   group by store.BusinessEntityID
) 

```

Both my main query and my subquery work individually, but I am not able to specify the column i want to compare it with in the second part of the having. When trying IN it gives me an incorrect syntax, and it does not work when using the column name either. It also did not work when adding a sales column in the main query
Can anyone point me in the right direction?