Sql help!

2. Create a table called Mylistings and populate it with the result of a view called Mylistings based on the listings data for the city of Rocklin. Your table should display non-duplicate zip code and city name information for the two zip codes of the city of Rocklin. (Hint:You l first need to create the view then the query for the table data) 3. Write a SQL statement to show all records that contain the word "Street", "Address" or the following street address abbreviations: ("Dr." or "Cir."). 4. Use the real estate database to display homes that are listed within +-3% of $517,500 (the current high-end limit for a non-jumbo loan in Great Sacramento area). Your report should only display home address, price, zip code and city data in the zip code of 95677. Hint: You're only allowed to use the simple join technique covered so far! For questions #5 & 6 below, please use the ER Diagram for the following Publisher atabase used in various lab activities. first name last name year isbn id number 5. Given the ER Diagram for the AuthorBook database, display a list of publishers who have published 100 books or more in the city of New York, Boston, and Cambridge. 6. Create the table structure for each entity shown in the ER diagram above. Since these tables already existed, you MUST delete them first. Please keep in mind that the tables are all linked together. Your answer should show printscreens of your commands deleting each table, your commands creating the tables again, and your testing data. To test your solution, please insert at least one record in each table and display the result