DROP PROCEDURE IF EXISTS `sp_nba_player_statistics`;
DELIMITER //
CREATE PROCEDURE `sp_nba_player_statistics`(IN in_season varchar(10),IN in_player_name varchar(60))
main:BEGIN
 
/*
  CALL sp_nba_player_statistics ('2021','LeBron James');
*/
SELECT
  `game_full_record`.`PLAYER_NAME` AS `PLAYER_NAME`,
  STR_TO_DATE(
    CONCAT(
      DATE_FORMAT(`game_full_record`.`GAME_DATE_EST`, '%Y-%m'),
      '-01'
    ),
    '%Y-%m-%d'
  ) AS `GAME_DATE_EST`,
  AVG(`game_full_record`.`PTS`) AS `avg`,
  AVG(`game_full_record`.`REB`) AS `avg_2`,
  AVG(`game_full_record`.`AST`) AS `avg_3`
FROM
  `game_full_record`
WHERE
  `game_full_record`.`SEASON` = in_season
  and `game_full_record`.`PLAYER_NAME` = in_player_name
GROUP BY
  `game_full_record`.`PLAYER_NAME`,
  STR_TO_DATE(
    CONCAT(
      DATE_FORMAT(`game_full_record`.`GAME_DATE_EST`, '%Y-%m'),
      '-01'
    ),
    '%Y-%m-%d'
  )
ORDER BY
  `game_full_record`.`PLAYER_NAME` ASC,
  STR_TO_DATE(
    CONCAT(
      DATE_FORMAT(`game_full_record`.`GAME_DATE_EST`, '%Y-%m'),
      '-01'
    ),
    '%Y-%m-%d'
  ) ASC;

END
//
DELIMITER ;