### Instruction: CREATE TABLE EmployeeAttendanceLogs ( EmpAttendanceLogId INT, AttendanceDate DATE, DayName NVARCHAR, EmployeeId INT, AttendanceRuleId INT, ShiftId INT, ShiftName NVARCHAR, MinHrForFullDay INT, MinHrForHalfDay INT, IsNightShift BIT, ShiftEndTime_Minutes_NightShift INT, ShiftStartDateTime DATETIME, ShiftEndDateTime DATETIME, ShiftStartTime DATETIME, ShiftEndTime DATETIME, ShiftDurationSeconds INT, BeforePunchTime DATETIME, AfterPunchTime DATETIME, CalculatedBeforePunchTime DATETIME, CalculatedAfterPunchTime DATETIME, WeekNo INT, PunchDate DATE, PunchInTime DATETIME, PunchInSource NVARCHAR, PunchOutTime DATETIME, PunchOutSource NVARCHAR, FirstHalf DATETIME, SecondHalf DATETIME, Duration INT, LateBy INT, EarlyBy INT, IsRelaxsation_Benifit BIT, Relaxsation_BenifitType NVARCHAR, RelaxsationGraceTime INT, Relaxsation_No_Instances INT, RelaxsationStatus NVARCHAR, IsShortLeave_Benifit BIT, PermissibleGraceTime INT, Relaxsation_Deduct_NoOfDays INT, Relaxsation_Deduct_LeaveTypeId INT, ShortLeave_No_Instance INT, ShortLeaveGraceTime INT, IsOnLeave BIT, FH_Leave NVARCHAR, FH_LeaveDuration INT, SH_Leave NVARCHAR, SH_LeaveDuration INT, FH_OD NVARCHAR, FH_ODAmount INT, SH_OD NVARCHAR, SH_ODAmount INT, AttendanceAmount INT, FinalAttendanceAmount INT, IsWeeklyOff BIT, IsHoliday BIT, IsLateComing BIT, IsEarlyGoing BIT, IsLateComingAndEarlyGoing BIT, IsShortLeave BIT, CompOff INT, PunchRecords NVARCHAR, Status NVARCHAR, Remarks NVARCHAR, OverTime INT, IsApplicableForOverTime BIT, OverTimeAfterShiftHour INT, CalculatedOverTime INT, IsAutoAttendance BIT, PunchInStatus NVARCHAR, MissedPunchIn_Bulk NVARCHAR, PunchOutStatus NVARCHAR, MissedPunchOut_Bulk NVARCHAR, PunchIn_Bulk NVARCHAR, PunchOut_Bulk NVARCHAR, IsOnCompOff BIT, IsPartialDay BIT, IsAttendanceLocked BIT, AttendanceLockDate DATETIME, RowNo INT, IsLeaveDeducted BIT, RealaxationOrder INT, FinalStatus NVARCHAR, IsMasterShift BIT, CompOffAmount INT, SpentTimeCalculation NVARCHAR, ShiftBreakStartDateTime DATETIME, ShiftBreakEndDateTime DATETIME, IsSplitShift BIT, SplitShiftDateTime DATETIME, PunchFirstHalfOutTime DATETIME,PunchSecondHalfInTime DATETIME
)'' CREATE TABLE Employee (EmployeeId INT, UserId INT, ApplicationId INT, RoleId INT, ShiftId INT, UserName NVARCHAR, EmpCode NVARCHAR, FirstName NVARCHAR, LastName NVARCHAR, MiddleName NVARCHAR, FatherName NVARCHAR, ImageFilePath NVARCHAR, Phone NVARCHAR, CellPhone NVARCHAR, IsMobileNumberPublic BIT, OfficePhone NVARCHAR, Extension NVARCHAR, Email NVARCHAR, IsEmailIdPublic BIT, AlternateEmailId NVARCHAR, QuitDate DATETIME, DepartmentId INT, CompanyID INT, BranchID INT, DesignationId INT, ReligionId INT, NationalityId INT, BloodTypeId INT, BloodType NVARCHAR, MaritalStatusId INT, PlaceOfBirth NVARCHAR, BirthDate DATETIME, JoiningDate DATETIME, Gender NVARCHAR, HousePhone NVARCHAR, IsLeavedJob BIT, LeaveJobDate DATETIME, LeaveJobReason NVARCHAR, TaxID NVARCHAR, SocialSecurityNo NVARCHAR, Status INT, ReportingToEmpId INT, CreatedOn DATETIME, UpdatedBy INT, CreatedBy INT, UpdatedOn DATETIME, EmpStatusId INT, ReportingToHrId INT, EmployeeStatus NVARCHAR, title NVARCHAR, PFNo NVARCHAR, ESINo NVARCHAR, SeriesTypeID INT, EmpCodeValue NVARCHAR, IsEmployeeExit BIT, IsfullFinalsettelement BIT, ExitDate DATETIME, RepotingToEMPCode NVARCHAR, CTC DECIMAL, CreatedMachineIP NVARCHAR, UpdatedMachineIP NVARCHAR, IsTDSapplicable BIT, GrossPay DECIMAL, IsExcludePayroll BIT, ReportingToFunctionalManager INT, SubDepartmentId INT, Sub_SubDepartmentId INT, WorkerType INT, EmployeeGrade INT, EmpExitType NVARCHAR, JobLevelId INT, PayTypeId INT, ClientId INT) --Using valid MS SQL Server, answer the following questions for the tables provided above. -- Pls help me with todays employee who are absent 
### Response:  select count(*)as EmployeeCount FROM [dbo].[EmployeeAttendanceLogs] inner join employee e on e.EmployeeId=[EmployeeAttendanceLogs].EmployeeId where FinalStatus like  'A-A' and convert(date,AttendanceDate,101)=convert(date,getdate(),101)