How to get total row counted in different timezone in mysql

This is my sql query. It return total rows in UTC timezone. I want to count completed_date field in different timezone. like America/Los_Angeles timezone format. I heard that i need to use something GROUP or DATE function but i don't get any idea.

SELECT COUNT(*)
FROM `team_users`
WHERE (`completed_date` BETWEEN '2016-04-27 00:00:00' AND '2016-04-27 23:59:59')