Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Simple question for filtering out certain query results

User_I98FZOct 25 2022

I need to display the names of students who have submitted college applications along with a count of applications submitted. Conditions are only those in grade 8, and only those whose applications got accepted. My syntax + output looks like this:
image.png
Now I need to filter so it only shows students two or fewer acceptances. How do I do this?
Table diagram attached.
Academy_Prep.png (77.27 KB)

This post has been answered by Solomon Yakobson on Oct 25 2022
Jump to Answer
Comments
Post Details
Added on Oct 25 2022
2 comments
233 views