Your SQL expression looks fine, but you need a delimiters for Emp Name, semicolon after Designation, and a SQL keyword before the Select:
SQL Select * from Attandence where Team in('ABC','AVP','PQR');
(Is the table name spelled correctly).
If you supplied more information about the error, it would allow more accurate diagnosis. "Some error" could be just about anything...