JSFiddle - React, Tailwind, and code Playground

by booktu8

HTML

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

JavaScript

var data = [{
    dep: 'A',
    qt: 10,
    price: 5
  },
  {
    dep: 'A',
    qt: 5,
    price: 2.30
  },
  {
    dep: 'B',
    qt: 3,
    price: 2.20
  },
  {
    dep: 'C',
    qt: 1,
    price: 4
  },
  {
    dep: 'C',
    qt: 4,
    price: 10
  }
];

var res = alasql('SELECT dep, SUM(qt) AS qt, SUM(qt*price) AS amt, AGGR(amt/qt) AS price FROM ? GROUP BY dep', [data]);



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