Sales Table
Sale_ID int
Sale_approved_date date
Store_ID int
Store Table
Store_ID int
Store_Name varchar
Store_Special boolean
I added the below code to calculate Store_Special with respect to overall store_special where the year is 2018. I can’t seem to do a calculation where I need two group by to extract the condition with respect to overall where there is no condition for st.store_special = 1.
Expected Outcome: dd.store_special = 1/ dd.store_special =1 or dd.store_special = 0 (overall store_special count) ==> Group by month to see the ratio of store special = 1 / no condition/total count without condition.
SELECT Datepart(month,s.sale_approved_date) AS month,
Count(Datepart(month,s.sale_approved_date))/ (Sum((Datepart(month,s.sale_approved_date)) )
from sales s
LEFT JOIN store AS st
ON s.store_id = st.store_id
WHERE datepart(year,.sale_approved_date) = '2018'
AND dd.store_special = 1
GROUP BY datepart(month,.sale_approved_date)
ORDER BY count(*) DESC
غزل فومhttps://www.facebook.com/شركة-ارم-عزل-حراري-عزل-مائى-110037991557676/
TOP 10 best escort service providers in dubai
WE ARE UAE BASED ESCORT SERVICES PROVIDING THE BEST ESCORT SERVICES IN UAE WITH VARIOUS OFFERS AND WITH MULTIPLE
CHOICES.we have the best call girls providing the best intimate services according to your demand with full satisfactrory
results.we provide all types of services according to our valued clients wishlist. our call girls in UAE are few of
the Best Call Girls in Dubai, ajman, Abu Dhabi, sharjah, fujairah, al ain and ras al khaima.
we are very proud of our call girls in UAE, they are very professional call girls who are very cooperative
and are very good at listening and understanding the need and intimate requirements of the clients of call girls
in UAE. these girls are some of the best looking call girls with figure like angels.
https://dubaicallgirls69.com/indian-pakistani-call-girls-in-dubai-escort-services-providers
TOP 10 best escort service providers in dubai