CREATE TABLE table_7840 ("Rank" FLOAT, "Title" CLOB, "Studio" CLOB, "Director" CLOB, "Gross" CLOB)

WHAT IS THE GROSS WITH A DIRECTOR OF RICHARD TUGGLE?
SELECT "Gross" FROM table_7840 WHERE "Director" = 'richard tuggle'
SELECT "Gross" FROM "table_7840" WHERE "Director" = 'richard tuggle'