text: /*****************************************
  Course: IMT 577
  Instructor: Sean Pettersen
  IT Session: 8
  Date: 11/14/2021
  Notes: Create simple view
         Create aggregate view
  
  Steps:
      1. Create simple view
      2. Create aggregate view
  *****************************************/
  
  SELECT DISTINCT  
  		   Dim_Planets.DimPlanetID
  		  ,Dim_Characters.DimCharacterID
            ,Dim_Species.DimSpeciesID
  		  ,Stage_StarwarsPlanets.RotationPeriod
            ,Stage_StarwarsPlanets.OrbitalPeriod
            ,Stage_StarwarsPlanets.Diameter
            ,Stage_StarwarsPlanets.SurfaceWaterPct
            ,Stage_StarwarsPlanets.Population
  	FROM Stage_StarwarsPlanets
  	INNER JOIN Dim_Planets ON
  	Dim_Planets.PlanetID = Stage_StarwarsPlanets.PlanetID
  	INNER JOIN Dim_Characters ON
  	Dim_Characters.Homeworld = Stage_StarwarsPlanets.PlanetName 
      LEFT OUTER JOIN Dim_Species ON
  	Dim_Species.Homeworld = Stage_StarwarsPlanets.PlanetName 
      --ORDER BY Dim_Characters.DimCharacterID