
--
-- 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`*/;

--
-- 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`*/;

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

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_YEAR12_8`*/;

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

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_YEAR13_8`*/;

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

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_YEAR14_8`*/;

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

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_YEAR15_8`*/;

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

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_YEAR16_8`*/;

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

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_YEAR17_8`*/;

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

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_YEAR18_8`*/;

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

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_YEAR19_8`*/;

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

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_YEAR1_8`*/;

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

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_YEAR20_8`*/;

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

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_YEAR21_8`*/;

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

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_YEAR23_8`*/;

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

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_YEAR24_8`*/;

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

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_YEAR25_8`*/;

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

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_YEAR26_8`*/;

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

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_YEAR27_8`*/;

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

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_YEAR28_8`*/;

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

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_YEAR29_8`*/;

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

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_YEAR2_8`*/;

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

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_YEAR30_8`*/;

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

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_YEAR3_8`*/;

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

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_YEAR4_8`*/;

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

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_YEAR5_8`*/;

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

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_YEAR6_8`*/;

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

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_YEAR7_8`*/;

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

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_YEAR8_8`*/;

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

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_YEAR9_8`*/;

--
-- 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 */;


