[Solved]Keep Getting Errors Sql Server Msg 206 Level 16 State 2 Line 249 Operand Type Clash Int In Q37033629

I keep getting these errors on SQL server

Msg 206, Level 16, State 2, Line 249
Operand type clash: int is incompatible with date
Msg 8120, Level 16, State 1, Line 367
Column ‘EMPLOYEE.EmployeeFName’ is invalid in the select listbecause it is not contained in either an aggregate function or theGROUP BY clause.
Msg 8120, Level 16, State 1, Line 373
Column ‘RENTAL_OFFICE_LOCATION.RentalOfficeID’ is invalid in theselect list because it is not contained in either an aggregatefunction or the GROUP BY clause.
Msg 8120, Level 16, State 1, Line 378
Column ‘VEHICLE.Year’ is invalid in the select list because it isnot contained in either an aggregate function or the GROUP BYclause.
Msg 8120, Level 16, State 1, Line 386
Column ‘RESERVATION.Daily_Rate’ is invalid in the select listbecause it is not contained in either an aggregate function or theGROUP BY clause.
Msg 8120, Level 16, State 1, Line 454
Column ‘RENTAL_OFFICE_LOCATION.City’ is invalid in the select listbecause it is not contained in either an aggregate function or theGROUP BY clause.
Msg 8120, Level 16, State 1, Line 470
Column ‘RESERVATION.RentalOfficeID’ is invalid in the select listbecause it is not contained in either an aggregate function or theGROUP BY clause.
Msg 8120, Level 16, State 1, Line 503
Column ‘EMPLOYEE.EmployeeID’ is invalid in the select list becauseit is not contained in either an aggregate function or the GROUP BYclause.
Msg 8120, Level 16, State 1, Line 521
Column ‘RESERVATION.Pick_Up_Date’ is invalid in the select listbecause it is not contained in either an aggregate function or theGROUP BY clause.

how do i fix them

Expert Answer

---

Answer to I keep getting these errors on SQL server Msg 206, Level 16, State 2, Line 249 Operand type clash: int is incompatible w… . . .