PlanExecution - Q2d-i - Plan d'exécution de : select CRENEAU.MATC, ENSEIGNER.E...
✅ The verified answer to this question is available below. Our community-reviewed solutions help you understand the material better.
PlanExecution - Q2d-i - Plan d'exécution de :
select CRENEAU.MATC, ENSEIGNER.ENSC, sum((to_date(HEUREFC, 'HH24:MI') – to_date(CRENEAU.HEUREDC, 'HH24:MI')) * 24) from CRENEAU, ENSEIGNERwhere CRENEAU.DEBSEMC = ENSEIGNER.DEBSEMC and CRENEAU.JOURC = ENSEIGNER.JOURC and CRENEAU.HEUREDC = ENSEIGNER.HEUREDC and CRENEAU.GRPC = ENSEIGNER.GRPCgroup by CRENEAU.MATC, ENSEIGNER.ENSC ;
Recopiez ici le plan d'exécution de la requête ci-dessus.
Want instant access to all verified answers on moodle.iut-tlse3.fr?
Get Unlimited Answers To Exam Questions - Install Crowdly Extension Now!