SQL - Nested Queries

Using the Portal dataset write a query that returnsĀ theĀ average number of individuals sampled on each plot type on a per plot basis. In other words, how many individuals are sampled on average on a plot of a given plot type. Save this query as Per plot individuals per plot type.