What is the gross of a comedy movie with a rating lower than 7 and starred by an actor with a net worth greater than $375,000,000.00?
comedy movie refers to Genre = 'Comedy'; rating lower than 7 refers to Rating < 7; net worth greater than $375,000,000.00 refers to NetWorth > '$375,000,000.00'
SELECT SUM(T1.Gross) FROM movie AS T1 INNER JOIN characters AS T2 ON T1.MovieID = T2.MovieID INNER JOIN actor AS T3 ON T3.ActorID = T2.ActorID WHERE CAST(REPLACE(REPLACE(T3.NetWorth, ',', ''), '$', '') AS REAL) > 375000000 AND T1.Rating < 7 AND T1.Genre = 'Comedy'
database name:db_id movie
actor table actor Cols: actor id dtype integer, Name dtype text, date of birth dtype date, birth city dtype text, birth country dtype text, height inches dtype integer, Biography dtype text, Gender dtype text, Ethnicity dtype text, NetWorth dtype text, 
movie table movie Cols: movie id dtype integer, Title dtype text, motion picture association of america rating dtype text, Budget dtype integer, Gross dtype integer, Release Date dtype text, Genre dtype text, Runtime dtype integer, Rating dtype real, rating count dtype integer, Summary dtype text, 
characters table characters Cols: movie id dtype integer, actor id dtype integer, character name dtype text, credit order dtype integer, pay dtype text, screentime dtype text, 
