Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- app.get("/query", (req, res) => {
- con.query(
- `SELECT (${req.query.filter}),
- count("${req.query.filter}") AS count,
- AVG(age) AS averageAge
- from census_learn_sql
- GROUP BY (${req.query.filter})
- LIMIT ${req.query.limit}`,
- (err, result, fields) => {
- err ? err : res.send(result);
- }
- );
- });
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement