Extracte statistic from database

Hello every one,
someone can help me for extract statistics from database with mysql.
i want a query for listing all service by category between period.
thinks