silvdc

## project_sunroof_query.sql
SELECT
  #name of state
  state_name,

  #number of buildings in Google Map suitable for solar
  SUM(count_qualified) Google_Maps_Buildings_Avail_for_Solar,

  #percent of buildings in Google Maps covered by Project Sunroof
  ROUND(CAST(AVG(percent_covered) AS numeric), 1) Percent_GMap_Covered_by_Proj_Sunroof,
	SELECT
	#name of state
	state_name,

	#number of buildings in Google Map suitable for solar
	SUM(count_qualified) Google_Maps_Buildings_Avail_for_Solar,

	#percent of buildings in Google Maps covered by Project Sunroof
	ROUND(CAST(AVG(percent_covered) AS numeric), 1) Percent_GMap_Covered_by_Proj_Sunroof,