SQL:

Create a View (named: yourLastNameView17) that will list all Carriers and their Plans along with a column that displays the number of members in that Plan, the total number of members serviced by the Carrier and the percent of the Carriers Members that are in that Plan. Order by Carrier and Plan Description. For Example the first row in the result set (for Blue Cross Blue Shield) would display as follows: INSTRUCTOR PROVIDED HINTS:::::

it will follow this form: Select aliasName1.data, alaisName1.data, aliasName1.data, aliasName2.data, (aliasName1.data / aliasName2.data) as pct FROM (nested query 1) aliasName1 natural join (nested query 2) aliasName2 ORDER by ....; CARRIER PLAN PLANCOUNT TOTALMEMS PCT ----------------------------------- ----------------------------------- --------- --------- ------ Anthem 2-Party SuperMed 3 6 50.0 Anthem Single SuperMed 3 6 50.0 Blue Cross Blue Shield 2-Party Basic Medical 10 22 45.5 Blue Cross Blue Shield Family Basic Medical 7 22 31.8 Blue Cross Blue Shield Single Basic Medical 5 22 22.7 Nationwide Life Only 1 1 100.0 6 rows selected