What is the best way to fetch from a database?

Question

SQL

I want to draw statistics on the site for keywords. The statistics itself is stored in the
Date Word How ManyDayDayMet
Example:
2008-08-21 Vasya 5
2008-08-21 Petya 1
2008-08-21 Vova 2
2008-08-22 Vasya 3
2008-08-22 Petya 1
2008-08-22 Vova 1
Actually I want to write a simple rest interface that would give this data to a JS script, but here's the question. How to do it better? Is it possible to give this data somehow in json format? Or is another form of return needed? There is also a key-value, and here there is also a frequency of occurrence.
The output should just be a graph.

Answer 1

[ 
    {"date": "2008-08-21", "name": "Вася", "count": "5" },
    {"date": "2008-08-21", "name": "Петя", "count": "1" }
]

Answer 2

Select data, wrap it in JSON, send it to JS. What is the problem? Apparently, not in the courses, what is JSON?