Solution to Activity 10.3

The solution to this activity is as follows:

1. First, we need to develop SQL code to create the stored procedures. This will be done in a new SQL tab in Workbench.
2. Instruct MySQL to use the ms_access_migration database for all subsequent commands:

   USE ms_access_migration;

3. Drop the existing spGroupsList stored procedure if it exists:

   DROP PROCEDURE IF EXISTS  spGroupsList;

4. Set the customized delimiter:

   DELIMITER //

5. Create the spGroupsList procedure:

   CREATE PROCEDURE spGroupsList()

6. Include a BEGIN statement to indicate where the code starts:

   BEGIN

7. The SQL statement will query the database. The records will be returned from the procedure:

   SELECT DISTINCT series.Group FROM series ORDER BY series.Group;

8. End the block and delimiter:

   END//

9. Reset the delimiter back to the default:

   DELIMITER ;

10. Inside spCountryList, instruct MySQL to use the ms_access_migration database for all subsequent commands:

    USE ms_access_migration;

...