JSFiddle - React, Tailwind, and code Playground
HTML
<script src="http://alasql.org/console/alasql.min.js"></script>
<span id="res"></span>JavaScript
var data = [{ Id:563,Name:"test",State:"test"},{Id:543,Name:"test2",State:"test2"}, {Id:544,Name:"test2",State:"test2"}, ];
var res = alasql('SELECT Name, State FROM ? GROUP BY Name, State',[data]);
document.getElementById("res").textContent = JSON.stringify(res);