Task: Text to Code
Input (English): Step 1: find the average Revenue in Manufacturers table.
Step 2: For each row in Manufacturers table, find the corresponding rows in Products table.
Step 3: find Products's Name in the results of step 2 whose Revenue greater than the results of step 1
Output (English): SELECT T2.Name FROM Manufacturers AS T1 JOIN Products AS T2 ON T1.Code = T2.Manufacturer WHERE T1.Revenue > ( SELECT Avg ( T1.Revenue ) FROM Manufacturers AS T1 )