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))  

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)  

Would you like to read more?