score:0

router.get("/occ", authorization, async (req, res) => {
    try {
        console.log(req);
        const result = await pool.query(
            // "select occupation,count(occupation) from resources group by occupation;",

            "select occupation,count(occupation) as values from resources group by occupation"
        );

        console.log(req);
        console.log(result);
        res.status(200).json({
            status: "success",
            data: {
                occupationresults: result.rows, //this gets the one row we need
            },
        });
    } catch (err) {
        console.error(err.message);
    }
});

Related Query

More Query from same tag