q6

SELECT r.nom_region,MIN(bi.date_construction)
 FROM region r inner join ville v on r.code_region = v.code_region
      inner join quartier q on q.code_ville = v.code_ville
	  inner join bien_immobilier bi on bi.code_quartier = q.code_quartier
 GROUP BY R.nom_region