JSFiddle - React, Tailwind, and code Playground
HTML
<script src="http://alasql.org/console/alasql.min.js"></script>
<p>Countries:<span id="result"></span></p>JavaScript
var cities = [{city:'Kyiv',country:'Ukraine'}, {city:'Odessa', country:'Ukraine'}, {city:'Vienna', country:'Austria'}];
var res = alasql('SELECT country, COUNT(*) AS cnt FROM ? GROUP BY country ORDER BY cnt',[cities]);
document.getElementById("result").textContent = JSON.stringify(res);