MappingAssertion (Head (teamScore(X,Y),Team(X)),Map (ObjMap (X,tm(teams.ID_TEAM )) ValueMap (Y,xs:int,SUM( RACESRESULTS.POINTS )) ),Body ( SELECT teams.ID_TEAM, SUM( racesresults.POINTS ) AS TEAMTOTALPOINTS FROM racesresults, races, drivesFor, teams WHERE racesresults.ID_RACE = races.ID_RACE AND racesresults.ID_DRIVER = drivesFor.ID_DRIVER AND drivesFor.ID_TEAM = teams.ID_TEAM AND YEAR( races.DATE ) =2007 AND drivesFor.YEAR =2007 GROUP BY teams.ID_TEAM ))
Comment("pippo")
MappingAssertion (Head (Team(Y),partOfTeam(X,Y),Person(X)),Map (ObjMap (X,emp(worksfor.ID_EMP )) ObjMap (Y,tm(worksfor.ID_TEAM )) ),Body (SELECT worksfor.ID_EMP, worksfor.ID_TEAM FROM worksfor WHERE worksfor.YEAR = 2007 ))
