In subqueries containing only FROM * as the table source we can leave this statement out.
Using the query:
"show the sales of departments selling apples"
We have shortened the original query by removing the second mention of FROM SalesOverview. Click on Generate to see the transformation.