SQL help using Oracle Database - NOT MYSQL OR MICROSOFT SQL SERVER! Syntax matte

Question

SQL help using Oracle Database - NOT MYSQL OR MICROSOFT SQL SERVER! Syntax matters

Can someone please write the proper queries for this question? There are two parts to it.

I'm not allowed to use BEGIN/END statements (don't even know what that means he hasn't taught us that yet)

Please don't mark it as "Needs more Info" because this is all of the info I have received to do this.

Link to question if you can't see the image below: http://i.imgur.com/bv2EWYz.png

Table and database information below but I'm not sure how to include all of the data - if there is a command to show all the data fields for particular tables feel free to let me know.
Link to database information if you can't see the image below: http://i.imgur.com/VwpcPmo.png

Thank you.

Explanation / Answer

2)

This query gives second most profitable person

Related Questions

Navigate

• Browse (All)
• Browse S
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.