it is possible that the fields returned from the query become column titles in a table?
Example:
/quantidade de vendas, contratos assinados no período por vendedor/
SELECT (SELECT nome FROM vendedor v WHERE v.id = A.id_vendedor) as vendedor,
DATE_FORMAT(A.data_ativacao, ‘%d/%m/%Y’) as data,
count(*) as total
FROM cliente_contrato A
WHERE A.status = ‘A’
GROUP BY 1,2 ORDER BY 1 ASC;
expected result in the table, I would like the “date” field to become the column header in the table, example:
| xxxxxxxx| 01/01/2023 | 02/01/2023 | 03/01/2023 |
vendedor1| 000000001 | 000000030 | 000000030 |
vendedor2| 000000001 | 000000030 | 000000030 |
vendedor3| 000000001 | 000000030 | 000000030 |
vendedor4| 000000001 | 000000030 | 000000030 |
vendedor5| 000000001 | 000000030 | 000000030 |