This advanced SQL exercise is part of the book: Advanced SQL – Practical Techniques and Use-Cases, which includes 100 day-to-day SQL challenges (and solutions), need-to-know advanced features, and key concepts.
Given the following tables:
Employees table –
CREATE TABLE employees (employeeID int identity(1,1), employeeName varchar(25)) GO
Rates table – for example, on January 2016 the hourly rate of employee no. 1 was 28 ILS:
CREATE TABLE hourlyRates (employeeID int, rate int, rateDate date)
Employees attendance table –
CREATE TABLE workingHours (employeeID int, startdate datetime, enddate datetime) GO