JSFiddle - React, Tailwind, and code Playground

HTML

<script src="https://rawgit.com/agershun/alasql/master/alasql.min.js"></script>
Query result: <div id="result"></div>

JavaScript

// Create database
var db = new alasql.Database();
db.exec('CREATE TABLE students (studentID INT, school STRING, City STRING)');

db.tables.students.data = [
       {studentID: 55, school: 'abc', City:'abc'},
       {studentID: 56, school: 'klm', City:'xyz'},
       {studentID: 57, school: 'nyz', City:'xyz'}
    ];
    
var res = db.exec("SELECT * FROM students "
  +" WHERE (studentID = 55 AND school='abc') AND (City='xyz' OR City ='abc')");

document.getElementById("result").innerHTML = JSON.stringify(res);