$3.(40$ points$)$ Design a query that presents the total number of new memberships that have been started last year $(2023)$ for each golf course in Arizona in descending order. Show the query result.

Use one or more query design templates to show the query design. In each query design template, put in table$($s$)$ and relationship$($s$)$ used in the query by showing the name of each table and the line for each relationship linking tables, and query design columns.