create view V_ORGANIZATION_SUMMARY
  (Country_name, organization_name, ORGANIZATION_code)
as 
SELECT ctry.NAME, org.NAME, org.code 
 FROM ORGANIZATION org
  JOIN COUNTRY_ORGANIZATION co
   ON co.ORGANIZATION_CODE = org.CODE 
  JOIN COUNTRY ctry 
   ON co.COUNTRY_CODE = ctry.CODE 
ORDER BY ctry.NAME;
