JSFiddle - React, Tailwind, and code Playground

HTML

<script src="http://alasql.org/console/alasql.min.js"></script>
<div id="res"></div>

JavaScript

var data=[{a:{aa:1},b:{bb:2}},{a:{aa:2},b:{bb:2}},{a:{aa:1},b:{bb:3}}]
var res = alasql('select SUM(a->aa), FIRST(b->bb) AS [b->bb] from ? group by b->bb',[data]);

document.getElementById("res").textContent = JSON.stringify(res);