Advertisement
Guest User

Untitled

a guest
Feb 20th, 2019
74
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.33 KB | None | 0 0
  1. app.get("/query", (req, res) => {
  2. con.query(
  3. `SELECT (${req.query.filter}),
  4. count("${req.query.filter}") AS count,
  5. AVG(age) AS averageAge
  6. from census_learn_sql
  7. GROUP BY (${req.query.filter})
  8. LIMIT ${req.query.limit}`,
  9. (err, result, fields) => {
  10. err ? err : res.send(result);
  11. }
  12. );
  13. });
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement