Using SQL and Adventure Works Datawarehouse database and the code below

DELIMITER $$
CREATE PROCEDURE Create_CustomerGeography()
BEGIN
  DROP TABLE IF EXISTS CustomerGeography;
  CREATE TABLE CustomerGeography AS
  SELECT
      DimCustomer.City,
      DimGeography.EnglishCountryRegionName
  FROM
      DimCustomer
      INNER JOIN DimGeography ON DimCustomer.GeographyKey = DimGeography.GeographyKey;
END$$
DELIMITER ;

 

How do I make a log table that has log_date_time, row_count as columns and use this table to log the
above stored procedures executions