JSFiddle - React, Tailwind, and code Playground

HTML

<script src="http://alasql.org/console/alasql.min.js"></script>
<div id="res"></div>
<script type="text/sql" id="sql">
CREATE TABLE people (
    FirstName STRING,
    LastName STRING,
    Gender STRING    
);
    
INSERT INTO people VALUES ("John","Johnson","M"),("John","Johnson","M"),("John","Johnson","M"),("John","Johnson","M"),("John","Johnson","M"),("John","Johnson","M"), ("Peter","Petersen","M"),
("Peter","Petersen","M"),
("Peter","Petersen","M"),
("Peter","Petersen","M"),("Larry","Larrison","M"),("Larry","Larrison","M"),("Larry","Larrison","M"),("Larry","Larrison","M"),("Larry","Larrison","M"),("Larry","Larrison","M"),("Larry","Larison","M");

SELECT * 
    INTO HTML("#res",{headers:true}) 
    FROM people 
    GROUP BY FirstName, LastName 
    HAVING SUM(CASE WHEN Gender = "M" THEN 1 ELSE 0 END) >= 5;

</script>

JavaScript

alasql('SOURCE "#sql"');