we use phpmyadmin for this assignment

Phase 10-Joins Step 1-Write an INNER JOIN query that displays the name, occupation, university name, and tuition cost for everyone that attended Columbia University. Step 2-Write a LEFT OUTER JOIN query that displays all universities and their ali. a) Are any records from the PEOPLE table not displayed? If so, which ones? Step 3-Duplicate the query from Step 2, and simply change the LEFT OUTER JOIN to a RIGHT OUTER JOIN. Describe what changed