select FirstName,Job,Salary from EmployeeDemographics as demo inner join EmployeeSalary as sal on demo.EmployeeID=sal.EmployeeID ...
It is a SQL practice repository covering basics to advanced topics. It includes exercises on SELECT statements, WHERE clauses, GROUP BY, JOINS, window functions (OVER(), PARTITION BY), ROW_NUMBER(), ...