1. Code a SELECT statement that shows all authors who live in Oakland, California and are based in the same state as one of the publishers. The SELECT list should display the following: The publisher's name and city, the author's name, city, and state. Sort columns in the same order shown in the SELECT list. 8:41