What should a SQL query look like?

[jaypanda]

Hello friends, I have a table named "transactions" with the structure: date...................code where it continues like this: 01.01.2017 00:05 .....33, 01.01.2017 00:16 .....35, 02.01.2017 04:55 ....36. The result I want to retrieve from the query is: code33, code 35, code36, on 01.01.2017 - 3 pieces, 5 pieces, 8 pieces, on 02.01.2017 - 1 piece, 2 pieces, 6 pieces, to generate a report within the given date range like this. How can I achieve this result in a single row?