To the Question: List the "Name" and "Salary" of the Profs who teach more than

gistfile1.txt

SELECT
  professors.`name`,
	SUM(profs.professors.`salary`) AS salary #, count(profs.students.`name`) as "student count"  
FROM
	professors,
	students
CROSS JOIN courses
WHERE
	professors.`name` = prof_name
AND students.`name` = stud_name
GROUP BY
	professors. NAME #having salary > 20000 #// avg salary( 10000 ) * 20 
HAVING
	count(profs.students.`name`) > 20