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