Hi I have some tables that i would like to perform some queries on. I have a product table that is linked to an orders table. I would like to calculate the number of products sold in a particular month and also the total income generated from the sales. Can some one advise how I could do this please.
What would also be useful would be if i could see the total of products sold on a monthly basis over a period of one year.
What would also be useful would be if i could see the total of products sold on a monthly basis over a period of one year.
