MySQL 5.6

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

CREATE TABLE LOGGINGS (id INT, email VARCHAR(10), code INT, created_at TIMESTAMP);
INSERT INTO LOGGINGS VALUES(1, 'a@y.de', 100, '2019-10-21 10:00:01'),
                           (2, 'b@y.de', 100, '2019-10-21 10:00:02'),
                           (3, 'c@y.de', 101, '2019-10-21 10:01:03'),
                           (4, 'd@y.de', 102, '2019-10-21 11:01:03'),
                           (5, 'a@y.de', 100, '2019-10-21 12:01:03'),
                           (6, 'b@y.de', 103, '2019-10-21 12:01:03'),
                           (7, 'e@y.de', 106, '2019-10-21 15:01:04'),
                           (8, 'f@y.de', 108, '2019-10-21 16:01:03'),
                           (9, 'g@y.de', 109, '2019-10-21 17:01:03');
SELECT * FROM LOGGINGS


id
email
code
created_at


1
a@y.de
100
2019-10-21 10:00:01

2
b@y.de
100
2019-10-21 10:00:02

3
c@y.de
101
2019-10-21 10:01:03

4
d@y.de
102
2019-10-21 11:01:03

5
a@y.de
100
2019-10-21 12:01:03

6
b@y.de
103
2019-10-21 12:01:03

7
e@y.de
106
2019-10-21 15:01:04

8
f@y.de
108
2019-10-21 16:01:03

9
g@y.de
109
2019-10-21 17:01:03


SELECT
  GROUP_CONCAT(DISTINCT
    CONCAT(
      'count(case when code = ',
      code,
      ' then created_at else null end) AS ''',
      code, ''''
    )
  ) INTO @sql
FROM LOGGINGS;

SET @sql = CONCAT('SELECT date(created_at), ', @sql, '
                   FROM LOGGINGS 
                   GROUP BY date(created_at)');
PREPARE stmt FROM @sql;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;


date(created_at)
100
101
102
103
106
108
109


2019-10-21
3
1
1
1
1
1
1

id	email	code	created_at
1	a@y.de	100	2019-10-21 10:00:01
2	b@y.de	100	2019-10-21 10:00:02
3	c@y.de	101	2019-10-21 10:01:03
4	d@y.de	102	2019-10-21 11:01:03
5	a@y.de	100	2019-10-21 12:01:03
6	b@y.de	103	2019-10-21 12:01:03
7	e@y.de	106	2019-10-21 15:01:04
8	f@y.de	108	2019-10-21 16:01:03
9	g@y.de	109	2019-10-21 17:01:03