mysql database question Write a statement to create a Table

mysql database question

Write a statement to create a Table called GREAT_SALES with the same columns as the SALES table.

Write a statement to create a Table called POOR_SALES with the same columns as the SALES table.

Create a stored procedure ( P_SALES_TYPES) that creates a cursor that SELECTS SALES_PERSON, REGION and sums up SALES.   Open the cursor and iterate through the rows and INSERT a record in the GREAT_SALES table if sales are >= 10 otherwise INSERT into the POOR_SALES table

Solution

1>Write a statement to create a Table called GREAT_SALES with the same columns as the SALES table.

2>Write a statement to create a Table called POOR_SALES with the same columns as the SALES table.

3>Create a stored procedure ( P_SALES_TYPES) that creates a cursor that SELECTS SALES_PERSON, REGION and sums up SALES.   Open the cursor and iterate through the rows and INSERT a record in the GREAT_SALES table if sales are >= 10 otherwise INSERT into the POOR_SALES table.