HttpServer Database Example

$TABLE$

Query:



Examples

SELECT * FROM Grades
SELECT * FROM Students
SELECT Id, [First Name] || ' ' || [Last Name] As Name, date(birthday / 1000, 'unixepoch', 'localtime') As Birthday FROM Students
SELECT students.[Last Name], avg(grade) FROM students, grades WHERE students.id = grades.id GROUP BY students.[Last Name]