joins Week 6 Data Base IET MyWall get first parent with a value Lisber-SQL-Example(CASE) SQL_Joins_RankingFunctions NOT NULL field from SELECT INTO hi Find effective count of employees within date range for each calendar week Stored Procedure