const express = require('express');
const router = express.Router();
const Liana = require('forest-express');
router.post('/stats/top-5-buyers', Liana.ensureAuthenticated, async (request, response) => {
SELECT firstname || ' ' || lastname AS key, total_quantity AS value
FROM (SELECT buyerid, sum(qtysold) total_quantity
ORDER BY total_quantity desc limit 5) Q, users
ORDER BY Q.total_quantity desc
const data = await redshiftClient.query(query);
let leaderboard = data.rows;
let json = new Liana.StatSerializer({