SELECT s_fname
FROM (SELECT s_fname from student) as s_n
WHERE s_n like 'Youss%';

i get this error with multiple subqueries and cant get it right.
ORA-00933: SQL command not properly ended

>Solution :

Like this:

SELECT s_fname
FROM (SELECT s_fname from student) as s_n
WHERE s_fname like 'Youss%';

Or try it this way:

with (select s_fname from student) as s_n
select s_fname from s_n
where s_fname like 'Youss%';

That said, other than as an exercise, there’s no practical reason to use a subquery here. Better just to say this:

select s_fname 
from student 
where s_fname like 'Youss%';