Requirements:

, a supermarket chain has several divisions, to design and create the database (), save the information related to the supermarket, include: basic information of each branch of supermarket commodity information, sales information and so on, every day to set the table integrity constraints

(such as primary keys, foreign keys, etc.), enter the above information,

2, create () function, according to the years, supermarket number, article number to calculate the total amount of the goods in the supermarket sales for the month,

3, create a stored procedure (), based on the input monthly statistics monthly sales in the top five products and sales quantity, 4, create a stored procedure (), based on the input monthly statistics in the top 5% of sales amount that the supermarket information, total amount and sales (hint: you can create a temporary table to store intermediate data, use the delete)