My solution to the crime and a demonstration of how to showcase SQL projects by querying a SQLite database in the browser.
https://jasonmuteham.github.io/sql-mysteries/
Edit mySQL.sql to display your own SQL. The SQL file has been edited using the vscode extension SQL Notebook https://marketplace.visualstudio.com/items?itemName=cmoog.sqlnotebook
Alternative editors with different delimiters & markdown indicator blocks will not work unless loadSQL.js is altered to accommodate.
See https://mystery.knightlab.com/ to test your own crime solving abilities!
Credits: The underlying code was adapted/inspired from here https://github.com/NUKnightLab/sql-mysteries