For open project in the MSSQL :
You can setup AdventureWorks.bak and TSQL.bak files to your database with run setup.cmd (Starter > setup.cmd)
Open project to Mssql solution explorer(Starter > Project > run Project.ssmssln)
Make writable.
After that you can try yourself.
You can find solutions in the solution folder.
JUST FOR PRACTICE :
Look into ---> MSSQL-JOINS/Starter/Project/Project/