These are technically homework but I'd like to have verified whether what I did is right or wrong, so I don't upright ask for a solution at least.
• Find the names, street address, and cities of residence of all employees who work for “First Bank Corporation” and earn more than $10,000.
• Find the IDs of all students who were taught by an instructor named Einstein; make sure there are no duplicates in the result.
The first solution assumes that you know what the ID for Physics lessons are since Einstein is the only person in this example who teaches Physics. Which is PHY-101.
The next solution assumes you know nothing about this and need to find everything. The solution is pretty long and I was wondering if there is a more efficient way of doing it.
Thanks in advance!