Closed angel96 closed 5 years ago
Enlace al documento para modificar las querys, su descripcion y mostrar lo que obtiene por consola
https://docs.google.com/document/d/15Mqhp6BJAuUgEZXntdCoP86M8uL3Srf0IogTgL-XW-A/edit#
Documento de Drive actualizado: Solo faltan cuatro queries y algunas descripciones.
Aqui va la query mia de el ratio de tareas pendientes o en progreso
select (select count(a) from Application a where a.status = 'in progress')*1.0/count(ap) from Application ap;
Media, minimo, maximo, Desviacion estandar de fixuptask por Customer
select avg (c.fixUpTask.size), min(c.fixUpTask.size), max(c.fixUpTask.size), stddev(c.fixUpTask.size) from Customer c;
select c from Customer c order by c.complaint.size DESC;
select f from Customer f join f.fixUpTask t where f.fixUpTask.size > (select avg(f.fixUpTask.size)+(avg(f.fixUpTask.size)/10)*1.0 from Customer f) order by t.application.size;
Select messages por Box y User: select b.message from Box b join b.message m where m.receiver = ?1 and b.name = ?2;
select a from Actor where a.id = ?1;