I'm trying to run this

SELECT nvl(INSTRUCTOR.GIVEN_NAME, ' ') GIVEN_NAME, INSTRUCTOR.FAMILY_NAME, nvl(INSTRUCTOR.DEPARTMENT,' No dept') DEPARTMENT, SECTION.CODE, SECTION.TERM, SECTION.COURSE
FROM INSTRUCTOR
JOIN SECTION ON INSTRUCTOR.ID = SECTION.INSTRUCTOR
WHERE SECTION.TERM = 083
GROUP BY INSTRUCTOR.ID
ORDER BY INSTRUCTOR.FAMILY_NAME

I know its not a group by expression, but I dont know how to get my desired results. Can someone help please?

remove the GROUP BY clause

But then it just shows my results like this
instructor Ashley
course math101

instructor Ashley
course math201

instead of...
instructor Ashley
course math101
math201

i'm quite sure that the query results do not have the instructor on one line and the course on the next line

you are obviously re-arranging the ouput in order to print it

and that's exactly where the logic belongs, to detect the same instructor and only print it once, then list the course underneath

that's not something you should attempt to do with SQL

we don't have your tables. (provide CREATE TABLE statements)
we don't have your data. (provide INSERT statements)
>I dont know how to get my desired results
we don't know exactly what are the "desired results".

so actual direct assistance is not possible, unless & until you provide more meaningful details