[Makavali]

i have this one query to do in database and i could not figure out how to do that, first of all the question is The databasemust have the ability of producing (on demand) reports on current sales figures, such reports shell provide valuable statistical information on the number of items sold for each product (up to a period of one year). that was the questions and i need to find out the sales figures and the tables i have are CUSTOMER, ORDER, EMPLOYEES, PRODUCTS, SUPPLIERS, there are the tables and what formula or methods do i need to use in query to get the sales figures

Cheers

I hope u all will try ur best to solve this matter