Describe three SQL queries to provide information to the end users for this system. At least one must be a join. These can be real SQL statements or written in English.

The database will list all Oral Chemo medications, brand name and generic, the manufacturer of the drug, the drug rep for each drug, if our pharmacy can stock the drug, if the drug is limited distribution and if so what specialty pharmacy can stock the drug.