Write SQL query to solve given problem: List the names of the directors whose films grossed over $100 million.. Keep the solution inside sql tag ```sql [SQL-Query] ```
SELECT DISTINCT T2.director FROM characters AS T1 INNER JOIN director AS T2 ON T1.movie_title = T2.name INNER JOIN movies_total_gross AS T3 ON T1.movie_title = T3.movie_title WHERE CAST(REPLACE(trim(T3.total_gross, '$'), ',', '') AS REAL) > 100000000