45. Calculating Monthly Salaries

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

To read more

Log In

Register