Write query to provide totals of Earned Premium and Earned Exposures by company and S160 coverage code.

Write query to provide totals of Earned Premium and Earned Exposures by company and S160 coverage code. Only include data for the year 2010 (1/1/2010 - 12/31/2010), company equal to GE or GG, and rated state equal to CA.

Here are the tables and fields:

Table 1a

Earned Premium = ERND_PRM_AM

Earned Exposures = ERND_EXPSR_DY_CN

S160 Coverage Code = S160_CVRG_CD

Policy Key = PLCY_KY

Table 2a

Rated State = RTD_ST_CD

Company = CMPNY_CD

Date = SNP_DT

Policy Key = PLCY_KY