Goods table book:
Id
The sales sales
Class_id category id
Order table text-indent:
Book_id commodity id
Time order time
Classification of goods:
Id
The name classification name
How to query each year, a month, the daily sales commodity classification? Don't know how to check the database, to personal help me ah,