Please help write queries from this schema

Queries:

Please help! Thanks!

try to scroll in using Google Chrome, or control + Scroll, its really hard to provide a better view as it removes integrity from the db. the db is in Postgres, but oracle will work. Thanks!

Here's a summary of the database: Products 1. What is the full name, full address, title, and phone number for all employees currently living in a US state that shares a border with the Pacific Ocean? 2. Give the same information for all employees not in the USA but are older than 50 years of age. 3. Which employees (last name, first name without repeats) have placed orders delivered to Norway? 4. What is the title and name of any employee that has sold at least two of either "Vegie-spread" or "Sir Rodney's Marmalade