Based on this diagram and tables within, what sql code would answer these questions. Would like code that would run in sql

$1.$How many subscribers do I have of each Plan type?

$2.$ What is the average number of points for our SQLPlus subscribers from Texas? $($there is info in tables so some kind of WHERE with "texas" would exceptable$)$

$**$Example problem:

Give me a table that includes the book information with the book$$s title, author name, genre, and publisher?

Code would be:

SELECT author.firstName, author.lastName $,$ count$($book$.$author$\_$id$)$

FROM author

INNER JOIN book on book.author$\_$id $=$ author.author$\_$id

GROUP BY author.author$\_$id

ORDER BY count$($book$.$author$\_$id$)$ desc;