MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE date_range  (
  `Date` datetime
);
CREATE TABLE wp_wpdatatable_1  (
  `player` VARCHAR(5),
  `Date` DATE,
  `sporttrainingduration` FLOAT,
  `practiceheldby` VARCHAR(10)
);
INSERT INTO date_range 
VALUES
  ('2019-06-01'),
  ('2019-06-02'),
  ('2019-06-03')
  ;
INSERT INTO wp_wpdatatable_1 
VALUES
  ('AAA','2019-06-01','1','group1'),
  ('AAA','2019-06-02','2','group2'),
  ('AAA','2019-06-03','3','group3'),
  ('AAA','2019-06-04','1','gorup1'),
  ('BBB','2019-06-02','2','group2'), 
  ('CCC','2019-06-03','3','group3')
  ;
select * from date_range;
select * from wp_wpdatatable_1;


Date


2019-06-01 00:00:00

2019-06-02 00:00:00

2019-06-03 00:00:00




player
Date
sporttrainingduration
practiceheldby


AAA
2019-06-01
1
group1

AAA
2019-06-02
2
group2

AAA
2019-06-03
3
group3

AAA
2019-06-04
1
gorup1

BBB
2019-06-02
2
group2

CCC
2019-06-03
3
group3


-- 1. Create an expression that builds the columns
set @sql = (
    select group_concat(distinct
        concat(
            -- "max(case when date_range.`date`='", date_range.`Date`, "' then `practiceheldby` end) as `", date_range.`Date`, "`"
            "max(case when `date`='", date_range.`Date`, "' then `practiceheldby` end) as `", date_range.`Date`, "`"
        )
    )
    from wp_wpdatatable_1, date_range  
    -- where date_range.`Date`>=2019-06-01
              -- and date_range.`Date` <= 2019-06-07
    where date_range.`Date`>='2019-06-01'
              and date_range.`Date` <= '2019-06-07'
);
select @sql;


@sql


max(case when `date`='2019-06-01 00:00:00' then `practiceheldby` end) as `2019-06-01 00:00:00`,max(case when `date`='2019-06-02 00:00:00' then `practiceheldby` end) as `2019-06-02 00:00:00`,max(case when `date`='2019-06-03 00:00:00' then `practiceheldby` end) as `2019-06-03 00:00:00`


-- 2. Complete the SQL instruction
set @sql = concat("select `player`, ", @sql , " from wp_wpdatatable_1 group by `player`");

-- 3. Create a prepared statement
PREPARE stmt from @sql;

-- 4. Execute the prepared statement
execute stmt;
DEALLOCATE PREPARE stmt;


player
2019-06-01 00:00:00
2019-06-02 00:00:00
2019-06-03 00:00:00


AAA
group1
group2
group3

BBB
null
group2
null

CCC
null
null
group3

player	Date	sporttrainingduration	practiceheldby
AAA	2019-06-01	1	group1
AAA	2019-06-02	2	group2
AAA	2019-06-03	3	group3
AAA	2019-06-04	1	gorup1
BBB	2019-06-02	2	group2
CCC	2019-06-03	3	group3