### Instruction: CREATE TABLE employeedetails (EmployeeId numeric,UserId int,UserName varchar,EmpCode varchar,title varchar,FirstName nvarchar,MiddleName nvarchar,FatherName varchar,Phone nvarchar,CellPhone nvarchar,
IsMobileNumberPublic bit,OfficePhone nvarchar,Extension varchar,Email nvarchar,IsEmailIdPublic bit,AlternateEmailId varchar,QuitDate datetime,DeptName varchar,DesignationName varchar,Religion varchar,Nationality varchar,PlaceOfBirth nvarchar,BirthDate datetime,JoiningDate datetime,Gender varchar,HousePhone nvarchar,MaritalStatusName varchar,BranchName varchar,ReportingManagerName nvarchar,EmployeeGrade int,IsEmployeeExit bit,ExitDate datetime,ReasonToLeave nvarchar,IsLeavedJob bit,SocialSecurityNo nvarchar,LeaveJobDate datetime,Status int,CreatedOn datetime,UpdatedOn datetime,PFNo nvarchar,ESINo nvarchar,CTC decimal,CreatedMachineIP varchar,UpdatedMachineIP varchar,IsTDSapplicable bit,GrossPay decimal,WorkerType int,EmpExitType nvarchar,JobLevelName varchar,companyid int,branchid int)
CREATE TABLE P_SalaryOnHold (SalaryHoldId INT, EmployeeId INT, EmpCode NVARCHAR, designationId INT, departmentId INT, Salary DECIMAL, BranchID INT, Month NVARCHAR, FinancialYear NVARCHAR, IsPaid BIT, Action NVARCHAR, PaidMonth NVARCHAR, PaidFYID INT, ReleaseMonth NVARCHAR, ReleaseFinancialYear NVARCHAR, Remark NVARCHAR, Status INT, Createdby INT, CreatedMachineIp NVARCHAR, CreatedOn DATETIME, UpdatedBy INT, UpdatedMachineIp NVARCHAR, UpdatedOn DATETIME, EffectiveTo DATETIME, EffectiveFrom DATETIME) --Using valid MS SQL Server, answer the following questions for the tables provided above. -- Tell me the total count of employees experiencing salary hold as per the month. 
### Response: SELECT COUNT(DISTINCT psh.EmployeeId) AS [Salary On Hold Count] FROM P_SalaryOnHold as psh inner join Employeedetails e ON psh.EmployeeId=e.EmployeeId WHERE EffectiveTo >= GETDATE() AND IsPaid = 0