JSFiddle - React, Tailwind, and code Playground

by Andrey Gershun

HTML

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

JavaScript

var data = [{a:1, b:100},{a:2, b:90},{a:3, b:80},
           {a:4, b:70},{a:5, b:60},{a:6, b:50},
            {a:7, b:40},{a:8, b:30},{a:9, b:20},
            {a:10, b:10}];

var res = alasql('SELECT COUNT(*), SUM(a), AVG(a),\
    SUM(b), AVG(b) FROM ?',[data]);

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