SQL syntax napaka

select *
from (select *
from student
where dept_name= 'Comp. Sci')
natural full outer join
(select *
from takes
where semester = 'Spring' and year = 2009);

select dept_name, avg_salary
from (select dept_name, avg(salary) as avg_salary
		from instructor
		group by dept_name)
where avg_salary > 42000;

with max_budget(value) as
	(select max(budget)
	 from department)
select budget
from department, max_budget
where department.budget = max_budget.value;

killa bee je 11. dec 2016 ob 17:56 izjavil:

A je to samo v MySQL tako ali tudi sicer?