When running npm install, don't forget to also run ./node_modules/.bin/electron-rebuild so that electron can use native Node modules. Especially a problem for sqlite3.
Also, if you run into electron-rebuild errors, make sure you are using a proper Python version. I installed Anaconda recently, and was trying to rebuild using Python 3.5 when Python 2 was necessary. Something ot keep in mind...
Selects all current holdings by alums (probably missing bequests).
SELECT * FROM holdings h
JOIN people p ON h.personID = p.personID
JOIN bequests b ON h.bequestID = b.bequestID
WHERE p.gradYear < 2019 AND h.dateStarted = (SELECT max(dateStarted) FROM holdings WHERE bequestID = h.bequestID) ORDER BY gradYear, lastname, name;
To get more help on the Angular CLI use ng help or go check out the Angular CLI README.