I am running through a problem here, I have the following information, say we have a shop with the following information:
We have a table in the database with all the ads we have and all the customers in another table.
In June we do (select count(*) from TableAds) and (select count(*) from Customers where signupdate between 'june' and 'june'):
We averaged a 1.5% (300/20000)
In July we decided to add more Ads (select count(*) from TableAds) and (select count(*) from Customers where signupdate between 'july' and 'july'):
We averaged a 1.3% (400/30,000)
On the 7th of August we decided to add more ads, so for August what would we have? I can't do the count(*) from TableAds because for the month of august, we had a different count of ads from the beginning of the month till the 7th.
How would I list the month of august? also.. what if I want all these 3 months in one report, how should I be writing my query?
View Complete Post