
--
-- Final view structure for view `V_STUDENT_MARK_SEQ21_54`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ21_54`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ21_54` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '21') and (`eval`.`sequence_id` = '54')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ21_55`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ21_55`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ21_55` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '21') and (`eval`.`sequence_id` = '55')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ23_46`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ23_46`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ23_46` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '23') and (`eval`.`sequence_id` = '46')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ23_47`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ23_47`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ23_47` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '23') and (`eval`.`sequence_id` = '47')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ23_51`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ23_51`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ23_51` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '23') and (`eval`.`sequence_id` = '51')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ23_53`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ23_53`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ23_53` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '23') and (`eval`.`sequence_id` = '53')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ23_54`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ23_54`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ23_54` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '23') and (`eval`.`sequence_id` = '54')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ23_55`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ23_55`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ23_55` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '23') and (`eval`.`sequence_id` = '55')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ24_46`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ24_46`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ24_46` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '24') and (`eval`.`sequence_id` = '46')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ24_47`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ24_47`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ24_47` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '24') and (`eval`.`sequence_id` = '47')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ24_51`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ24_51`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ24_51` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '24') and (`eval`.`sequence_id` = '51')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ24_53`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ24_53`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ24_53` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '24') and (`eval`.`sequence_id` = '53')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ24_54`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ24_54`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ24_54` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '24') and (`eval`.`sequence_id` = '54')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ24_55`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ24_55`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ24_55` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '24') and (`eval`.`sequence_id` = '55')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ25_46`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ25_46`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ25_46` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '25') and (`eval`.`sequence_id` = '46')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ25_47`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ25_47`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ25_47` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '25') and (`eval`.`sequence_id` = '47')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ25_51`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ25_51`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ25_51` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '25') and (`eval`.`sequence_id` = '51')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ25_53`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ25_53`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ25_53` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '25') and (`eval`.`sequence_id` = '53')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ25_54`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ25_54`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ25_54` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '25') and (`eval`.`sequence_id` = '54')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ25_55`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ25_55`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ25_55` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '25') and (`eval`.`sequence_id` = '55')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ26_46`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ26_46`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ26_46` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '26') and (`eval`.`sequence_id` = '46')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ26_47`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ26_47`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ26_47` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '26') and (`eval`.`sequence_id` = '47')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ26_51`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ26_51`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ26_51` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '26') and (`eval`.`sequence_id` = '51')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ26_53`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ26_53`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ26_53` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '26') and (`eval`.`sequence_id` = '53')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ26_54`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ26_54`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ26_54` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '26') and (`eval`.`sequence_id` = '54')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ26_55`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ26_55`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ26_55` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '26') and (`eval`.`sequence_id` = '55')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ27_46`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ27_46`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ27_46` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '27') and (`eval`.`sequence_id` = '46')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ27_47`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ27_47`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ27_47` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '27') and (`eval`.`sequence_id` = '47')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ27_51`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ27_51`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ27_51` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '27') and (`eval`.`sequence_id` = '51')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ27_53`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ27_53`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ27_53` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '27') and (`eval`.`sequence_id` = '53')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ27_54`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ27_54`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ27_54` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '27') and (`eval`.`sequence_id` = '54')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ27_55`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ27_55`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ27_55` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '27') and (`eval`.`sequence_id` = '55')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ28_46`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ28_46`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ28_46` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '28') and (`eval`.`sequence_id` = '46')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ28_47`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ28_47`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ28_47` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '28') and (`eval`.`sequence_id` = '47')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ28_51`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ28_51`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ28_51` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '28') and (`eval`.`sequence_id` = '51')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ28_53`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ28_53`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ28_53` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '28') and (`eval`.`sequence_id` = '53')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ28_54`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ28_54`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ28_54` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '28') and (`eval`.`sequence_id` = '54')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ28_55`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ28_55`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ28_55` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '28') and (`eval`.`sequence_id` = '55')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ29_46`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ29_46`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ29_46` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '29') and (`eval`.`sequence_id` = '46')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ29_47`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ29_47`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ29_47` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '29') and (`eval`.`sequence_id` = '47')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ29_51`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ29_51`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ29_51` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '29') and (`eval`.`sequence_id` = '51')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ29_53`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ29_53`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ29_53` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '29') and (`eval`.`sequence_id` = '53')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ29_54`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ29_54`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ29_54` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '29') and (`eval`.`sequence_id` = '54')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ29_55`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ29_55`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ29_55` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '29') and (`eval`.`sequence_id` = '55')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ2_46`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ2_46`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ2_46` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '2') and (`eval`.`sequence_id` = '46')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ2_47`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ2_47`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ2_47` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '2') and (`eval`.`sequence_id` = '47')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ2_51`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ2_51`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ2_51` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '2') and (`eval`.`sequence_id` = '51')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ2_53`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ2_53`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ2_53` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '2') and (`eval`.`sequence_id` = '53')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ2_54`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ2_54`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ2_54` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '2') and (`eval`.`sequence_id` = '54')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ2_55`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ2_55`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ2_55` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '2') and (`eval`.`sequence_id` = '55')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ30_46`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ30_46`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ30_46` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '30') and (`eval`.`sequence_id` = '46')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ30_47`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ30_47`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ30_47` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '30') and (`eval`.`sequence_id` = '47')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ30_51`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ30_51`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ30_51` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '30') and (`eval`.`sequence_id` = '51')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ30_53`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ30_53`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ30_53` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '30') and (`eval`.`sequence_id` = '53')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ30_54`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ30_54`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ30_54` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '30') and (`eval`.`sequence_id` = '54')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ30_55`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ30_55`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ30_55` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '30') and (`eval`.`sequence_id` = '55')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ3_46`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ3_46`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ3_46` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '3') and (`eval`.`sequence_id` = '46')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ3_47`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ3_47`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ3_47` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '3') and (`eval`.`sequence_id` = '47')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ3_51`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ3_51`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ3_51` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '3') and (`eval`.`sequence_id` = '51')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ3_53`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ3_53`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ3_53` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '3') and (`eval`.`sequence_id` = '53')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ3_54`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ3_54`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ3_54` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '3') and (`eval`.`sequence_id` = '54')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ3_55`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ3_55`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ3_55` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '3') and (`eval`.`sequence_id` = '55')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ4_46`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ4_46`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ4_46` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '4') and (`eval`.`sequence_id` = '46')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ4_47`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ4_47`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ4_47` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '4') and (`eval`.`sequence_id` = '47')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ4_51`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ4_51`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ4_51` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '4') and (`eval`.`sequence_id` = '51')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ4_53`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ4_53`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ4_53` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '4') and (`eval`.`sequence_id` = '53')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ4_54`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ4_54`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ4_54` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '4') and (`eval`.`sequence_id` = '54')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ4_55`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ4_55`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ4_55` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '4') and (`eval`.`sequence_id` = '55')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ5_46`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ5_46`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ5_46` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '5') and (`eval`.`sequence_id` = '46')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ5_47`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ5_47`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ5_47` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '5') and (`eval`.`sequence_id` = '47')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ5_51`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ5_51`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ5_51` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '5') and (`eval`.`sequence_id` = '51')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ5_53`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ5_53`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ5_53` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '5') and (`eval`.`sequence_id` = '53')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ5_54`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ5_54`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ5_54` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '5') and (`eval`.`sequence_id` = '54')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ5_55`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ5_55`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ5_55` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '5') and (`eval`.`sequence_id` = '55')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ6_46`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ6_46`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ6_46` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '6') and (`eval`.`sequence_id` = '46')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ6_47`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ6_47`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ6_47` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '6') and (`eval`.`sequence_id` = '47')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ6_49`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ6_49`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ6_49` AS select distinct `eval`.`id` AS `eval`,`crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`room`.`id` AS `room`,`std`.`id` AS `std`,`teach`.`full_name` AS `teacher`,`modu`.`id` AS `module`,`m`.`value` AS `value`,`m`.`weight` AS `weight` from (((((((((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `attribution` `att` on(((`att`.`course_id` = `crs`.`id`) and (`att`.`year_id` = '8')))) join `user` `teach` on((`att`.`teacher_id` = `teach`.`id`))) join `module` `modu` on((`modu`.`id` = `crs`.`module_id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) left join `abscence_sheet` `sheet` on(((`seq`.`id` = `sheet`.`sequence_id`) and (`sheet`.`class_room_id` = `room`.`id`)))) left join `abscence` `abs` on((`sheet`.`id` = `abs`.`abscence_sheet_id`))) join `quater` `quat` on((`seq`.`quater_id` = `quat`.`id`))) where ((`room`.`id` = '6') and (`eval`.`sequence_id` = '49')) order by `room`.`id`,`modu`.`id`,`std` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ6_51`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ6_51`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ6_51` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '6') and (`eval`.`sequence_id` = '51')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ6_53`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ6_53`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ6_53` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '6') and (`eval`.`sequence_id` = '53')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ6_54`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ6_54`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ6_54` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '6') and (`eval`.`sequence_id` = '54')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ6_55`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ6_55`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ6_55` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '6') and (`eval`.`sequence_id` = '55')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ7_46`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ7_46`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ7_46` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '7') and (`eval`.`sequence_id` = '46')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ7_47`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ7_47`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ7_47` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '7') and (`eval`.`sequence_id` = '47')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ7_51`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ7_51`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ7_51` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '7') and (`eval`.`sequence_id` = '51')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ7_53`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ7_53`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ7_53` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '7') and (`eval`.`sequence_id` = '53')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ7_54`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ7_54`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ7_54` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '7') and (`eval`.`sequence_id` = '54')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ7_55`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ7_55`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ7_55` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '7') and (`eval`.`sequence_id` = '55')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ8_46`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ8_46`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ8_46` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '8') and (`eval`.`sequence_id` = '46')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ8_47`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ8_47`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ8_47` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '8') and (`eval`.`sequence_id` = '47')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ8_51`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ8_51`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ8_51` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '8') and (`eval`.`sequence_id` = '51')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ8_53`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ8_53`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ8_53` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '8') and (`eval`.`sequence_id` = '53')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ8_54`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ8_54`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ8_54` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '8') and (`eval`.`sequence_id` = '54')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ8_55`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ8_55`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ8_55` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '8') and (`eval`.`sequence_id` = '55')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ9_46`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ9_46`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ9_46` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '9') and (`eval`.`sequence_id` = '46')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ9_47`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ9_47`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ9_47` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '9') and (`eval`.`sequence_id` = '47')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ9_51`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ9_51`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ9_51` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '9') and (`eval`.`sequence_id` = '51')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ9_53`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ9_53`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ9_53` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '9') and (`eval`.`sequence_id` = '53')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ9_54`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ9_54`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ9_54` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '9') and (`eval`.`sequence_id` = '54')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ9_55`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ9_55`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ9_55` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '9') and (`eval`.`sequence_id` = '55')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_YEAR10_8`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_YEAR10_8`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_YEAR10_8` AS select distinct `user`.`full_name` AS `full_name`,`course`.`wording` AS `wording`,`qt1`.`std` AS `std`,`qt1`.`crs` AS `crs`,`qt1`.`coef` AS `coef`,`qt1`.`value` AS `value1`,`qt1`.`weight` AS `weight1`,`qt2`.`value` AS `value2`,`qt2`.`weight` AS `weight2`,`qt3`.`value` AS `value3`,`qt3`.`weight` AS `weight3`,((((coalesce(`qt1`.`value`,0) * coalesce(`qt1`.`weight`,0)) + (coalesce(`qt2`.`value`,0) * coalesce(`qt2`.`weight`,0))) + (coalesce(`qt3`.`value`,0) * coalesce(`qt3`.`weight`,0))) / nullif(((coalesce(`qt1`.`weight`,0) + coalesce(`qt2`.`weight`,0)) + coalesce(`qt3`.`weight`,0)),0)) AS `value`,greatest(coalesce(`qt1`.`weight`,0),coalesce(`qt2`.`weight`,0),coalesce(`qt3`.`weight`,0)) AS `weight`,(((coalesce(`qt1`.`mini`,0) + coalesce(`qt2`.`mini`,0)) + coalesce(`qt3`.`mini`,0)) / 3) AS `mini`,(((coalesce(`qt1`.`maxi`,0) + coalesce(`qt2`.`maxi`,0)) + coalesce(`qt3`.`maxi`,0)) / 3) AS `maxi`,rank() OVER (PARTITION BY `course`.`id` ORDER BY ((((coalesce(`qt1`.`value`,0) * coalesce(`qt1`.`weight`,0)) + (coalesce(`qt2`.`value`,0) * coalesce(`qt2`.`weight`,0))) + (coalesce(`qt3`.`value`,0) * coalesce(`qt3`.`weight`,0))) / nullif(((coalesce(`qt1`.`weight`,0) + coalesce(`qt2`.`weight`,0)) + coalesce(`qt3`.`weight`,0)),0)) desc )  AS `rank` from (((((`course` join `attribution` `att` on(((`att`.`course_id` = `course`.`id`) and (`att`.`year_id` = 8)))) join `user` on((`user`.`id` = `att`.`teacher_id`))) join `V_STUDENT_MARK_QUATER10_23` `qt1` on((`course`.`id` = `qt1`.`crs`))) left join `V_STUDENT_MARK_QUATER10_24` `qt2` on(((`qt1`.`std` = `qt2`.`std`) and (`qt1`.`crs` = `qt2`.`crs`)))) left join `V_STUDENT_MARK_QUATER10_26` `qt3` on(((`qt1`.`std` = `qt3`.`std`) and (`qt1`.`crs` = `qt3`.`crs`)))) order by `qt1`.`std` */;

--
-- Final view structure for view `V_STUDENT_MARK_YEAR12_8`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_YEAR12_8`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_YEAR12_8` AS select distinct `user`.`full_name` AS `full_name`,`course`.`wording` AS `wording`,`qt1`.`std` AS `std`,`qt1`.`crs` AS `crs`,`qt1`.`coef` AS `coef`,`qt1`.`value` AS `value1`,`qt1`.`weight` AS `weight1`,`qt2`.`value` AS `value2`,`qt2`.`weight` AS `weight2`,`qt3`.`value` AS `value3`,`qt3`.`weight` AS `weight3`,((((coalesce(`qt1`.`value`,0) * coalesce(`qt1`.`weight`,0)) + (coalesce(`qt2`.`value`,0) * coalesce(`qt2`.`weight`,0))) + (coalesce(`qt3`.`value`,0) * coalesce(`qt3`.`weight`,0))) / nullif(((coalesce(`qt1`.`weight`,0) + coalesce(`qt2`.`weight`,0)) + coalesce(`qt3`.`weight`,0)),0)) AS `value`,greatest(coalesce(`qt1`.`weight`,0),coalesce(`qt2`.`weight`,0),coalesce(`qt3`.`weight`,0)) AS `weight`,(((coalesce(`qt1`.`mini`,0) + coalesce(`qt2`.`mini`,0)) + coalesce(`qt3`.`mini`,0)) / 3) AS `mini`,(((coalesce(`qt1`.`maxi`,0) + coalesce(`qt2`.`maxi`,0)) + coalesce(`qt3`.`maxi`,0)) / 3) AS `maxi`,rank() OVER (PARTITION BY `course`.`id` ORDER BY ((((coalesce(`qt1`.`value`,0) * coalesce(`qt1`.`weight`,0)) + (coalesce(`qt2`.`value`,0) * coalesce(`qt2`.`weight`,0))) + (coalesce(`qt3`.`value`,0) * coalesce(`qt3`.`weight`,0))) / nullif(((coalesce(`qt1`.`weight`,0) + coalesce(`qt2`.`weight`,0)) + coalesce(`qt3`.`weight`,0)),0)) desc )  AS `rank` from (((((`course` join `attribution` `att` on(((`att`.`course_id` = `course`.`id`) and (`att`.`year_id` = 8)))) join `user` on((`user`.`id` = `att`.`teacher_id`))) join `V_STUDENT_MARK_QUATER12_23` `qt1` on((`course`.`id` = `qt1`.`crs`))) left join `V_STUDENT_MARK_QUATER12_24` `qt2` on(((`qt1`.`std` = `qt2`.`std`) and (`qt1`.`crs` = `qt2`.`crs`)))) left join `V_STUDENT_MARK_QUATER12_26` `qt3` on(((`qt1`.`std` = `qt3`.`std`) and (`qt1`.`crs` = `qt3`.`crs`)))) order by `qt1`.`std` */;

--
-- Final view structure for view `V_STUDENT_MARK_YEAR13_8`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_YEAR13_8`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_YEAR13_8` AS select distinct `user`.`full_name` AS `full_name`,`course`.`wording` AS `wording`,`qt1`.`std` AS `std`,`qt1`.`crs` AS `crs`,`qt1`.`coef` AS `coef`,`qt1`.`value` AS `value1`,`qt1`.`weight` AS `weight1`,`qt2`.`value` AS `value2`,`qt2`.`weight` AS `weight2`,`qt3`.`value` AS `value3`,`qt3`.`weight` AS `weight3`,((((coalesce(`qt1`.`value`,0) * coalesce(`qt1`.`weight`,0)) + (coalesce(`qt2`.`value`,0) * coalesce(`qt2`.`weight`,0))) + (coalesce(`qt3`.`value`,0) * coalesce(`qt3`.`weight`,0))) / nullif(((coalesce(`qt1`.`weight`,0) + coalesce(`qt2`.`weight`,0)) + coalesce(`qt3`.`weight`,0)),0)) AS `value`,greatest(coalesce(`qt1`.`weight`,0),coalesce(`qt2`.`weight`,0),coalesce(`qt3`.`weight`,0)) AS `weight`,(((coalesce(`qt1`.`mini`,0) + coalesce(`qt2`.`mini`,0)) + coalesce(`qt3`.`mini`,0)) / 3) AS `mini`,(((coalesce(`qt1`.`maxi`,0) + coalesce(`qt2`.`maxi`,0)) + coalesce(`qt3`.`maxi`,0)) / 3) AS `maxi`,rank() OVER (PARTITION BY `course`.`id` ORDER BY ((((coalesce(`qt1`.`value`,0) * coalesce(`qt1`.`weight`,0)) + (coalesce(`qt2`.`value`,0) * coalesce(`qt2`.`weight`,0))) + (coalesce(`qt3`.`value`,0) * coalesce(`qt3`.`weight`,0))) / nullif(((coalesce(`qt1`.`weight`,0) + coalesce(`qt2`.`weight`,0)) + coalesce(`qt3`.`weight`,0)),0)) desc )  AS `rank` from (((((`course` join `attribution` `att` on(((`att`.`course_id` = `course`.`id`) and (`att`.`year_id` = 8)))) join `user` on((`user`.`id` = `att`.`teacher_id`))) join `V_STUDENT_MARK_QUATER13_23` `qt1` on((`course`.`id` = `qt1`.`crs`))) left join `V_STUDENT_MARK_QUATER13_24` `qt2` on(((`qt1`.`std` = `qt2`.`std`) and (`qt1`.`crs` = `qt2`.`crs`)))) left join `V_STUDENT_MARK_QUATER13_26` `qt3` on(((`qt1`.`std` = `qt3`.`std`) and (`qt1`.`crs` = `qt3`.`crs`)))) order by `qt1`.`std` */;

--
-- Final view structure for view `V_STUDENT_MARK_YEAR14_8`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_YEAR14_8`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_YEAR14_8` AS select distinct `user`.`full_name` AS `full_name`,`course`.`wording` AS `wording`,`qt1`.`std` AS `std`,`qt1`.`crs` AS `crs`,`qt1`.`coef` AS `coef`,`qt1`.`value` AS `value1`,`qt1`.`weight` AS `weight1`,`qt2`.`value` AS `value2`,`qt2`.`weight` AS `weight2`,`qt3`.`value` AS `value3`,`qt3`.`weight` AS `weight3`,((((coalesce(`qt1`.`value`,0) * coalesce(`qt1`.`weight`,0)) + (coalesce(`qt2`.`value`,0) * coalesce(`qt2`.`weight`,0))) + (coalesce(`qt3`.`value`,0) * coalesce(`qt3`.`weight`,0))) / nullif(((coalesce(`qt1`.`weight`,0) + coalesce(`qt2`.`weight`,0)) + coalesce(`qt3`.`weight`,0)),0)) AS `value`,greatest(coalesce(`qt1`.`weight`,0),coalesce(`qt2`.`weight`,0),coalesce(`qt3`.`weight`,0)) AS `weight`,(((coalesce(`qt1`.`mini`,0) + coalesce(`qt2`.`mini`,0)) + coalesce(`qt3`.`mini`,0)) / 3) AS `mini`,(((coalesce(`qt1`.`maxi`,0) + coalesce(`qt2`.`maxi`,0)) + coalesce(`qt3`.`maxi`,0)) / 3) AS `maxi`,rank() OVER (PARTITION BY `course`.`id` ORDER BY ((((coalesce(`qt1`.`value`,0) * coalesce(`qt1`.`weight`,0)) + (coalesce(`qt2`.`value`,0) * coalesce(`qt2`.`weight`,0))) + (coalesce(`qt3`.`value`,0) * coalesce(`qt3`.`weight`,0))) / nullif(((coalesce(`qt1`.`weight`,0) + coalesce(`qt2`.`weight`,0)) + coalesce(`qt3`.`weight`,0)),0)) desc )  AS `rank` from (((((`course` join `attribution` `att` on(((`att`.`course_id` = `course`.`id`) and (`att`.`year_id` = 8)))) join `user` on((`user`.`id` = `att`.`teacher_id`))) join `V_STUDENT_MARK_QUATER14_23` `qt1` on((`course`.`id` = `qt1`.`crs`))) left join `V_STUDENT_MARK_QUATER14_24` `qt2` on(((`qt1`.`std` = `qt2`.`std`) and (`qt1`.`crs` = `qt2`.`crs`)))) left join `V_STUDENT_MARK_QUATER14_26` `qt3` on(((`qt1`.`std` = `qt3`.`std`) and (`qt1`.`crs` = `qt3`.`crs`)))) order by `qt1`.`std` */;

--
-- Final view structure for view `V_STUDENT_MARK_YEAR15_8`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_YEAR15_8`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_YEAR15_8` AS select distinct `user`.`full_name` AS `full_name`,`course`.`wording` AS `wording`,`qt1`.`std` AS `std`,`qt1`.`crs` AS `crs`,`qt1`.`coef` AS `coef`,`qt1`.`value` AS `value1`,`qt1`.`weight` AS `weight1`,`qt2`.`value` AS `value2`,`qt2`.`weight` AS `weight2`,`qt3`.`value` AS `value3`,`qt3`.`weight` AS `weight3`,((((coalesce(`qt1`.`value`,0) * coalesce(`qt1`.`weight`,0)) + (coalesce(`qt2`.`value`,0) * coalesce(`qt2`.`weight`,0))) + (coalesce(`qt3`.`value`,0) * coalesce(`qt3`.`weight`,0))) / nullif(((coalesce(`qt1`.`weight`,0) + coalesce(`qt2`.`weight`,0)) + coalesce(`qt3`.`weight`,0)),0)) AS `value`,greatest(coalesce(`qt1`.`weight`,0),coalesce(`qt2`.`weight`,0),coalesce(`qt3`.`weight`,0)) AS `weight`,(((coalesce(`qt1`.`mini`,0) + coalesce(`qt2`.`mini`,0)) + coalesce(`qt3`.`mini`,0)) / 3) AS `mini`,(((coalesce(`qt1`.`maxi`,0) + coalesce(`qt2`.`maxi`,0)) + coalesce(`qt3`.`maxi`,0)) / 3) AS `maxi`,rank() OVER (PARTITION BY `course`.`id` ORDER BY ((((coalesce(`qt1`.`value`,0) * coalesce(`qt1`.`weight`,0)) + (coalesce(`qt2`.`value`,0) * coalesce(`qt2`.`weight`,0))) + (coalesce(`qt3`.`value`,0) * coalesce(`qt3`.`weight`,0))) / nullif(((coalesce(`qt1`.`weight`,0) + coalesce(`qt2`.`weight`,0)) + coalesce(`qt3`.`weight`,0)),0)) desc )  AS `rank` from (((((`course` join `attribution` `att` on(((`att`.`course_id` = `course`.`id`) and (`att`.`year_id` = 8)))) join `user` on((`user`.`id` = `att`.`teacher_id`))) join `V_STUDENT_MARK_QUATER15_23` `qt1` on((`course`.`id` = `qt1`.`crs`))) left join `V_STUDENT_MARK_QUATER15_24` `qt2` on(((`qt1`.`std` = `qt2`.`std`) and (`qt1`.`crs` = `qt2`.`crs`)))) left join `V_STUDENT_MARK_QUATER15_26` `qt3` on(((`qt1`.`std` = `qt3`.`std`) and (`qt1`.`crs` = `qt3`.`crs`)))) order by `qt1`.`std` */;

--
-- Final view structure for view `V_STUDENT_MARK_YEAR16_8`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_YEAR16_8`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_YEAR16_8` AS select distinct `user`.`full_name` AS `full_name`,`course`.`wording` AS `wording`,`qt1`.`std` AS `std`,`qt1`.`crs` AS `crs`,`qt1`.`coef` AS `coef`,`qt1`.`value` AS `value1`,`qt1`.`weight` AS `weight1`,`qt2`.`value` AS `value2`,`qt2`.`weight` AS `weight2`,`qt3`.`value` AS `value3`,`qt3`.`weight` AS `weight3`,((((coalesce(`qt1`.`value`,0) * coalesce(`qt1`.`weight`,0)) + (coalesce(`qt2`.`value`,0) * coalesce(`qt2`.`weight`,0))) + (coalesce(`qt3`.`value`,0) * coalesce(`qt3`.`weight`,0))) / nullif(((coalesce(`qt1`.`weight`,0) + coalesce(`qt2`.`weight`,0)) + coalesce(`qt3`.`weight`,0)),0)) AS `value`,greatest(coalesce(`qt1`.`weight`,0),coalesce(`qt2`.`weight`,0),coalesce(`qt3`.`weight`,0)) AS `weight`,(((coalesce(`qt1`.`mini`,0) + coalesce(`qt2`.`mini`,0)) + coalesce(`qt3`.`mini`,0)) / 3) AS `mini`,(((coalesce(`qt1`.`maxi`,0) + coalesce(`qt2`.`maxi`,0)) + coalesce(`qt3`.`maxi`,0)) / 3) AS `maxi`,rank() OVER (PARTITION BY `course`.`id` ORDER BY ((((coalesce(`qt1`.`value`,0) * coalesce(`qt1`.`weight`,0)) + (coalesce(`qt2`.`value`,0) * coalesce(`qt2`.`weight`,0))) + (coalesce(`qt3`.`value`,0) * coalesce(`qt3`.`weight`,0))) / nullif(((coalesce(`qt1`.`weight`,0) + coalesce(`qt2`.`weight`,0)) + coalesce(`qt3`.`weight`,0)),0)) desc )  AS `rank` from (((((`course` join `attribution` `att` on(((`att`.`course_id` = `course`.`id`) and (`att`.`year_id` = 8)))) join `user` on((`user`.`id` = `att`.`teacher_id`))) join `V_STUDENT_MARK_QUATER16_23` `qt1` on((`course`.`id` = `qt1`.`crs`))) left join `V_STUDENT_MARK_QUATER16_24` `qt2` on(((`qt1`.`std` = `qt2`.`std`) and (`qt1`.`crs` = `qt2`.`crs`)))) left join `V_STUDENT_MARK_QUATER16_26` `qt3` on(((`qt1`.`std` = `qt3`.`std`) and (`qt1`.`crs` = `qt3`.`crs`)))) order by `qt1`.`std` */;

--
-- Final view structure for view `V_STUDENT_MARK_YEAR17_8`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_YEAR17_8`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_YEAR17_8` AS select distinct `user`.`full_name` AS `full_name`,`course`.`wording` AS `wording`,`qt1`.`std` AS `std`,`qt1`.`crs` AS `crs`,`qt1`.`coef` AS `coef`,`qt1`.`value` AS `value1`,`qt1`.`weight` AS `weight1`,`qt2`.`value` AS `value2`,`qt2`.`weight` AS `weight2`,`qt3`.`value` AS `value3`,`qt3`.`weight` AS `weight3`,((((coalesce(`qt1`.`value`,0) * coalesce(`qt1`.`weight`,0)) + (coalesce(`qt2`.`value`,0) * coalesce(`qt2`.`weight`,0))) + (coalesce(`qt3`.`value`,0) * coalesce(`qt3`.`weight`,0))) / nullif(((coalesce(`qt1`.`weight`,0) + coalesce(`qt2`.`weight`,0)) + coalesce(`qt3`.`weight`,0)),0)) AS `value`,greatest(coalesce(`qt1`.`weight`,0),coalesce(`qt2`.`weight`,0),coalesce(`qt3`.`weight`,0)) AS `weight`,(((coalesce(`qt1`.`mini`,0) + coalesce(`qt2`.`mini`,0)) + coalesce(`qt3`.`mini`,0)) / 3) AS `mini`,(((coalesce(`qt1`.`maxi`,0) + coalesce(`qt2`.`maxi`,0)) + coalesce(`qt3`.`maxi`,0)) / 3) AS `maxi`,rank() OVER (PARTITION BY `course`.`id` ORDER BY ((((coalesce(`qt1`.`value`,0) * coalesce(`qt1`.`weight`,0)) + (coalesce(`qt2`.`value`,0) * coalesce(`qt2`.`weight`,0))) + (coalesce(`qt3`.`value`,0) * coalesce(`qt3`.`weight`,0))) / nullif(((coalesce(`qt1`.`weight`,0) + coalesce(`qt2`.`weight`,0)) + coalesce(`qt3`.`weight`,0)),0)) desc )  AS `rank` from (((((`course` join `attribution` `att` on(((`att`.`course_id` = `course`.`id`) and (`att`.`year_id` = 8)))) join `user` on((`user`.`id` = `att`.`teacher_id`))) join `V_STUDENT_MARK_QUATER17_23` `qt1` on((`course`.`id` = `qt1`.`crs`))) left join `V_STUDENT_MARK_QUATER17_24` `qt2` on(((`qt1`.`std` = `qt2`.`std`) and (`qt1`.`crs` = `qt2`.`crs`)))) left join `V_STUDENT_MARK_QUATER17_26` `qt3` on(((`qt1`.`std` = `qt3`.`std`) and (`qt1`.`crs` = `qt3`.`crs`)))) order by `qt1`.`std` */;

--
-- Final view structure for view `V_STUDENT_MARK_YEAR18_8`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_YEAR18_8`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_YEAR18_8` AS select distinct `user`.`full_name` AS `full_name`,`course`.`wording` AS `wording`,`qt1`.`std` AS `std`,`qt1`.`crs` AS `crs`,`qt1`.`coef` AS `coef`,`qt1`.`value` AS `value1`,`qt1`.`weight` AS `weight1`,`qt2`.`value` AS `value2`,`qt2`.`weight` AS `weight2`,`qt3`.`value` AS `value3`,`qt3`.`weight` AS `weight3`,((((coalesce(`qt1`.`value`,0) * coalesce(`qt1`.`weight`,0)) + (coalesce(`qt2`.`value`,0) * coalesce(`qt2`.`weight`,0))) + (coalesce(`qt3`.`value`,0) * coalesce(`qt3`.`weight`,0))) / nullif(((coalesce(`qt1`.`weight`,0) + coalesce(`qt2`.`weight`,0)) + coalesce(`qt3`.`weight`,0)),0)) AS `value`,greatest(coalesce(`qt1`.`weight`,0),coalesce(`qt2`.`weight`,0),coalesce(`qt3`.`weight`,0)) AS `weight`,(((coalesce(`qt1`.`mini`,0) + coalesce(`qt2`.`mini`,0)) + coalesce(`qt3`.`mini`,0)) / 3) AS `mini`,(((coalesce(`qt1`.`maxi`,0) + coalesce(`qt2`.`maxi`,0)) + coalesce(`qt3`.`maxi`,0)) / 3) AS `maxi`,rank() OVER (PARTITION BY `course`.`id` ORDER BY ((((coalesce(`qt1`.`value`,0) * coalesce(`qt1`.`weight`,0)) + (coalesce(`qt2`.`value`,0) * coalesce(`qt2`.`weight`,0))) + (coalesce(`qt3`.`value`,0) * coalesce(`qt3`.`weight`,0))) / nullif(((coalesce(`qt1`.`weight`,0) + coalesce(`qt2`.`weight`,0)) + coalesce(`qt3`.`weight`,0)),0)) desc )  AS `rank` from (((((`course` join `attribution` `att` on(((`att`.`course_id` = `course`.`id`) and (`att`.`year_id` = 8)))) join `user` on((`user`.`id` = `att`.`teacher_id`))) join `V_STUDENT_MARK_QUATER18_23` `qt1` on((`course`.`id` = `qt1`.`crs`))) left join `V_STUDENT_MARK_QUATER18_24` `qt2` on(((`qt1`.`std` = `qt2`.`std`) and (`qt1`.`crs` = `qt2`.`crs`)))) left join `V_STUDENT_MARK_QUATER18_26` `qt3` on(((`qt1`.`std` = `qt3`.`std`) and (`qt1`.`crs` = `qt3`.`crs`)))) order by `qt1`.`std` */;

--
-- Final view structure for view `V_STUDENT_MARK_YEAR19_8`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_YEAR19_8`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_YEAR19_8` AS select distinct `user`.`full_name` AS `full_name`,`course`.`wording` AS `wording`,`qt1`.`std` AS `std`,`qt1`.`crs` AS `crs`,`qt1`.`coef` AS `coef`,`qt1`.`value` AS `value1`,`qt1`.`weight` AS `weight1`,`qt2`.`value` AS `value2`,`qt2`.`weight` AS `weight2`,`qt3`.`value` AS `value3`,`qt3`.`weight` AS `weight3`,((((coalesce(`qt1`.`value`,0) * coalesce(`qt1`.`weight`,0)) + (coalesce(`qt2`.`value`,0) * coalesce(`qt2`.`weight`,0))) + (coalesce(`qt3`.`value`,0) * coalesce(`qt3`.`weight`,0))) / nullif(((coalesce(`qt1`.`weight`,0) + coalesce(`qt2`.`weight`,0)) + coalesce(`qt3`.`weight`,0)),0)) AS `value`,greatest(coalesce(`qt1`.`weight`,0),coalesce(`qt2`.`weight`,0),coalesce(`qt3`.`weight`,0)) AS `weight`,(((coalesce(`qt1`.`mini`,0) + coalesce(`qt2`.`mini`,0)) + coalesce(`qt3`.`mini`,0)) / 3) AS `mini`,(((coalesce(`qt1`.`maxi`,0) + coalesce(`qt2`.`maxi`,0)) + coalesce(`qt3`.`maxi`,0)) / 3) AS `maxi`,rank() OVER (PARTITION BY `course`.`id` ORDER BY ((((coalesce(`qt1`.`value`,0) * coalesce(`qt1`.`weight`,0)) + (coalesce(`qt2`.`value`,0) * coalesce(`qt2`.`weight`,0))) + (coalesce(`qt3`.`value`,0) * coalesce(`qt3`.`weight`,0))) / nullif(((coalesce(`qt1`.`weight`,0) + coalesce(`qt2`.`weight`,0)) + coalesce(`qt3`.`weight`,0)),0)) desc )  AS `rank` from (((((`course` join `attribution` `att` on(((`att`.`course_id` = `course`.`id`) and (`att`.`year_id` = 8)))) join `user` on((`user`.`id` = `att`.`teacher_id`))) join `V_STUDENT_MARK_QUATER19_23` `qt1` on((`course`.`id` = `qt1`.`crs`))) left join `V_STUDENT_MARK_QUATER19_24` `qt2` on(((`qt1`.`std` = `qt2`.`std`) and (`qt1`.`crs` = `qt2`.`crs`)))) left join `V_STUDENT_MARK_QUATER19_26` `qt3` on(((`qt1`.`std` = `qt3`.`std`) and (`qt1`.`crs` = `qt3`.`crs`)))) order by `qt1`.`std` */;

--
-- Final view structure for view `V_STUDENT_MARK_YEAR1_8`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_YEAR1_8`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_YEAR1_8` AS select distinct `user`.`full_name` AS `full_name`,`course`.`wording` AS `wording`,`qt1`.`std` AS `std`,`qt1`.`crs` AS `crs`,`qt1`.`coef` AS `coef`,`qt1`.`value` AS `value1`,`qt1`.`weight` AS `weight1`,`qt2`.`value` AS `value2`,`qt2`.`weight` AS `weight2`,`qt3`.`value` AS `value3`,`qt3`.`weight` AS `weight3`,((((coalesce(`qt1`.`value`,0) * coalesce(`qt1`.`weight`,0)) + (coalesce(`qt2`.`value`,0) * coalesce(`qt2`.`weight`,0))) + (coalesce(`qt3`.`value`,0) * coalesce(`qt3`.`weight`,0))) / nullif(((coalesce(`qt1`.`weight`,0) + coalesce(`qt2`.`weight`,0)) + coalesce(`qt3`.`weight`,0)),0)) AS `value`,greatest(coalesce(`qt1`.`weight`,0),coalesce(`qt2`.`weight`,0),coalesce(`qt3`.`weight`,0)) AS `weight`,(((coalesce(`qt1`.`mini`,0) + coalesce(`qt2`.`mini`,0)) + coalesce(`qt3`.`mini`,0)) / 3) AS `mini`,(((coalesce(`qt1`.`maxi`,0) + coalesce(`qt2`.`maxi`,0)) + coalesce(`qt3`.`maxi`,0)) / 3) AS `maxi`,rank() OVER (PARTITION BY `course`.`id` ORDER BY ((((coalesce(`qt1`.`value`,0) * coalesce(`qt1`.`weight`,0)) + (coalesce(`qt2`.`value`,0) * coalesce(`qt2`.`weight`,0))) + (coalesce(`qt3`.`value`,0) * coalesce(`qt3`.`weight`,0))) / nullif(((coalesce(`qt1`.`weight`,0) + coalesce(`qt2`.`weight`,0)) + coalesce(`qt3`.`weight`,0)),0)) desc )  AS `rank` from (((((`course` join `attribution` `att` on(((`att`.`course_id` = `course`.`id`) and (`att`.`year_id` = 8)))) join `user` on((`user`.`id` = `att`.`teacher_id`))) join `V_STUDENT_MARK_QUATER1_23` `qt1` on((`course`.`id` = `qt1`.`crs`))) left join `V_STUDENT_MARK_QUATER1_24` `qt2` on(((`qt1`.`std` = `qt2`.`std`) and (`qt1`.`crs` = `qt2`.`crs`)))) left join `V_STUDENT_MARK_QUATER1_26` `qt3` on(((`qt1`.`std` = `qt3`.`std`) and (`qt1`.`crs` = `qt3`.`crs`)))) order by `qt1`.`std` */;

--
-- Final view structure for view `V_STUDENT_MARK_YEAR20_8`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_YEAR20_8`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_YEAR20_8` AS select distinct `user`.`full_name` AS `full_name`,`course`.`wording` AS `wording`,`qt1`.`std` AS `std`,`qt1`.`crs` AS `crs`,`qt1`.`coef` AS `coef`,`qt1`.`value` AS `value1`,`qt1`.`weight` AS `weight1`,`qt2`.`value` AS `value2`,`qt2`.`weight` AS `weight2`,`qt3`.`value` AS `value3`,`qt3`.`weight` AS `weight3`,((((coalesce(`qt1`.`value`,0) * coalesce(`qt1`.`weight`,0)) + (coalesce(`qt2`.`value`,0) * coalesce(`qt2`.`weight`,0))) + (coalesce(`qt3`.`value`,0) * coalesce(`qt3`.`weight`,0))) / nullif(((coalesce(`qt1`.`weight`,0) + coalesce(`qt2`.`weight`,0)) + coalesce(`qt3`.`weight`,0)),0)) AS `value`,greatest(coalesce(`qt1`.`weight`,0),coalesce(`qt2`.`weight`,0),coalesce(`qt3`.`weight`,0)) AS `weight`,(((coalesce(`qt1`.`mini`,0) + coalesce(`qt2`.`mini`,0)) + coalesce(`qt3`.`mini`,0)) / 3) AS `mini`,(((coalesce(`qt1`.`maxi`,0) + coalesce(`qt2`.`maxi`,0)) + coalesce(`qt3`.`maxi`,0)) / 3) AS `maxi`,rank() OVER (PARTITION BY `course`.`id` ORDER BY ((((coalesce(`qt1`.`value`,0) * coalesce(`qt1`.`weight`,0)) + (coalesce(`qt2`.`value`,0) * coalesce(`qt2`.`weight`,0))) + (coalesce(`qt3`.`value`,0) * coalesce(`qt3`.`weight`,0))) / nullif(((coalesce(`qt1`.`weight`,0) + coalesce(`qt2`.`weight`,0)) + coalesce(`qt3`.`weight`,0)),0)) desc )  AS `rank` from ((((((`course` join (select `attribution`.`course_id` AS `course_id`,max(`attribution`.`id`) AS `max_att_id` from `attribution` where (`attribution`.`year_id` = 8) group by `attribution`.`course_id`) `latest_att` on((`latest_att`.`course_id` = `course`.`id`))) join `attribution` `att` on((`att`.`id` = `latest_att`.`max_att_id`))) join `user` on((`user`.`id` = `att`.`teacher_id`))) join `V_STUDENT_MARK_QUATER20_23` `qt1` on((`course`.`id` = `qt1`.`crs`))) left join `V_STUDENT_MARK_QUATER20_24` `qt2` on(((`qt1`.`std` = `qt2`.`std`) and (`qt1`.`crs` = `qt2`.`crs`)))) left join `V_STUDENT_MARK_QUATER20_26` `qt3` on(((`qt1`.`std` = `qt3`.`std`) and (`qt1`.`crs` = `qt3`.`crs`)))) order by `qt1`.`std` */;

--
-- Final view structure for view `V_STUDENT_MARK_YEAR21_8`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_YEAR21_8`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_YEAR21_8` AS select distinct `user`.`full_name` AS `full_name`,`course`.`wording` AS `wording`,`qt1`.`std` AS `std`,`qt1`.`crs` AS `crs`,`qt1`.`coef` AS `coef`,`qt1`.`value` AS `value1`,`qt1`.`weight` AS `weight1`,`qt2`.`value` AS `value2`,`qt2`.`weight` AS `weight2`,`qt3`.`value` AS `value3`,`qt3`.`weight` AS `weight3`,((((coalesce(`qt1`.`value`,0) * coalesce(`qt1`.`weight`,0)) + (coalesce(`qt2`.`value`,0) * coalesce(`qt2`.`weight`,0))) + (coalesce(`qt3`.`value`,0) * coalesce(`qt3`.`weight`,0))) / nullif(((coalesce(`qt1`.`weight`,0) + coalesce(`qt2`.`weight`,0)) + coalesce(`qt3`.`weight`,0)),0)) AS `value`,greatest(coalesce(`qt1`.`weight`,0),coalesce(`qt2`.`weight`,0),coalesce(`qt3`.`weight`,0)) AS `weight`,(((coalesce(`qt1`.`mini`,0) + coalesce(`qt2`.`mini`,0)) + coalesce(`qt3`.`mini`,0)) / 3) AS `mini`,(((coalesce(`qt1`.`maxi`,0) + coalesce(`qt2`.`maxi`,0)) + coalesce(`qt3`.`maxi`,0)) / 3) AS `maxi`,rank() OVER (PARTITION BY `course`.`id` ORDER BY ((((coalesce(`qt1`.`value`,0) * coalesce(`qt1`.`weight`,0)) + (coalesce(`qt2`.`value`,0) * coalesce(`qt2`.`weight`,0))) + (coalesce(`qt3`.`value`,0) * coalesce(`qt3`.`weight`,0))) / nullif(((coalesce(`qt1`.`weight`,0) + coalesce(`qt2`.`weight`,0)) + coalesce(`qt3`.`weight`,0)),0)) desc )  AS `rank` from ((((((`course` join (select `attribution`.`course_id` AS `course_id`,max(`attribution`.`id`) AS `max_att_id` from `attribution` where (`attribution`.`year_id` = 8) group by `attribution`.`course_id`) `latest_att` on((`latest_att`.`course_id` = `course`.`id`))) join `attribution` `att` on((`att`.`id` = `latest_att`.`max_att_id`))) join `user` on((`user`.`id` = `att`.`teacher_id`))) join `V_STUDENT_MARK_QUATER21_23` `qt1` on((`course`.`id` = `qt1`.`crs`))) left join `V_STUDENT_MARK_QUATER21_24` `qt2` on(((`qt1`.`std` = `qt2`.`std`) and (`qt1`.`crs` = `qt2`.`crs`)))) left join `V_STUDENT_MARK_QUATER21_26` `qt3` on(((`qt1`.`std` = `qt3`.`std`) and (`qt1`.`crs` = `qt3`.`crs`)))) order by `qt1`.`std` */;

--
-- Final view structure for view `V_STUDENT_MARK_YEAR23_8`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_YEAR23_8`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_YEAR23_8` AS select distinct `user`.`full_name` AS `full_name`,`course`.`wording` AS `wording`,`qt1`.`std` AS `std`,`qt1`.`crs` AS `crs`,`qt1`.`coef` AS `coef`,`qt1`.`value` AS `value1`,`qt1`.`weight` AS `weight1`,`qt2`.`value` AS `value2`,`qt2`.`weight` AS `weight2`,`qt3`.`value` AS `value3`,`qt3`.`weight` AS `weight3`,((((coalesce(`qt1`.`value`,0) * coalesce(`qt1`.`weight`,0)) + (coalesce(`qt2`.`value`,0) * coalesce(`qt2`.`weight`,0))) + (coalesce(`qt3`.`value`,0) * coalesce(`qt3`.`weight`,0))) / nullif(((coalesce(`qt1`.`weight`,0) + coalesce(`qt2`.`weight`,0)) + coalesce(`qt3`.`weight`,0)),0)) AS `value`,greatest(coalesce(`qt1`.`weight`,0),coalesce(`qt2`.`weight`,0),coalesce(`qt3`.`weight`,0)) AS `weight`,(((coalesce(`qt1`.`mini`,0) + coalesce(`qt2`.`mini`,0)) + coalesce(`qt3`.`mini`,0)) / 3) AS `mini`,(((coalesce(`qt1`.`maxi`,0) + coalesce(`qt2`.`maxi`,0)) + coalesce(`qt3`.`maxi`,0)) / 3) AS `maxi`,rank() OVER (PARTITION BY `course`.`id` ORDER BY ((((coalesce(`qt1`.`value`,0) * coalesce(`qt1`.`weight`,0)) + (coalesce(`qt2`.`value`,0) * coalesce(`qt2`.`weight`,0))) + (coalesce(`qt3`.`value`,0) * coalesce(`qt3`.`weight`,0))) / nullif(((coalesce(`qt1`.`weight`,0) + coalesce(`qt2`.`weight`,0)) + coalesce(`qt3`.`weight`,0)),0)) desc )  AS `rank` from ((((((`course` join (select `attribution`.`course_id` AS `course_id`,max(`attribution`.`id`) AS `max_att_id` from `attribution` where (`attribution`.`year_id` = 8) group by `attribution`.`course_id`) `latest_att` on((`latest_att`.`course_id` = `course`.`id`))) join `attribution` `att` on((`att`.`id` = `latest_att`.`max_att_id`))) join `user` on((`user`.`id` = `att`.`teacher_id`))) join `V_STUDENT_MARK_QUATER23_23` `qt1` on((`course`.`id` = `qt1`.`crs`))) left join `V_STUDENT_MARK_QUATER23_24` `qt2` on(((`qt1`.`std` = `qt2`.`std`) and (`qt1`.`crs` = `qt2`.`crs`)))) left join `V_STUDENT_MARK_QUATER23_26` `qt3` on(((`qt1`.`std` = `qt3`.`std`) and (`qt1`.`crs` = `qt3`.`crs`)))) order by `qt1`.`std` */;

--
-- Final view structure for view `V_STUDENT_MARK_YEAR24_8`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_YEAR24_8`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_YEAR24_8` AS select distinct `user`.`full_name` AS `full_name`,`course`.`wording` AS `wording`,`qt1`.`std` AS `std`,`qt1`.`crs` AS `crs`,`qt1`.`coef` AS `coef`,`qt1`.`value` AS `value1`,`qt1`.`weight` AS `weight1`,`qt2`.`value` AS `value2`,`qt2`.`weight` AS `weight2`,`qt3`.`value` AS `value3`,`qt3`.`weight` AS `weight3`,((((coalesce(`qt1`.`value`,0) * coalesce(`qt1`.`weight`,0)) + (coalesce(`qt2`.`value`,0) * coalesce(`qt2`.`weight`,0))) + (coalesce(`qt3`.`value`,0) * coalesce(`qt3`.`weight`,0))) / nullif(((coalesce(`qt1`.`weight`,0) + coalesce(`qt2`.`weight`,0)) + coalesce(`qt3`.`weight`,0)),0)) AS `value`,greatest(coalesce(`qt1`.`weight`,0),coalesce(`qt2`.`weight`,0),coalesce(`qt3`.`weight`,0)) AS `weight`,(((coalesce(`qt1`.`mini`,0) + coalesce(`qt2`.`mini`,0)) + coalesce(`qt3`.`mini`,0)) / 3) AS `mini`,(((coalesce(`qt1`.`maxi`,0) + coalesce(`qt2`.`maxi`,0)) + coalesce(`qt3`.`maxi`,0)) / 3) AS `maxi`,rank() OVER (PARTITION BY `course`.`id` ORDER BY ((((coalesce(`qt1`.`value`,0) * coalesce(`qt1`.`weight`,0)) + (coalesce(`qt2`.`value`,0) * coalesce(`qt2`.`weight`,0))) + (coalesce(`qt3`.`value`,0) * coalesce(`qt3`.`weight`,0))) / nullif(((coalesce(`qt1`.`weight`,0) + coalesce(`qt2`.`weight`,0)) + coalesce(`qt3`.`weight`,0)),0)) desc )  AS `rank` from ((((((`course` join (select `attribution`.`course_id` AS `course_id`,max(`attribution`.`id`) AS `max_att_id` from `attribution` where (`attribution`.`year_id` = 8) group by `attribution`.`course_id`) `latest_att` on((`latest_att`.`course_id` = `course`.`id`))) join `attribution` `att` on((`att`.`id` = `latest_att`.`max_att_id`))) join `user` on((`user`.`id` = `att`.`teacher_id`))) join `V_STUDENT_MARK_QUATER24_23` `qt1` on((`course`.`id` = `qt1`.`crs`))) left join `V_STUDENT_MARK_QUATER24_24` `qt2` on(((`qt1`.`std` = `qt2`.`std`) and (`qt1`.`crs` = `qt2`.`crs`)))) left join `V_STUDENT_MARK_QUATER24_26` `qt3` on(((`qt1`.`std` = `qt3`.`std`) and (`qt1`.`crs` = `qt3`.`crs`)))) order by `qt1`.`std` */;

--
-- Final view structure for view `V_STUDENT_MARK_YEAR25_8`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_YEAR25_8`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_YEAR25_8` AS select distinct `user`.`full_name` AS `full_name`,`course`.`wording` AS `wording`,`qt1`.`std` AS `std`,`qt1`.`crs` AS `crs`,`qt1`.`coef` AS `coef`,`qt1`.`value` AS `value1`,`qt1`.`weight` AS `weight1`,`qt2`.`value` AS `value2`,`qt2`.`weight` AS `weight2`,`qt3`.`value` AS `value3`,`qt3`.`weight` AS `weight3`,((((coalesce(`qt1`.`value`,0) * coalesce(`qt1`.`weight`,0)) + (coalesce(`qt2`.`value`,0) * coalesce(`qt2`.`weight`,0))) + (coalesce(`qt3`.`value`,0) * coalesce(`qt3`.`weight`,0))) / nullif(((coalesce(`qt1`.`weight`,0) + coalesce(`qt2`.`weight`,0)) + coalesce(`qt3`.`weight`,0)),0)) AS `value`,greatest(coalesce(`qt1`.`weight`,0),coalesce(`qt2`.`weight`,0),coalesce(`qt3`.`weight`,0)) AS `weight`,(((coalesce(`qt1`.`mini`,0) + coalesce(`qt2`.`mini`,0)) + coalesce(`qt3`.`mini`,0)) / 3) AS `mini`,(((coalesce(`qt1`.`maxi`,0) + coalesce(`qt2`.`maxi`,0)) + coalesce(`qt3`.`maxi`,0)) / 3) AS `maxi`,rank() OVER (PARTITION BY `course`.`id` ORDER BY ((((coalesce(`qt1`.`value`,0) * coalesce(`qt1`.`weight`,0)) + (coalesce(`qt2`.`value`,0) * coalesce(`qt2`.`weight`,0))) + (coalesce(`qt3`.`value`,0) * coalesce(`qt3`.`weight`,0))) / nullif(((coalesce(`qt1`.`weight`,0) + coalesce(`qt2`.`weight`,0)) + coalesce(`qt3`.`weight`,0)),0)) desc )  AS `rank` from ((((((`course` join (select `attribution`.`course_id` AS `course_id`,max(`attribution`.`id`) AS `max_att_id` from `attribution` where (`attribution`.`year_id` = 8) group by `attribution`.`course_id`) `latest_att` on((`latest_att`.`course_id` = `course`.`id`))) join `attribution` `att` on((`att`.`id` = `latest_att`.`max_att_id`))) join `user` on((`user`.`id` = `att`.`teacher_id`))) join `V_STUDENT_MARK_QUATER25_23` `qt1` on((`course`.`id` = `qt1`.`crs`))) left join `V_STUDENT_MARK_QUATER25_24` `qt2` on(((`qt1`.`std` = `qt2`.`std`) and (`qt1`.`crs` = `qt2`.`crs`)))) left join `V_STUDENT_MARK_QUATER25_26` `qt3` on(((`qt1`.`std` = `qt3`.`std`) and (`qt1`.`crs` = `qt3`.`crs`)))) order by `qt1`.`std` */;

--
-- Final view structure for view `V_STUDENT_MARK_YEAR26_8`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_YEAR26_8`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_YEAR26_8` AS select distinct `user`.`full_name` AS `full_name`,`course`.`wording` AS `wording`,`qt1`.`std` AS `std`,`qt1`.`crs` AS `crs`,`qt1`.`coef` AS `coef`,`qt1`.`value` AS `value1`,`qt1`.`weight` AS `weight1`,`qt2`.`value` AS `value2`,`qt2`.`weight` AS `weight2`,`qt3`.`value` AS `value3`,`qt3`.`weight` AS `weight3`,((((coalesce(`qt1`.`value`,0) * coalesce(`qt1`.`weight`,0)) + (coalesce(`qt2`.`value`,0) * coalesce(`qt2`.`weight`,0))) + (coalesce(`qt3`.`value`,0) * coalesce(`qt3`.`weight`,0))) / nullif(((coalesce(`qt1`.`weight`,0) + coalesce(`qt2`.`weight`,0)) + coalesce(`qt3`.`weight`,0)),0)) AS `value`,greatest(coalesce(`qt1`.`weight`,0),coalesce(`qt2`.`weight`,0),coalesce(`qt3`.`weight`,0)) AS `weight`,(((coalesce(`qt1`.`mini`,0) + coalesce(`qt2`.`mini`,0)) + coalesce(`qt3`.`mini`,0)) / 3) AS `mini`,(((coalesce(`qt1`.`maxi`,0) + coalesce(`qt2`.`maxi`,0)) + coalesce(`qt3`.`maxi`,0)) / 3) AS `maxi`,rank() OVER (PARTITION BY `course`.`id` ORDER BY ((((coalesce(`qt1`.`value`,0) * coalesce(`qt1`.`weight`,0)) + (coalesce(`qt2`.`value`,0) * coalesce(`qt2`.`weight`,0))) + (coalesce(`qt3`.`value`,0) * coalesce(`qt3`.`weight`,0))) / nullif(((coalesce(`qt1`.`weight`,0) + coalesce(`qt2`.`weight`,0)) + coalesce(`qt3`.`weight`,0)),0)) desc )  AS `rank` from ((((((`course` join (select `attribution`.`course_id` AS `course_id`,max(`attribution`.`id`) AS `max_att_id` from `attribution` where (`attribution`.`year_id` = 8) group by `attribution`.`course_id`) `latest_att` on((`latest_att`.`course_id` = `course`.`id`))) join `attribution` `att` on((`att`.`id` = `latest_att`.`max_att_id`))) join `user` on((`user`.`id` = `att`.`teacher_id`))) join `V_STUDENT_MARK_QUATER26_23` `qt1` on((`course`.`id` = `qt1`.`crs`))) left join `V_STUDENT_MARK_QUATER26_24` `qt2` on(((`qt1`.`std` = `qt2`.`std`) and (`qt1`.`crs` = `qt2`.`crs`)))) left join `V_STUDENT_MARK_QUATER26_26` `qt3` on(((`qt1`.`std` = `qt3`.`std`) and (`qt1`.`crs` = `qt3`.`crs`)))) order by `qt1`.`std` */;

--
-- Final view structure for view `V_STUDENT_MARK_YEAR27_8`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_YEAR27_8`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_YEAR27_8` AS select distinct `user`.`full_name` AS `full_name`,`course`.`wording` AS `wording`,`qt1`.`std` AS `std`,`qt1`.`crs` AS `crs`,`qt1`.`coef` AS `coef`,`qt1`.`value` AS `value1`,`qt1`.`weight` AS `weight1`,`qt2`.`value` AS `value2`,`qt2`.`weight` AS `weight2`,`qt3`.`value` AS `value3`,`qt3`.`weight` AS `weight3`,((((coalesce(`qt1`.`value`,0) * coalesce(`qt1`.`weight`,0)) + (coalesce(`qt2`.`value`,0) * coalesce(`qt2`.`weight`,0))) + (coalesce(`qt3`.`value`,0) * coalesce(`qt3`.`weight`,0))) / nullif(((coalesce(`qt1`.`weight`,0) + coalesce(`qt2`.`weight`,0)) + coalesce(`qt3`.`weight`,0)),0)) AS `value`,greatest(coalesce(`qt1`.`weight`,0),coalesce(`qt2`.`weight`,0),coalesce(`qt3`.`weight`,0)) AS `weight`,(((coalesce(`qt1`.`mini`,0) + coalesce(`qt2`.`mini`,0)) + coalesce(`qt3`.`mini`,0)) / 3) AS `mini`,(((coalesce(`qt1`.`maxi`,0) + coalesce(`qt2`.`maxi`,0)) + coalesce(`qt3`.`maxi`,0)) / 3) AS `maxi`,rank() OVER (PARTITION BY `course`.`id` ORDER BY ((((coalesce(`qt1`.`value`,0) * coalesce(`qt1`.`weight`,0)) + (coalesce(`qt2`.`value`,0) * coalesce(`qt2`.`weight`,0))) + (coalesce(`qt3`.`value`,0) * coalesce(`qt3`.`weight`,0))) / nullif(((coalesce(`qt1`.`weight`,0) + coalesce(`qt2`.`weight`,0)) + coalesce(`qt3`.`weight`,0)),0)) desc )  AS `rank` from ((((((`course` join (select `attribution`.`course_id` AS `course_id`,max(`attribution`.`id`) AS `max_att_id` from `attribution` where (`attribution`.`year_id` = 8) group by `attribution`.`course_id`) `latest_att` on((`latest_att`.`course_id` = `course`.`id`))) join `attribution` `att` on((`att`.`id` = `latest_att`.`max_att_id`))) join `user` on((`user`.`id` = `att`.`teacher_id`))) join `V_STUDENT_MARK_QUATER27_23` `qt1` on((`course`.`id` = `qt1`.`crs`))) left join `V_STUDENT_MARK_QUATER27_24` `qt2` on(((`qt1`.`std` = `qt2`.`std`) and (`qt1`.`crs` = `qt2`.`crs`)))) left join `V_STUDENT_MARK_QUATER27_26` `qt3` on(((`qt1`.`std` = `qt3`.`std`) and (`qt1`.`crs` = `qt3`.`crs`)))) order by `qt1`.`std` */;

--
-- Final view structure for view `V_STUDENT_MARK_YEAR28_8`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_YEAR28_8`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_YEAR28_8` AS select distinct `user`.`full_name` AS `full_name`,`course`.`wording` AS `wording`,`qt1`.`std` AS `std`,`qt1`.`crs` AS `crs`,`qt1`.`coef` AS `coef`,`qt1`.`value` AS `value1`,`qt1`.`weight` AS `weight1`,`qt2`.`value` AS `value2`,`qt2`.`weight` AS `weight2`,`qt3`.`value` AS `value3`,`qt3`.`weight` AS `weight3`,((((coalesce(`qt1`.`value`,0) * coalesce(`qt1`.`weight`,0)) + (coalesce(`qt2`.`value`,0) * coalesce(`qt2`.`weight`,0))) + (coalesce(`qt3`.`value`,0) * coalesce(`qt3`.`weight`,0))) / nullif(((coalesce(`qt1`.`weight`,0) + coalesce(`qt2`.`weight`,0)) + coalesce(`qt3`.`weight`,0)),0)) AS `value`,greatest(coalesce(`qt1`.`weight`,0),coalesce(`qt2`.`weight`,0),coalesce(`qt3`.`weight`,0)) AS `weight`,(((coalesce(`qt1`.`mini`,0) + coalesce(`qt2`.`mini`,0)) + coalesce(`qt3`.`mini`,0)) / 3) AS `mini`,(((coalesce(`qt1`.`maxi`,0) + coalesce(`qt2`.`maxi`,0)) + coalesce(`qt3`.`maxi`,0)) / 3) AS `maxi`,rank() OVER (PARTITION BY `course`.`id` ORDER BY ((((coalesce(`qt1`.`value`,0) * coalesce(`qt1`.`weight`,0)) + (coalesce(`qt2`.`value`,0) * coalesce(`qt2`.`weight`,0))) + (coalesce(`qt3`.`value`,0) * coalesce(`qt3`.`weight`,0))) / nullif(((coalesce(`qt1`.`weight`,0) + coalesce(`qt2`.`weight`,0)) + coalesce(`qt3`.`weight`,0)),0)) desc )  AS `rank` from ((((((`course` join (select `attribution`.`course_id` AS `course_id`,max(`attribution`.`id`) AS `max_att_id` from `attribution` where (`attribution`.`year_id` = 8) group by `attribution`.`course_id`) `latest_att` on((`latest_att`.`course_id` = `course`.`id`))) join `attribution` `att` on((`att`.`id` = `latest_att`.`max_att_id`))) join `user` on((`user`.`id` = `att`.`teacher_id`))) join `V_STUDENT_MARK_QUATER28_23` `qt1` on((`course`.`id` = `qt1`.`crs`))) left join `V_STUDENT_MARK_QUATER28_24` `qt2` on(((`qt1`.`std` = `qt2`.`std`) and (`qt1`.`crs` = `qt2`.`crs`)))) left join `V_STUDENT_MARK_QUATER28_26` `qt3` on(((`qt1`.`std` = `qt3`.`std`) and (`qt1`.`crs` = `qt3`.`crs`)))) order by `qt1`.`std` */;

--
-- Final view structure for view `V_STUDENT_MARK_YEAR29_8`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_YEAR29_8`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_YEAR29_8` AS select distinct `user`.`full_name` AS `full_name`,`course`.`wording` AS `wording`,`qt1`.`std` AS `std`,`qt1`.`crs` AS `crs`,`qt1`.`coef` AS `coef`,`qt1`.`value` AS `value1`,`qt1`.`weight` AS `weight1`,`qt2`.`value` AS `value2`,`qt2`.`weight` AS `weight2`,`qt3`.`value` AS `value3`,`qt3`.`weight` AS `weight3`,((((coalesce(`qt1`.`value`,0) * coalesce(`qt1`.`weight`,0)) + (coalesce(`qt2`.`value`,0) * coalesce(`qt2`.`weight`,0))) + (coalesce(`qt3`.`value`,0) * coalesce(`qt3`.`weight`,0))) / nullif(((coalesce(`qt1`.`weight`,0) + coalesce(`qt2`.`weight`,0)) + coalesce(`qt3`.`weight`,0)),0)) AS `value`,greatest(coalesce(`qt1`.`weight`,0),coalesce(`qt2`.`weight`,0),coalesce(`qt3`.`weight`,0)) AS `weight`,(((coalesce(`qt1`.`mini`,0) + coalesce(`qt2`.`mini`,0)) + coalesce(`qt3`.`mini`,0)) / 3) AS `mini`,(((coalesce(`qt1`.`maxi`,0) + coalesce(`qt2`.`maxi`,0)) + coalesce(`qt3`.`maxi`,0)) / 3) AS `maxi`,rank() OVER (PARTITION BY `course`.`id` ORDER BY ((((coalesce(`qt1`.`value`,0) * coalesce(`qt1`.`weight`,0)) + (coalesce(`qt2`.`value`,0) * coalesce(`qt2`.`weight`,0))) + (coalesce(`qt3`.`value`,0) * coalesce(`qt3`.`weight`,0))) / nullif(((coalesce(`qt1`.`weight`,0) + coalesce(`qt2`.`weight`,0)) + coalesce(`qt3`.`weight`,0)),0)) desc )  AS `rank` from (((((`course` join `attribution` `att` on(((`att`.`course_id` = `course`.`id`) and (`att`.`year_id` = 8)))) join `user` on((`user`.`id` = `att`.`teacher_id`))) join `V_STUDENT_MARK_QUATER29_23` `qt1` on((`course`.`id` = `qt1`.`crs`))) left join `V_STUDENT_MARK_QUATER29_24` `qt2` on(((`qt1`.`std` = `qt2`.`std`) and (`qt1`.`crs` = `qt2`.`crs`)))) left join `V_STUDENT_MARK_QUATER29_26` `qt3` on(((`qt1`.`std` = `qt3`.`std`) and (`qt1`.`crs` = `qt3`.`crs`)))) order by `qt1`.`std` */;

--
-- Final view structure for view `V_STUDENT_MARK_YEAR2_8`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_YEAR2_8`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_YEAR2_8` AS select distinct `user`.`full_name` AS `full_name`,`course`.`wording` AS `wording`,`qt1`.`std` AS `std`,`qt1`.`crs` AS `crs`,`qt1`.`coef` AS `coef`,`qt1`.`value` AS `value1`,`qt1`.`weight` AS `weight1`,`qt2`.`value` AS `value2`,`qt2`.`weight` AS `weight2`,`qt3`.`value` AS `value3`,`qt3`.`weight` AS `weight3`,((((coalesce(`qt1`.`value`,0) * coalesce(`qt1`.`weight`,0)) + (coalesce(`qt2`.`value`,0) * coalesce(`qt2`.`weight`,0))) + (coalesce(`qt3`.`value`,0) * coalesce(`qt3`.`weight`,0))) / nullif(((coalesce(`qt1`.`weight`,0) + coalesce(`qt2`.`weight`,0)) + coalesce(`qt3`.`weight`,0)),0)) AS `value`,greatest(coalesce(`qt1`.`weight`,0),coalesce(`qt2`.`weight`,0),coalesce(`qt3`.`weight`,0)) AS `weight`,(((coalesce(`qt1`.`mini`,0) + coalesce(`qt2`.`mini`,0)) + coalesce(`qt3`.`mini`,0)) / 3) AS `mini`,(((coalesce(`qt1`.`maxi`,0) + coalesce(`qt2`.`maxi`,0)) + coalesce(`qt3`.`maxi`,0)) / 3) AS `maxi`,rank() OVER (PARTITION BY `course`.`id` ORDER BY ((((coalesce(`qt1`.`value`,0) * coalesce(`qt1`.`weight`,0)) + (coalesce(`qt2`.`value`,0) * coalesce(`qt2`.`weight`,0))) + (coalesce(`qt3`.`value`,0) * coalesce(`qt3`.`weight`,0))) / nullif(((coalesce(`qt1`.`weight`,0) + coalesce(`qt2`.`weight`,0)) + coalesce(`qt3`.`weight`,0)),0)) desc )  AS `rank` from (((((`course` join `attribution` `att` on(((`att`.`course_id` = `course`.`id`) and (`att`.`year_id` = 8)))) join `user` on((`user`.`id` = `att`.`teacher_id`))) join `V_STUDENT_MARK_QUATER2_23` `qt1` on((`course`.`id` = `qt1`.`crs`))) left join `V_STUDENT_MARK_QUATER2_24` `qt2` on(((`qt1`.`std` = `qt2`.`std`) and (`qt1`.`crs` = `qt2`.`crs`)))) left join `V_STUDENT_MARK_QUATER2_26` `qt3` on(((`qt1`.`std` = `qt3`.`std`) and (`qt1`.`crs` = `qt3`.`crs`)))) order by `qt1`.`std` */;

--
-- Final view structure for view `V_STUDENT_MARK_YEAR30_8`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_YEAR30_8`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_YEAR30_8` AS select distinct `user`.`full_name` AS `full_name`,`course`.`wording` AS `wording`,`qt1`.`std` AS `std`,`qt1`.`crs` AS `crs`,`qt1`.`coef` AS `coef`,`qt1`.`value` AS `value1`,`qt1`.`weight` AS `weight1`,`qt2`.`value` AS `value2`,`qt2`.`weight` AS `weight2`,`qt3`.`value` AS `value3`,`qt3`.`weight` AS `weight3`,((((coalesce(`qt1`.`value`,0) * coalesce(`qt1`.`weight`,0)) + (coalesce(`qt2`.`value`,0) * coalesce(`qt2`.`weight`,0))) + (coalesce(`qt3`.`value`,0) * coalesce(`qt3`.`weight`,0))) / nullif(((coalesce(`qt1`.`weight`,0) + coalesce(`qt2`.`weight`,0)) + coalesce(`qt3`.`weight`,0)),0)) AS `value`,greatest(coalesce(`qt1`.`weight`,0),coalesce(`qt2`.`weight`,0),coalesce(`qt3`.`weight`,0)) AS `weight`,(((coalesce(`qt1`.`mini`,0) + coalesce(`qt2`.`mini`,0)) + coalesce(`qt3`.`mini`,0)) / 3) AS `mini`,(((coalesce(`qt1`.`maxi`,0) + coalesce(`qt2`.`maxi`,0)) + coalesce(`qt3`.`maxi`,0)) / 3) AS `maxi`,rank() OVER (PARTITION BY `course`.`id` ORDER BY ((((coalesce(`qt1`.`value`,0) * coalesce(`qt1`.`weight`,0)) + (coalesce(`qt2`.`value`,0) * coalesce(`qt2`.`weight`,0))) + (coalesce(`qt3`.`value`,0) * coalesce(`qt3`.`weight`,0))) / nullif(((coalesce(`qt1`.`weight`,0) + coalesce(`qt2`.`weight`,0)) + coalesce(`qt3`.`weight`,0)),0)) desc )  AS `rank` from (((((`course` join `attribution` `att` on(((`att`.`course_id` = `course`.`id`) and (`att`.`year_id` = 8)))) join `user` on((`user`.`id` = `att`.`teacher_id`))) join `V_STUDENT_MARK_QUATER30_23` `qt1` on((`course`.`id` = `qt1`.`crs`))) left join `V_STUDENT_MARK_QUATER30_24` `qt2` on(((`qt1`.`std` = `qt2`.`std`) and (`qt1`.`crs` = `qt2`.`crs`)))) left join `V_STUDENT_MARK_QUATER30_26` `qt3` on(((`qt1`.`std` = `qt3`.`std`) and (`qt1`.`crs` = `qt3`.`crs`)))) order by `qt1`.`std` */;

--
-- Final view structure for view `V_STUDENT_MARK_YEAR3_8`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_YEAR3_8`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_YEAR3_8` AS select distinct `user`.`full_name` AS `full_name`,`course`.`wording` AS `wording`,`qt1`.`std` AS `std`,`qt1`.`crs` AS `crs`,`qt1`.`coef` AS `coef`,`qt1`.`value` AS `value1`,`qt1`.`weight` AS `weight1`,`qt2`.`value` AS `value2`,`qt2`.`weight` AS `weight2`,`qt3`.`value` AS `value3`,`qt3`.`weight` AS `weight3`,((((coalesce(`qt1`.`value`,0) * coalesce(`qt1`.`weight`,0)) + (coalesce(`qt2`.`value`,0) * coalesce(`qt2`.`weight`,0))) + (coalesce(`qt3`.`value`,0) * coalesce(`qt3`.`weight`,0))) / nullif(((coalesce(`qt1`.`weight`,0) + coalesce(`qt2`.`weight`,0)) + coalesce(`qt3`.`weight`,0)),0)) AS `value`,greatest(coalesce(`qt1`.`weight`,0),coalesce(`qt2`.`weight`,0),coalesce(`qt3`.`weight`,0)) AS `weight`,(((coalesce(`qt1`.`mini`,0) + coalesce(`qt2`.`mini`,0)) + coalesce(`qt3`.`mini`,0)) / 3) AS `mini`,(((coalesce(`qt1`.`maxi`,0) + coalesce(`qt2`.`maxi`,0)) + coalesce(`qt3`.`maxi`,0)) / 3) AS `maxi`,rank() OVER (PARTITION BY `course`.`id` ORDER BY ((((coalesce(`qt1`.`value`,0) * coalesce(`qt1`.`weight`,0)) + (coalesce(`qt2`.`value`,0) * coalesce(`qt2`.`weight`,0))) + (coalesce(`qt3`.`value`,0) * coalesce(`qt3`.`weight`,0))) / nullif(((coalesce(`qt1`.`weight`,0) + coalesce(`qt2`.`weight`,0)) + coalesce(`qt3`.`weight`,0)),0)) desc )  AS `rank` from (((((`course` join `attribution` `att` on(((`att`.`course_id` = `course`.`id`) and (`att`.`year_id` = 8)))) join `user` on((`user`.`id` = `att`.`teacher_id`))) join `V_STUDENT_MARK_QUATER3_23` `qt1` on((`course`.`id` = `qt1`.`crs`))) left join `V_STUDENT_MARK_QUATER3_24` `qt2` on(((`qt1`.`std` = `qt2`.`std`) and (`qt1`.`crs` = `qt2`.`crs`)))) left join `V_STUDENT_MARK_QUATER3_26` `qt3` on(((`qt1`.`std` = `qt3`.`std`) and (`qt1`.`crs` = `qt3`.`crs`)))) order by `qt1`.`std` */;

--
-- Final view structure for view `V_STUDENT_MARK_YEAR4_8`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_YEAR4_8`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_YEAR4_8` AS select distinct `user`.`full_name` AS `full_name`,`course`.`wording` AS `wording`,`qt1`.`std` AS `std`,`qt1`.`crs` AS `crs`,`qt1`.`coef` AS `coef`,`qt1`.`value` AS `value1`,`qt1`.`weight` AS `weight1`,`qt2`.`value` AS `value2`,`qt2`.`weight` AS `weight2`,`qt3`.`value` AS `value3`,`qt3`.`weight` AS `weight3`,((((coalesce(`qt1`.`value`,0) * coalesce(`qt1`.`weight`,0)) + (coalesce(`qt2`.`value`,0) * coalesce(`qt2`.`weight`,0))) + (coalesce(`qt3`.`value`,0) * coalesce(`qt3`.`weight`,0))) / nullif(((coalesce(`qt1`.`weight`,0) + coalesce(`qt2`.`weight`,0)) + coalesce(`qt3`.`weight`,0)),0)) AS `value`,greatest(coalesce(`qt1`.`weight`,0),coalesce(`qt2`.`weight`,0),coalesce(`qt3`.`weight`,0)) AS `weight`,(((coalesce(`qt1`.`mini`,0) + coalesce(`qt2`.`mini`,0)) + coalesce(`qt3`.`mini`,0)) / 3) AS `mini`,(((coalesce(`qt1`.`maxi`,0) + coalesce(`qt2`.`maxi`,0)) + coalesce(`qt3`.`maxi`,0)) / 3) AS `maxi`,rank() OVER (PARTITION BY `course`.`id` ORDER BY ((((coalesce(`qt1`.`value`,0) * coalesce(`qt1`.`weight`,0)) + (coalesce(`qt2`.`value`,0) * coalesce(`qt2`.`weight`,0))) + (coalesce(`qt3`.`value`,0) * coalesce(`qt3`.`weight`,0))) / nullif(((coalesce(`qt1`.`weight`,0) + coalesce(`qt2`.`weight`,0)) + coalesce(`qt3`.`weight`,0)),0)) desc )  AS `rank` from (((((`course` join `attribution` `att` on(((`att`.`course_id` = `course`.`id`) and (`att`.`year_id` = 8)))) join `user` on((`user`.`id` = `att`.`teacher_id`))) join `V_STUDENT_MARK_QUATER4_23` `qt1` on((`course`.`id` = `qt1`.`crs`))) left join `V_STUDENT_MARK_QUATER4_24` `qt2` on(((`qt1`.`std` = `qt2`.`std`) and (`qt1`.`crs` = `qt2`.`crs`)))) left join `V_STUDENT_MARK_QUATER4_26` `qt3` on(((`qt1`.`std` = `qt3`.`std`) and (`qt1`.`crs` = `qt3`.`crs`)))) order by `qt1`.`std` */;

--
-- Final view structure for view `V_STUDENT_MARK_YEAR5_8`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_YEAR5_8`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_YEAR5_8` AS select distinct `user`.`full_name` AS `full_name`,`course`.`wording` AS `wording`,`qt1`.`std` AS `std`,`qt1`.`crs` AS `crs`,`qt1`.`coef` AS `coef`,`qt1`.`value` AS `value1`,`qt1`.`weight` AS `weight1`,`qt2`.`value` AS `value2`,`qt2`.`weight` AS `weight2`,`qt3`.`value` AS `value3`,`qt3`.`weight` AS `weight3`,((((coalesce(`qt1`.`value`,0) * coalesce(`qt1`.`weight`,0)) + (coalesce(`qt2`.`value`,0) * coalesce(`qt2`.`weight`,0))) + (coalesce(`qt3`.`value`,0) * coalesce(`qt3`.`weight`,0))) / nullif(((coalesce(`qt1`.`weight`,0) + coalesce(`qt2`.`weight`,0)) + coalesce(`qt3`.`weight`,0)),0)) AS `value`,greatest(coalesce(`qt1`.`weight`,0),coalesce(`qt2`.`weight`,0),coalesce(`qt3`.`weight`,0)) AS `weight`,(((coalesce(`qt1`.`mini`,0) + coalesce(`qt2`.`mini`,0)) + coalesce(`qt3`.`mini`,0)) / 3) AS `mini`,(((coalesce(`qt1`.`maxi`,0) + coalesce(`qt2`.`maxi`,0)) + coalesce(`qt3`.`maxi`,0)) / 3) AS `maxi`,rank() OVER (PARTITION BY `course`.`id` ORDER BY ((((coalesce(`qt1`.`value`,0) * coalesce(`qt1`.`weight`,0)) + (coalesce(`qt2`.`value`,0) * coalesce(`qt2`.`weight`,0))) + (coalesce(`qt3`.`value`,0) * coalesce(`qt3`.`weight`,0))) / nullif(((coalesce(`qt1`.`weight`,0) + coalesce(`qt2`.`weight`,0)) + coalesce(`qt3`.`weight`,0)),0)) desc )  AS `rank` from (((((`course` join `attribution` `att` on(((`att`.`course_id` = `course`.`id`) and (`att`.`year_id` = 8)))) join `user` on((`user`.`id` = `att`.`teacher_id`))) join `V_STUDENT_MARK_QUATER5_23` `qt1` on((`course`.`id` = `qt1`.`crs`))) left join `V_STUDENT_MARK_QUATER5_24` `qt2` on(((`qt1`.`std` = `qt2`.`std`) and (`qt1`.`crs` = `qt2`.`crs`)))) left join `V_STUDENT_MARK_QUATER5_26` `qt3` on(((`qt1`.`std` = `qt3`.`std`) and (`qt1`.`crs` = `qt3`.`crs`)))) order by `qt1`.`std` */;

--
-- Final view structure for view `V_STUDENT_MARK_YEAR6_8`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_YEAR6_8`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_YEAR6_8` AS select distinct `user`.`full_name` AS `full_name`,`course`.`wording` AS `wording`,`qt1`.`std` AS `std`,`qt1`.`crs` AS `crs`,`qt1`.`coef` AS `coef`,`qt1`.`value` AS `value1`,`qt1`.`weight` AS `weight1`,`qt2`.`value` AS `value2`,`qt2`.`weight` AS `weight2`,`qt3`.`value` AS `value3`,`qt3`.`weight` AS `weight3`,((((coalesce(`qt1`.`value`,0) * coalesce(`qt1`.`weight`,0)) + (coalesce(`qt2`.`value`,0) * coalesce(`qt2`.`weight`,0))) + (coalesce(`qt3`.`value`,0) * coalesce(`qt3`.`weight`,0))) / nullif(((coalesce(`qt1`.`weight`,0) + coalesce(`qt2`.`weight`,0)) + coalesce(`qt3`.`weight`,0)),0)) AS `value`,greatest(coalesce(`qt1`.`weight`,0),coalesce(`qt2`.`weight`,0),coalesce(`qt3`.`weight`,0)) AS `weight`,(((coalesce(`qt1`.`mini`,0) + coalesce(`qt2`.`mini`,0)) + coalesce(`qt3`.`mini`,0)) / 3) AS `mini`,(((coalesce(`qt1`.`maxi`,0) + coalesce(`qt2`.`maxi`,0)) + coalesce(`qt3`.`maxi`,0)) / 3) AS `maxi`,rank() OVER (PARTITION BY `course`.`id` ORDER BY ((((coalesce(`qt1`.`value`,0) * coalesce(`qt1`.`weight`,0)) + (coalesce(`qt2`.`value`,0) * coalesce(`qt2`.`weight`,0))) + (coalesce(`qt3`.`value`,0) * coalesce(`qt3`.`weight`,0))) / nullif(((coalesce(`qt1`.`weight`,0) + coalesce(`qt2`.`weight`,0)) + coalesce(`qt3`.`weight`,0)),0)) desc )  AS `rank` from (((((`course` join `attribution` `att` on(((`att`.`course_id` = `course`.`id`) and (`att`.`year_id` = 8)))) join `user` on((`user`.`id` = `att`.`teacher_id`))) join `V_STUDENT_MARK_QUATER6_23` `qt1` on((`course`.`id` = `qt1`.`crs`))) left join `V_STUDENT_MARK_QUATER6_24` `qt2` on(((`qt1`.`std` = `qt2`.`std`) and (`qt1`.`crs` = `qt2`.`crs`)))) left join `V_STUDENT_MARK_QUATER6_26` `qt3` on(((`qt1`.`std` = `qt3`.`std`) and (`qt1`.`crs` = `qt3`.`crs`)))) order by `qt1`.`std` */;

--
-- Final view structure for view `V_STUDENT_MARK_YEAR7_8`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_YEAR7_8`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_YEAR7_8` AS select distinct `user`.`full_name` AS `full_name`,`course`.`wording` AS `wording`,`qt1`.`std` AS `std`,`qt1`.`crs` AS `crs`,`qt1`.`coef` AS `coef`,`qt1`.`value` AS `value1`,`qt1`.`weight` AS `weight1`,`qt2`.`value` AS `value2`,`qt2`.`weight` AS `weight2`,`qt3`.`value` AS `value3`,`qt3`.`weight` AS `weight3`,((((coalesce(`qt1`.`value`,0) * coalesce(`qt1`.`weight`,0)) + (coalesce(`qt2`.`value`,0) * coalesce(`qt2`.`weight`,0))) + (coalesce(`qt3`.`value`,0) * coalesce(`qt3`.`weight`,0))) / nullif(((coalesce(`qt1`.`weight`,0) + coalesce(`qt2`.`weight`,0)) + coalesce(`qt3`.`weight`,0)),0)) AS `value`,greatest(coalesce(`qt1`.`weight`,0),coalesce(`qt2`.`weight`,0),coalesce(`qt3`.`weight`,0)) AS `weight`,(((coalesce(`qt1`.`mini`,0) + coalesce(`qt2`.`mini`,0)) + coalesce(`qt3`.`mini`,0)) / 3) AS `mini`,(((coalesce(`qt1`.`maxi`,0) + coalesce(`qt2`.`maxi`,0)) + coalesce(`qt3`.`maxi`,0)) / 3) AS `maxi`,rank() OVER (PARTITION BY `course`.`id` ORDER BY ((((coalesce(`qt1`.`value`,0) * coalesce(`qt1`.`weight`,0)) + (coalesce(`qt2`.`value`,0) * coalesce(`qt2`.`weight`,0))) + (coalesce(`qt3`.`value`,0) * coalesce(`qt3`.`weight`,0))) / nullif(((coalesce(`qt1`.`weight`,0) + coalesce(`qt2`.`weight`,0)) + coalesce(`qt3`.`weight`,0)),0)) desc )  AS `rank` from (((((`course` join `attribution` `att` on(((`att`.`course_id` = `course`.`id`) and (`att`.`year_id` = 8)))) join `user` on((`user`.`id` = `att`.`teacher_id`))) join `V_STUDENT_MARK_QUATER7_23` `qt1` on((`course`.`id` = `qt1`.`crs`))) left join `V_STUDENT_MARK_QUATER7_24` `qt2` on(((`qt1`.`std` = `qt2`.`std`) and (`qt1`.`crs` = `qt2`.`crs`)))) left join `V_STUDENT_MARK_QUATER7_26` `qt3` on(((`qt1`.`std` = `qt3`.`std`) and (`qt1`.`crs` = `qt3`.`crs`)))) order by `qt1`.`std` */;

--
-- Final view structure for view `V_STUDENT_MARK_YEAR8_8`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_YEAR8_8`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_YEAR8_8` AS select distinct `user`.`full_name` AS `full_name`,`course`.`wording` AS `wording`,`qt1`.`std` AS `std`,`qt1`.`crs` AS `crs`,`qt1`.`coef` AS `coef`,`qt1`.`value` AS `value1`,`qt1`.`weight` AS `weight1`,`qt2`.`value` AS `value2`,`qt2`.`weight` AS `weight2`,`qt3`.`value` AS `value3`,`qt3`.`weight` AS `weight3`,((((coalesce(`qt1`.`value`,0) * coalesce(`qt1`.`weight`,0)) + (coalesce(`qt2`.`value`,0) * coalesce(`qt2`.`weight`,0))) + (coalesce(`qt3`.`value`,0) * coalesce(`qt3`.`weight`,0))) / nullif(((coalesce(`qt1`.`weight`,0) + coalesce(`qt2`.`weight`,0)) + coalesce(`qt3`.`weight`,0)),0)) AS `value`,greatest(coalesce(`qt1`.`weight`,0),coalesce(`qt2`.`weight`,0),coalesce(`qt3`.`weight`,0)) AS `weight`,(((coalesce(`qt1`.`mini`,0) + coalesce(`qt2`.`mini`,0)) + coalesce(`qt3`.`mini`,0)) / 3) AS `mini`,(((coalesce(`qt1`.`maxi`,0) + coalesce(`qt2`.`maxi`,0)) + coalesce(`qt3`.`maxi`,0)) / 3) AS `maxi`,rank() OVER (PARTITION BY `course`.`id` ORDER BY ((((coalesce(`qt1`.`value`,0) * coalesce(`qt1`.`weight`,0)) + (coalesce(`qt2`.`value`,0) * coalesce(`qt2`.`weight`,0))) + (coalesce(`qt3`.`value`,0) * coalesce(`qt3`.`weight`,0))) / nullif(((coalesce(`qt1`.`weight`,0) + coalesce(`qt2`.`weight`,0)) + coalesce(`qt3`.`weight`,0)),0)) desc )  AS `rank` from (((((`course` join `attribution` `att` on(((`att`.`course_id` = `course`.`id`) and (`att`.`year_id` = 8)))) join `user` on((`user`.`id` = `att`.`teacher_id`))) join `V_STUDENT_MARK_QUATER8_23` `qt1` on((`course`.`id` = `qt1`.`crs`))) left join `V_STUDENT_MARK_QUATER8_24` `qt2` on(((`qt1`.`std` = `qt2`.`std`) and (`qt1`.`crs` = `qt2`.`crs`)))) left join `V_STUDENT_MARK_QUATER8_26` `qt3` on(((`qt1`.`std` = `qt3`.`std`) and (`qt1`.`crs` = `qt3`.`crs`)))) order by `qt1`.`std` */;

--
-- Final view structure for view `V_STUDENT_MARK_YEAR9_8`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_YEAR9_8`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_YEAR9_8` AS select distinct `user`.`full_name` AS `full_name`,`course`.`wording` AS `wording`,`qt1`.`std` AS `std`,`qt1`.`crs` AS `crs`,`qt1`.`coef` AS `coef`,`qt1`.`value` AS `value1`,`qt1`.`weight` AS `weight1`,`qt2`.`value` AS `value2`,`qt2`.`weight` AS `weight2`,`qt3`.`value` AS `value3`,`qt3`.`weight` AS `weight3`,((((coalesce(`qt1`.`value`,0) * coalesce(`qt1`.`weight`,0)) + (coalesce(`qt2`.`value`,0) * coalesce(`qt2`.`weight`,0))) + (coalesce(`qt3`.`value`,0) * coalesce(`qt3`.`weight`,0))) / nullif(((coalesce(`qt1`.`weight`,0) + coalesce(`qt2`.`weight`,0)) + coalesce(`qt3`.`weight`,0)),0)) AS `value`,greatest(coalesce(`qt1`.`weight`,0),coalesce(`qt2`.`weight`,0),coalesce(`qt3`.`weight`,0)) AS `weight`,(((coalesce(`qt1`.`mini`,0) + coalesce(`qt2`.`mini`,0)) + coalesce(`qt3`.`mini`,0)) / 3) AS `mini`,(((coalesce(`qt1`.`maxi`,0) + coalesce(`qt2`.`maxi`,0)) + coalesce(`qt3`.`maxi`,0)) / 3) AS `maxi`,rank() OVER (PARTITION BY `course`.`id` ORDER BY ((((coalesce(`qt1`.`value`,0) * coalesce(`qt1`.`weight`,0)) + (coalesce(`qt2`.`value`,0) * coalesce(`qt2`.`weight`,0))) + (coalesce(`qt3`.`value`,0) * coalesce(`qt3`.`weight`,0))) / nullif(((coalesce(`qt1`.`weight`,0) + coalesce(`qt2`.`weight`,0)) + coalesce(`qt3`.`weight`,0)),0)) desc )  AS `rank` from (((((`course` join `attribution` `att` on(((`att`.`course_id` = `course`.`id`) and (`att`.`year_id` = 8)))) join `user` on((`user`.`id` = `att`.`teacher_id`))) join `V_STUDENT_MARK_QUATER9_23` `qt1` on((`course`.`id` = `qt1`.`crs`))) left join `V_STUDENT_MARK_QUATER9_24` `qt2` on(((`qt1`.`std` = `qt2`.`std`) and (`qt1`.`crs` = `qt2`.`crs`)))) left join `V_STUDENT_MARK_QUATER9_26` `qt3` on(((`qt1`.`std` = `qt3`.`std`) and (`qt1`.`crs` = `qt3`.`crs`)))) order by `qt1`.`std` */;

--
-- Final view structure for view `V_STUDENT_RANKS`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_RANKS`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_RANKS` AS select `V_STUDENT_MARK_QUATER`.`std` AS `std`,cast((sum(((`V_STUDENT_MARK_QUATER`.`value` * `V_STUDENT_MARK_QUATER`.`weight`) * `V_STUDENT_MARK_QUATER`.`coef`)) / sum((`V_STUDENT_MARK_QUATER`.`weight` * `V_STUDENT_MARK_QUATER`.`coef`))) as decimal(4,2)) AS `moyenne`,sum((`V_STUDENT_MARK_QUATER`.`weight` * `V_STUDENT_MARK_QUATER`.`coef`)) AS `totalCoef` from `V_STUDENT_MARK_QUATER` group by `V_STUDENT_MARK_QUATER`.`std` order by sum(((`V_STUDENT_MARK_QUATER`.`value` * `V_STUDENT_MARK_QUATER`.`weight`) * `V_STUDENT_MARK_QUATER`.`coef`)) desc */;

--
-- Final view structure for view `V_STUDENT_RANKS10_8`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_RANKS10_8`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_RANKS10_8` AS select `V_STUDENT_MARK_YEAR10_8`.`std` AS `std`,cast((sum(((`V_STUDENT_MARK_YEAR10_8`.`value` * `V_STUDENT_MARK_YEAR10_8`.`weight`) * `V_STUDENT_MARK_YEAR10_8`.`coef`)) / sum((`V_STUDENT_MARK_YEAR10_8`.`weight` * `V_STUDENT_MARK_YEAR10_8`.`coef`))) as decimal(4,2)) AS `moyenne`,sum((`V_STUDENT_MARK_YEAR10_8`.`weight` * `V_STUDENT_MARK_YEAR10_8`.`coef`)) AS `totalCoef` from `V_STUDENT_MARK_YEAR10_8` group by `V_STUDENT_MARK_YEAR10_8`.`std` order by sum(((`V_STUDENT_MARK_YEAR10_8`.`value` * `V_STUDENT_MARK_YEAR10_8`.`weight`) * `V_STUDENT_MARK_YEAR10_8`.`coef`)) desc */;

--
-- Final view structure for view `V_STUDENT_RANKS12_8`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_RANKS12_8`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_RANKS12_8` AS select `V_STUDENT_MARK_YEAR12_8`.`std` AS `std`,cast((sum(((`V_STUDENT_MARK_YEAR12_8`.`value` * `V_STUDENT_MARK_YEAR12_8`.`weight`) * `V_STUDENT_MARK_YEAR12_8`.`coef`)) / sum((`V_STUDENT_MARK_YEAR12_8`.`weight` * `V_STUDENT_MARK_YEAR12_8`.`coef`))) as decimal(4,2)) AS `moyenne`,sum((`V_STUDENT_MARK_YEAR12_8`.`weight` * `V_STUDENT_MARK_YEAR12_8`.`coef`)) AS `totalCoef` from `V_STUDENT_MARK_YEAR12_8` group by `V_STUDENT_MARK_YEAR12_8`.`std` order by sum(((`V_STUDENT_MARK_YEAR12_8`.`value` * `V_STUDENT_MARK_YEAR12_8`.`weight`) * `V_STUDENT_MARK_YEAR12_8`.`coef`)) desc */;

--
-- Final view structure for view `V_STUDENT_RANKS14_8`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_RANKS14_8`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_RANKS14_8` AS select `V_STUDENT_MARK_YEAR14_8`.`std` AS `std`,cast((sum(((`V_STUDENT_MARK_YEAR14_8`.`value` * `V_STUDENT_MARK_YEAR14_8`.`weight`) * `V_STUDENT_MARK_YEAR14_8`.`coef`)) / sum((`V_STUDENT_MARK_YEAR14_8`.`weight` * `V_STUDENT_MARK_YEAR14_8`.`coef`))) as decimal(4,2)) AS `moyenne`,sum((`V_STUDENT_MARK_YEAR14_8`.`weight` * `V_STUDENT_MARK_YEAR14_8`.`coef`)) AS `totalCoef` from `V_STUDENT_MARK_YEAR14_8` group by `V_STUDENT_MARK_YEAR14_8`.`std` order by sum(((`V_STUDENT_MARK_YEAR14_8`.`value` * `V_STUDENT_MARK_YEAR14_8`.`weight`) * `V_STUDENT_MARK_YEAR14_8`.`coef`)) desc */;

--
-- Final view structure for view `V_STUDENT_RANKS15_8`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_RANKS15_8`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_RANKS15_8` AS select `V_STUDENT_MARK_YEAR15_8`.`std` AS `std`,cast((sum(((`V_STUDENT_MARK_YEAR15_8`.`value` * `V_STUDENT_MARK_YEAR15_8`.`weight`) * `V_STUDENT_MARK_YEAR15_8`.`coef`)) / sum((`V_STUDENT_MARK_YEAR15_8`.`weight` * `V_STUDENT_MARK_YEAR15_8`.`coef`))) as decimal(4,2)) AS `moyenne`,sum((`V_STUDENT_MARK_YEAR15_8`.`weight` * `V_STUDENT_MARK_YEAR15_8`.`coef`)) AS `totalCoef` from `V_STUDENT_MARK_YEAR15_8` group by `V_STUDENT_MARK_YEAR15_8`.`std` order by sum(((`V_STUDENT_MARK_YEAR15_8`.`value` * `V_STUDENT_MARK_YEAR15_8`.`weight`) * `V_STUDENT_MARK_YEAR15_8`.`coef`)) desc */;

--
-- Final view structure for view `V_STUDENT_RANKS16_8`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_RANKS16_8`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_RANKS16_8` AS select `V_STUDENT_MARK_YEAR16_8`.`std` AS `std`,cast((sum(((`V_STUDENT_MARK_YEAR16_8`.`value` * `V_STUDENT_MARK_YEAR16_8`.`weight`) * `V_STUDENT_MARK_YEAR16_8`.`coef`)) / sum((`V_STUDENT_MARK_YEAR16_8`.`weight` * `V_STUDENT_MARK_YEAR16_8`.`coef`))) as decimal(4,2)) AS `moyenne`,sum((`V_STUDENT_MARK_YEAR16_8`.`weight` * `V_STUDENT_MARK_YEAR16_8`.`coef`)) AS `totalCoef` from `V_STUDENT_MARK_YEAR16_8` group by `V_STUDENT_MARK_YEAR16_8`.`std` order by sum(((`V_STUDENT_MARK_YEAR16_8`.`value` * `V_STUDENT_MARK_YEAR16_8`.`weight`) * `V_STUDENT_MARK_YEAR16_8`.`coef`)) desc */;

--
-- Final view structure for view `V_STUDENT_RANKS17_8`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_RANKS17_8`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_RANKS17_8` AS select `V_STUDENT_MARK_YEAR17_8`.`std` AS `std`,cast((sum(((`V_STUDENT_MARK_YEAR17_8`.`value` * `V_STUDENT_MARK_YEAR17_8`.`weight`) * `V_STUDENT_MARK_YEAR17_8`.`coef`)) / sum((`V_STUDENT_MARK_YEAR17_8`.`weight` * `V_STUDENT_MARK_YEAR17_8`.`coef`))) as decimal(4,2)) AS `moyenne`,sum((`V_STUDENT_MARK_YEAR17_8`.`weight` * `V_STUDENT_MARK_YEAR17_8`.`coef`)) AS `totalCoef` from `V_STUDENT_MARK_YEAR17_8` group by `V_STUDENT_MARK_YEAR17_8`.`std` order by sum(((`V_STUDENT_MARK_YEAR17_8`.`value` * `V_STUDENT_MARK_YEAR17_8`.`weight`) * `V_STUDENT_MARK_YEAR17_8`.`coef`)) desc */;

--
-- Final view structure for view `V_STUDENT_RANKS18_8`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_RANKS18_8`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_RANKS18_8` AS select `V_STUDENT_MARK_YEAR18_8`.`std` AS `std`,cast((sum(((`V_STUDENT_MARK_YEAR18_8`.`value` * `V_STUDENT_MARK_YEAR18_8`.`weight`) * `V_STUDENT_MARK_YEAR18_8`.`coef`)) / sum((`V_STUDENT_MARK_YEAR18_8`.`weight` * `V_STUDENT_MARK_YEAR18_8`.`coef`))) as decimal(4,2)) AS `moyenne`,sum((`V_STUDENT_MARK_YEAR18_8`.`weight` * `V_STUDENT_MARK_YEAR18_8`.`coef`)) AS `totalCoef` from `V_STUDENT_MARK_YEAR18_8` group by `V_STUDENT_MARK_YEAR18_8`.`std` order by sum(((`V_STUDENT_MARK_YEAR18_8`.`value` * `V_STUDENT_MARK_YEAR18_8`.`weight`) * `V_STUDENT_MARK_YEAR18_8`.`coef`)) desc */;

--
-- Final view structure for view `V_STUDENT_RANKS19_8`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_RANKS19_8`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_RANKS19_8` AS select `V_STUDENT_MARK_YEAR19_8`.`std` AS `std`,cast((sum(((`V_STUDENT_MARK_YEAR19_8`.`value` * `V_STUDENT_MARK_YEAR19_8`.`weight`) * `V_STUDENT_MARK_YEAR19_8`.`coef`)) / sum((`V_STUDENT_MARK_YEAR19_8`.`weight` * `V_STUDENT_MARK_YEAR19_8`.`coef`))) as decimal(4,2)) AS `moyenne`,sum((`V_STUDENT_MARK_YEAR19_8`.`weight` * `V_STUDENT_MARK_YEAR19_8`.`coef`)) AS `totalCoef` from `V_STUDENT_MARK_YEAR19_8` group by `V_STUDENT_MARK_YEAR19_8`.`std` order by sum(((`V_STUDENT_MARK_YEAR19_8`.`value` * `V_STUDENT_MARK_YEAR19_8`.`weight`) * `V_STUDENT_MARK_YEAR19_8`.`coef`)) desc */;

--
-- Final view structure for view `V_STUDENT_RANKS1_8`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_RANKS1_8`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_RANKS1_8` AS select `V_STUDENT_MARK_YEAR1_8`.`std` AS `std`,cast((sum(((`V_STUDENT_MARK_YEAR1_8`.`value` * `V_STUDENT_MARK_YEAR1_8`.`weight`) * `V_STUDENT_MARK_YEAR1_8`.`coef`)) / sum((`V_STUDENT_MARK_YEAR1_8`.`weight` * `V_STUDENT_MARK_YEAR1_8`.`coef`))) as decimal(4,2)) AS `moyenne`,sum((`V_STUDENT_MARK_YEAR1_8`.`weight` * `V_STUDENT_MARK_YEAR1_8`.`coef`)) AS `totalCoef` from `V_STUDENT_MARK_YEAR1_8` group by `V_STUDENT_MARK_YEAR1_8`.`std` order by sum(((`V_STUDENT_MARK_YEAR1_8`.`value` * `V_STUDENT_MARK_YEAR1_8`.`weight`) * `V_STUDENT_MARK_YEAR1_8`.`coef`)) desc */;

--
-- Final view structure for view `V_STUDENT_RANKS20_8`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_RANKS20_8`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_RANKS20_8` AS select `V_STUDENT_MARK_YEAR20_8`.`std` AS `std`,cast((sum(((`V_STUDENT_MARK_YEAR20_8`.`value` * `V_STUDENT_MARK_YEAR20_8`.`weight`) * `V_STUDENT_MARK_YEAR20_8`.`coef`)) / sum((`V_STUDENT_MARK_YEAR20_8`.`weight` * `V_STUDENT_MARK_YEAR20_8`.`coef`))) as decimal(4,2)) AS `moyenne`,sum((`V_STUDENT_MARK_YEAR20_8`.`weight` * `V_STUDENT_MARK_YEAR20_8`.`coef`)) AS `totalCoef` from `V_STUDENT_MARK_YEAR20_8` group by `V_STUDENT_MARK_YEAR20_8`.`std` order by sum(((`V_STUDENT_MARK_YEAR20_8`.`value` * `V_STUDENT_MARK_YEAR20_8`.`weight`) * `V_STUDENT_MARK_YEAR20_8`.`coef`)) desc */;

--
-- Final view structure for view `V_STUDENT_RANKS21_8`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_RANKS21_8`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_RANKS21_8` AS select `V_STUDENT_MARK_YEAR21_8`.`std` AS `std`,cast((sum(((`V_STUDENT_MARK_YEAR21_8`.`value` * `V_STUDENT_MARK_YEAR21_8`.`weight`) * `V_STUDENT_MARK_YEAR21_8`.`coef`)) / sum((`V_STUDENT_MARK_YEAR21_8`.`weight` * `V_STUDENT_MARK_YEAR21_8`.`coef`))) as decimal(4,2)) AS `moyenne`,sum((`V_STUDENT_MARK_YEAR21_8`.`weight` * `V_STUDENT_MARK_YEAR21_8`.`coef`)) AS `totalCoef` from `V_STUDENT_MARK_YEAR21_8` group by `V_STUDENT_MARK_YEAR21_8`.`std` order by sum(((`V_STUDENT_MARK_YEAR21_8`.`value` * `V_STUDENT_MARK_YEAR21_8`.`weight`) * `V_STUDENT_MARK_YEAR21_8`.`coef`)) desc */;

--
-- Final view structure for view `V_STUDENT_RANKS23_8`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_RANKS23_8`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_RANKS23_8` AS select `V_STUDENT_MARK_YEAR23_8`.`std` AS `std`,cast((sum(((`V_STUDENT_MARK_YEAR23_8`.`value` * `V_STUDENT_MARK_YEAR23_8`.`weight`) * `V_STUDENT_MARK_YEAR23_8`.`coef`)) / sum((`V_STUDENT_MARK_YEAR23_8`.`weight` * `V_STUDENT_MARK_YEAR23_8`.`coef`))) as decimal(4,2)) AS `moyenne`,sum((`V_STUDENT_MARK_YEAR23_8`.`weight` * `V_STUDENT_MARK_YEAR23_8`.`coef`)) AS `totalCoef` from `V_STUDENT_MARK_YEAR23_8` group by `V_STUDENT_MARK_YEAR23_8`.`std` order by sum(((`V_STUDENT_MARK_YEAR23_8`.`value` * `V_STUDENT_MARK_YEAR23_8`.`weight`) * `V_STUDENT_MARK_YEAR23_8`.`coef`)) desc */;

--
-- Final view structure for view `V_STUDENT_RANKS24_8`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_RANKS24_8`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_RANKS24_8` AS select `V_STUDENT_MARK_YEAR24_8`.`std` AS `std`,cast((sum(((`V_STUDENT_MARK_YEAR24_8`.`value` * `V_STUDENT_MARK_YEAR24_8`.`weight`) * `V_STUDENT_MARK_YEAR24_8`.`coef`)) / sum((`V_STUDENT_MARK_YEAR24_8`.`weight` * `V_STUDENT_MARK_YEAR24_8`.`coef`))) as decimal(4,2)) AS `moyenne`,sum((`V_STUDENT_MARK_YEAR24_8`.`weight` * `V_STUDENT_MARK_YEAR24_8`.`coef`)) AS `totalCoef` from `V_STUDENT_MARK_YEAR24_8` group by `V_STUDENT_MARK_YEAR24_8`.`std` order by sum(((`V_STUDENT_MARK_YEAR24_8`.`value` * `V_STUDENT_MARK_YEAR24_8`.`weight`) * `V_STUDENT_MARK_YEAR24_8`.`coef`)) desc */;

--
-- Final view structure for view `V_STUDENT_RANKS25_8`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_RANKS25_8`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_RANKS25_8` AS select `V_STUDENT_MARK_YEAR25_8`.`std` AS `std`,cast((sum(((`V_STUDENT_MARK_YEAR25_8`.`value` * `V_STUDENT_MARK_YEAR25_8`.`weight`) * `V_STUDENT_MARK_YEAR25_8`.`coef`)) / sum((`V_STUDENT_MARK_YEAR25_8`.`weight` * `V_STUDENT_MARK_YEAR25_8`.`coef`))) as decimal(4,2)) AS `moyenne`,sum((`V_STUDENT_MARK_YEAR25_8`.`weight` * `V_STUDENT_MARK_YEAR25_8`.`coef`)) AS `totalCoef` from `V_STUDENT_MARK_YEAR25_8` group by `V_STUDENT_MARK_YEAR25_8`.`std` order by sum(((`V_STUDENT_MARK_YEAR25_8`.`value` * `V_STUDENT_MARK_YEAR25_8`.`weight`) * `V_STUDENT_MARK_YEAR25_8`.`coef`)) desc */;

--
-- Final view structure for view `V_STUDENT_RANKS26_8`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_RANKS26_8`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_RANKS26_8` AS select `V_STUDENT_MARK_YEAR26_8`.`std` AS `std`,cast((sum(((`V_STUDENT_MARK_YEAR26_8`.`value` * `V_STUDENT_MARK_YEAR26_8`.`weight`) * `V_STUDENT_MARK_YEAR26_8`.`coef`)) / sum((`V_STUDENT_MARK_YEAR26_8`.`weight` * `V_STUDENT_MARK_YEAR26_8`.`coef`))) as decimal(4,2)) AS `moyenne`,sum((`V_STUDENT_MARK_YEAR26_8`.`weight` * `V_STUDENT_MARK_YEAR26_8`.`coef`)) AS `totalCoef` from `V_STUDENT_MARK_YEAR26_8` group by `V_STUDENT_MARK_YEAR26_8`.`std` order by sum(((`V_STUDENT_MARK_YEAR26_8`.`value` * `V_STUDENT_MARK_YEAR26_8`.`weight`) * `V_STUDENT_MARK_YEAR26_8`.`coef`)) desc */;

--
-- Final view structure for view `V_STUDENT_RANKS27_8`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_RANKS27_8`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_RANKS27_8` AS select `V_STUDENT_MARK_YEAR27_8`.`std` AS `std`,cast((sum(((`V_STUDENT_MARK_YEAR27_8`.`value` * `V_STUDENT_MARK_YEAR27_8`.`weight`) * `V_STUDENT_MARK_YEAR27_8`.`coef`)) / sum((`V_STUDENT_MARK_YEAR27_8`.`weight` * `V_STUDENT_MARK_YEAR27_8`.`coef`))) as decimal(4,2)) AS `moyenne`,sum((`V_STUDENT_MARK_YEAR27_8`.`weight` * `V_STUDENT_MARK_YEAR27_8`.`coef`)) AS `totalCoef` from `V_STUDENT_MARK_YEAR27_8` group by `V_STUDENT_MARK_YEAR27_8`.`std` order by sum(((`V_STUDENT_MARK_YEAR27_8`.`value` * `V_STUDENT_MARK_YEAR27_8`.`weight`) * `V_STUDENT_MARK_YEAR27_8`.`coef`)) desc */;

--
-- Final view structure for view `V_STUDENT_RANKS28_8`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_RANKS28_8`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_RANKS28_8` AS select `V_STUDENT_MARK_YEAR28_8`.`std` AS `std`,cast((sum(((`V_STUDENT_MARK_YEAR28_8`.`value` * `V_STUDENT_MARK_YEAR28_8`.`weight`) * `V_STUDENT_MARK_YEAR28_8`.`coef`)) / sum((`V_STUDENT_MARK_YEAR28_8`.`weight` * `V_STUDENT_MARK_YEAR28_8`.`coef`))) as decimal(4,2)) AS `moyenne`,sum((`V_STUDENT_MARK_YEAR28_8`.`weight` * `V_STUDENT_MARK_YEAR28_8`.`coef`)) AS `totalCoef` from `V_STUDENT_MARK_YEAR28_8` group by `V_STUDENT_MARK_YEAR28_8`.`std` order by sum(((`V_STUDENT_MARK_YEAR28_8`.`value` * `V_STUDENT_MARK_YEAR28_8`.`weight`) * `V_STUDENT_MARK_YEAR28_8`.`coef`)) desc */;

--
-- Final view structure for view `V_STUDENT_RANKS29_8`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_RANKS29_8`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_RANKS29_8` AS select `V_STUDENT_MARK_YEAR29_8`.`std` AS `std`,cast((sum(((`V_STUDENT_MARK_YEAR29_8`.`value` * `V_STUDENT_MARK_YEAR29_8`.`weight`) * `V_STUDENT_MARK_YEAR29_8`.`coef`)) / sum((`V_STUDENT_MARK_YEAR29_8`.`weight` * `V_STUDENT_MARK_YEAR29_8`.`coef`))) as decimal(4,2)) AS `moyenne`,sum((`V_STUDENT_MARK_YEAR29_8`.`weight` * `V_STUDENT_MARK_YEAR29_8`.`coef`)) AS `totalCoef` from `V_STUDENT_MARK_YEAR29_8` group by `V_STUDENT_MARK_YEAR29_8`.`std` order by sum(((`V_STUDENT_MARK_YEAR29_8`.`value` * `V_STUDENT_MARK_YEAR29_8`.`weight`) * `V_STUDENT_MARK_YEAR29_8`.`coef`)) desc */;

--
-- Final view structure for view `V_STUDENT_RANKS2_8`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_RANKS2_8`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_RANKS2_8` AS select `V_STUDENT_MARK_YEAR2_8`.`std` AS `std`,cast((sum(((`V_STUDENT_MARK_YEAR2_8`.`value` * `V_STUDENT_MARK_YEAR2_8`.`weight`) * `V_STUDENT_MARK_YEAR2_8`.`coef`)) / sum((`V_STUDENT_MARK_YEAR2_8`.`weight` * `V_STUDENT_MARK_YEAR2_8`.`coef`))) as decimal(4,2)) AS `moyenne`,sum((`V_STUDENT_MARK_YEAR2_8`.`weight` * `V_STUDENT_MARK_YEAR2_8`.`coef`)) AS `totalCoef` from `V_STUDENT_MARK_YEAR2_8` group by `V_STUDENT_MARK_YEAR2_8`.`std` order by sum(((`V_STUDENT_MARK_YEAR2_8`.`value` * `V_STUDENT_MARK_YEAR2_8`.`weight`) * `V_STUDENT_MARK_YEAR2_8`.`coef`)) desc */;

--
-- Final view structure for view `V_STUDENT_RANKS30_8`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_RANKS30_8`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_RANKS30_8` AS select `V_STUDENT_MARK_YEAR30_8`.`std` AS `std`,cast((sum(((`V_STUDENT_MARK_YEAR30_8`.`value` * `V_STUDENT_MARK_YEAR30_8`.`weight`) * `V_STUDENT_MARK_YEAR30_8`.`coef`)) / sum((`V_STUDENT_MARK_YEAR30_8`.`weight` * `V_STUDENT_MARK_YEAR30_8`.`coef`))) as decimal(4,2)) AS `moyenne`,sum((`V_STUDENT_MARK_YEAR30_8`.`weight` * `V_STUDENT_MARK_YEAR30_8`.`coef`)) AS `totalCoef` from `V_STUDENT_MARK_YEAR30_8` group by `V_STUDENT_MARK_YEAR30_8`.`std` order by sum(((`V_STUDENT_MARK_YEAR30_8`.`value` * `V_STUDENT_MARK_YEAR30_8`.`weight`) * `V_STUDENT_MARK_YEAR30_8`.`coef`)) desc */;

--
-- Final view structure for view `V_STUDENT_RANKS3_8`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_RANKS3_8`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_RANKS3_8` AS select `V_STUDENT_MARK_YEAR3_8`.`std` AS `std`,cast((sum(((`V_STUDENT_MARK_YEAR3_8`.`value` * `V_STUDENT_MARK_YEAR3_8`.`weight`) * `V_STUDENT_MARK_YEAR3_8`.`coef`)) / sum((`V_STUDENT_MARK_YEAR3_8`.`weight` * `V_STUDENT_MARK_YEAR3_8`.`coef`))) as decimal(4,2)) AS `moyenne`,sum((`V_STUDENT_MARK_YEAR3_8`.`weight` * `V_STUDENT_MARK_YEAR3_8`.`coef`)) AS `totalCoef` from `V_STUDENT_MARK_YEAR3_8` group by `V_STUDENT_MARK_YEAR3_8`.`std` order by sum(((`V_STUDENT_MARK_YEAR3_8`.`value` * `V_STUDENT_MARK_YEAR3_8`.`weight`) * `V_STUDENT_MARK_YEAR3_8`.`coef`)) desc */;

--
-- Final view structure for view `V_STUDENT_RANKS4_8`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_RANKS4_8`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_RANKS4_8` AS select `V_STUDENT_MARK_YEAR4_8`.`std` AS `std`,cast((sum(((`V_STUDENT_MARK_YEAR4_8`.`value` * `V_STUDENT_MARK_YEAR4_8`.`weight`) * `V_STUDENT_MARK_YEAR4_8`.`coef`)) / sum((`V_STUDENT_MARK_YEAR4_8`.`weight` * `V_STUDENT_MARK_YEAR4_8`.`coef`))) as decimal(4,2)) AS `moyenne`,sum((`V_STUDENT_MARK_YEAR4_8`.`weight` * `V_STUDENT_MARK_YEAR4_8`.`coef`)) AS `totalCoef` from `V_STUDENT_MARK_YEAR4_8` group by `V_STUDENT_MARK_YEAR4_8`.`std` order by sum(((`V_STUDENT_MARK_YEAR4_8`.`value` * `V_STUDENT_MARK_YEAR4_8`.`weight`) * `V_STUDENT_MARK_YEAR4_8`.`coef`)) desc */;

--
-- Final view structure for view `V_STUDENT_RANKS5_8`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_RANKS5_8`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_RANKS5_8` AS select `V_STUDENT_MARK_YEAR5_8`.`std` AS `std`,cast((sum(((`V_STUDENT_MARK_YEAR5_8`.`value` * `V_STUDENT_MARK_YEAR5_8`.`weight`) * `V_STUDENT_MARK_YEAR5_8`.`coef`)) / sum((`V_STUDENT_MARK_YEAR5_8`.`weight` * `V_STUDENT_MARK_YEAR5_8`.`coef`))) as decimal(4,2)) AS `moyenne`,sum((`V_STUDENT_MARK_YEAR5_8`.`weight` * `V_STUDENT_MARK_YEAR5_8`.`coef`)) AS `totalCoef` from `V_STUDENT_MARK_YEAR5_8` group by `V_STUDENT_MARK_YEAR5_8`.`std` order by sum(((`V_STUDENT_MARK_YEAR5_8`.`value` * `V_STUDENT_MARK_YEAR5_8`.`weight`) * `V_STUDENT_MARK_YEAR5_8`.`coef`)) desc */;

--
-- Final view structure for view `V_STUDENT_RANKS6_8`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_RANKS6_8`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_RANKS6_8` AS select `V_STUDENT_MARK_YEAR6_8`.`std` AS `std`,cast((sum(((`V_STUDENT_MARK_YEAR6_8`.`value` * `V_STUDENT_MARK_YEAR6_8`.`weight`) * `V_STUDENT_MARK_YEAR6_8`.`coef`)) / sum((`V_STUDENT_MARK_YEAR6_8`.`weight` * `V_STUDENT_MARK_YEAR6_8`.`coef`))) as decimal(4,2)) AS `moyenne`,sum((`V_STUDENT_MARK_YEAR6_8`.`weight` * `V_STUDENT_MARK_YEAR6_8`.`coef`)) AS `totalCoef` from `V_STUDENT_MARK_YEAR6_8` group by `V_STUDENT_MARK_YEAR6_8`.`std` order by sum(((`V_STUDENT_MARK_YEAR6_8`.`value` * `V_STUDENT_MARK_YEAR6_8`.`weight`) * `V_STUDENT_MARK_YEAR6_8`.`coef`)) desc */;

--
-- Final view structure for view `V_STUDENT_RANKS7_8`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_RANKS7_8`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_RANKS7_8` AS select `V_STUDENT_MARK_YEAR7_8`.`std` AS `std`,cast((sum(((`V_STUDENT_MARK_YEAR7_8`.`value` * `V_STUDENT_MARK_YEAR7_8`.`weight`) * `V_STUDENT_MARK_YEAR7_8`.`coef`)) / sum((`V_STUDENT_MARK_YEAR7_8`.`weight` * `V_STUDENT_MARK_YEAR7_8`.`coef`))) as decimal(4,2)) AS `moyenne`,sum((`V_STUDENT_MARK_YEAR7_8`.`weight` * `V_STUDENT_MARK_YEAR7_8`.`coef`)) AS `totalCoef` from `V_STUDENT_MARK_YEAR7_8` group by `V_STUDENT_MARK_YEAR7_8`.`std` order by sum(((`V_STUDENT_MARK_YEAR7_8`.`value` * `V_STUDENT_MARK_YEAR7_8`.`weight`) * `V_STUDENT_MARK_YEAR7_8`.`coef`)) desc */;

--
-- Final view structure for view `V_STUDENT_RANKS8_8`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_RANKS8_8`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_RANKS8_8` AS select `V_STUDENT_MARK_YEAR8_8`.`std` AS `std`,cast((sum(((`V_STUDENT_MARK_YEAR8_8`.`value` * `V_STUDENT_MARK_YEAR8_8`.`weight`) * `V_STUDENT_MARK_YEAR8_8`.`coef`)) / sum((`V_STUDENT_MARK_YEAR8_8`.`weight` * `V_STUDENT_MARK_YEAR8_8`.`coef`))) as decimal(4,2)) AS `moyenne`,sum((`V_STUDENT_MARK_YEAR8_8`.`weight` * `V_STUDENT_MARK_YEAR8_8`.`coef`)) AS `totalCoef` from `V_STUDENT_MARK_YEAR8_8` group by `V_STUDENT_MARK_YEAR8_8`.`std` order by sum(((`V_STUDENT_MARK_YEAR8_8`.`value` * `V_STUDENT_MARK_YEAR8_8`.`weight`) * `V_STUDENT_MARK_YEAR8_8`.`coef`)) desc */;

--
-- Final view structure for view `V_STUDENT_RANKS9_8`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_RANKS9_8`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_RANKS9_8` AS select `V_STUDENT_MARK_YEAR9_8`.`std` AS `std`,cast((sum(((`V_STUDENT_MARK_YEAR9_8`.`value` * `V_STUDENT_MARK_YEAR9_8`.`weight`) * `V_STUDENT_MARK_YEAR9_8`.`coef`)) / sum((`V_STUDENT_MARK_YEAR9_8`.`weight` * `V_STUDENT_MARK_YEAR9_8`.`coef`))) as decimal(4,2)) AS `moyenne`,sum((`V_STUDENT_MARK_YEAR9_8`.`weight` * `V_STUDENT_MARK_YEAR9_8`.`coef`)) AS `totalCoef` from `V_STUDENT_MARK_YEAR9_8` group by `V_STUDENT_MARK_YEAR9_8`.`std` order by sum(((`V_STUDENT_MARK_YEAR9_8`.`value` * `V_STUDENT_MARK_YEAR9_8`.`weight`) * `V_STUDENT_MARK_YEAR9_8`.`coef`)) desc */;


