ESERCIZIO Aumentare del 10% il networth dei produttori che hanno prodotto almeno 10 film in bianco e nero Movie(title,year,length,inColor,studioName,producerC#) StarsIn(movieTitle,movieYear,starName) MovieStar(name,address,gender,birthdate) MovieExec(name,address,cert#,netWorth) Studio(name,address,presC#) UPDATE MovieExec set netWorth=netWorth*1.1 WHERE cert# in (select producerC# from Movie where inColor=false Group by producerC# Having count(*)>=10)
{}