@php $sql = "SELECT d.dominio as criterio, sum(ccd.valor)/count(ccd.estado) as promedio FROM dominio d INNER JOIN clase_calificacion_detalle ccd ON d.id_dominio = ccd.id_dominio_criterio INNER JOIN clase_calificacion cc USING(id_clase_calificacion) where cc.id_clase = $clase->id_clase group by 1 order by 2 desc"; $result = \Illuminate\Support\Facades\DB::select($sql); @endphp @foreach ($result as $element) @php $element = (object) $element; @endphp @endforeach
{{ $element->criterio }}
{{ number_format($element->promedio, 1, '.', '.') }}