/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_ABSCENCE_YEAR16_8` AS select distinct `qt1`.`std` AS `std`,((coalesce(`qt1`.`total_hours`,0) + coalesce(`qt2`.`total_hours`,0)) + coalesce(`qt3`.`total_hours`,0)) AS `total_hours` from ((`V_STUDENT_ABSCENCE_QUATER16_23` `qt1` left join `V_STUDENT_ABSCENCE_QUATER16_24` `qt2` on((`qt1`.`std` = `qt2`.`std`))) left join `V_STUDENT_ABSCENCE_QUATER16_26` `qt3` on((`qt1`.`std` = `qt3`.`std`))) union select distinct `qt2`.`std` AS `std`,((coalesce(`qt1`.`total_hours`,0) + coalesce(`qt2`.`total_hours`,0)) + coalesce(`qt3`.`total_hours`,0)) AS `total_hours` from ((`V_STUDENT_ABSCENCE_QUATER16_24` `qt2` left join `V_STUDENT_ABSCENCE_QUATER16_23` `qt1` on((`qt1`.`std` = `qt2`.`std`))) left join `V_STUDENT_ABSCENCE_QUATER16_26` `qt3` on((`qt2`.`std` = `qt3`.`std`))) union select distinct `qt3`.`std` AS `std`,((coalesce(`qt1`.`total_hours`,0) + coalesce(`qt2`.`total_hours`,0)) + coalesce(`qt3`.`total_hours`,0)) AS `total_hours` from ((`V_STUDENT_ABSCENCE_QUATER16_26` `qt3` left join `V_STUDENT_ABSCENCE_QUATER16_23` `qt1` on((`qt1`.`std` = `qt3`.`std`))) left join `V_STUDENT_ABSCENCE_QUATER16_24` `qt2` on((`qt2`.`std` = `qt3`.`std`))) order by `std` */;

--
-- Final view structure for view `V_STUDENT_ABSCENCE_YEAR19_8`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_ABSCENCE_YEAR19_8`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_ABSCENCE_YEAR19_8` AS select distinct `qt1`.`std` AS `std`,((coalesce(`qt1`.`total_hours`,0) + coalesce(`qt2`.`total_hours`,0)) + coalesce(`qt3`.`total_hours`,0)) AS `total_hours` from ((`V_STUDENT_ABSCENCE_QUATER19_23` `qt1` left join `V_STUDENT_ABSCENCE_QUATER19_24` `qt2` on((`qt1`.`std` = `qt2`.`std`))) left join `V_STUDENT_ABSCENCE_QUATER19_26` `qt3` on((`qt1`.`std` = `qt3`.`std`))) union select distinct `qt2`.`std` AS `std`,((coalesce(`qt1`.`total_hours`,0) + coalesce(`qt2`.`total_hours`,0)) + coalesce(`qt3`.`total_hours`,0)) AS `total_hours` from ((`V_STUDENT_ABSCENCE_QUATER19_24` `qt2` left join `V_STUDENT_ABSCENCE_QUATER19_23` `qt1` on((`qt1`.`std` = `qt2`.`std`))) left join `V_STUDENT_ABSCENCE_QUATER19_26` `qt3` on((`qt2`.`std` = `qt3`.`std`))) union select distinct `qt3`.`std` AS `std`,((coalesce(`qt1`.`total_hours`,0) + coalesce(`qt2`.`total_hours`,0)) + coalesce(`qt3`.`total_hours`,0)) AS `total_hours` from ((`V_STUDENT_ABSCENCE_QUATER19_26` `qt3` left join `V_STUDENT_ABSCENCE_QUATER19_23` `qt1` on((`qt1`.`std` = `qt3`.`std`))) left join `V_STUDENT_ABSCENCE_QUATER19_24` `qt2` on((`qt2`.`std` = `qt3`.`std`))) order by `std` */;

--
-- Final view structure for view `V_STUDENT_ABSCENCE_YEAR21_8`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_ABSCENCE_YEAR21_8`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_ABSCENCE_YEAR21_8` AS select distinct `qt1`.`std` AS `std`,((coalesce(`qt1`.`total_hours`,0) + coalesce(`qt2`.`total_hours`,0)) + coalesce(`qt3`.`total_hours`,0)) AS `total_hours` from ((`V_STUDENT_ABSCENCE_QUATER21_23` `qt1` left join `V_STUDENT_ABSCENCE_QUATER21_24` `qt2` on((`qt1`.`std` = `qt2`.`std`))) left join `V_STUDENT_ABSCENCE_QUATER21_26` `qt3` on((`qt1`.`std` = `qt3`.`std`))) union select distinct `qt2`.`std` AS `std`,((coalesce(`qt1`.`total_hours`,0) + coalesce(`qt2`.`total_hours`,0)) + coalesce(`qt3`.`total_hours`,0)) AS `total_hours` from ((`V_STUDENT_ABSCENCE_QUATER21_24` `qt2` left join `V_STUDENT_ABSCENCE_QUATER21_23` `qt1` on((`qt1`.`std` = `qt2`.`std`))) left join `V_STUDENT_ABSCENCE_QUATER21_26` `qt3` on((`qt2`.`std` = `qt3`.`std`))) union select distinct `qt3`.`std` AS `std`,((coalesce(`qt1`.`total_hours`,0) + coalesce(`qt2`.`total_hours`,0)) + coalesce(`qt3`.`total_hours`,0)) AS `total_hours` from ((`V_STUDENT_ABSCENCE_QUATER21_26` `qt3` left join `V_STUDENT_ABSCENCE_QUATER21_23` `qt1` on((`qt1`.`std` = `qt3`.`std`))) left join `V_STUDENT_ABSCENCE_QUATER21_24` `qt2` on((`qt2`.`std` = `qt3`.`std`))) order by `std` */;

--
-- Final view structure for view `V_STUDENT_ABSCENCE_YEAR30_8`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_ABSCENCE_YEAR30_8`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_ABSCENCE_YEAR30_8` AS select distinct `qt1`.`std` AS `std`,((coalesce(`qt1`.`total_hours`,0) + coalesce(`qt2`.`total_hours`,0)) + coalesce(`qt3`.`total_hours`,0)) AS `total_hours` from ((`V_STUDENT_ABSCENCE_QUATER30_23` `qt1` left join `V_STUDENT_ABSCENCE_QUATER30_24` `qt2` on((`qt1`.`std` = `qt2`.`std`))) left join `V_STUDENT_ABSCENCE_QUATER30_26` `qt3` on((`qt1`.`std` = `qt3`.`std`))) union select distinct `qt2`.`std` AS `std`,((coalesce(`qt1`.`total_hours`,0) + coalesce(`qt2`.`total_hours`,0)) + coalesce(`qt3`.`total_hours`,0)) AS `total_hours` from ((`V_STUDENT_ABSCENCE_QUATER30_24` `qt2` left join `V_STUDENT_ABSCENCE_QUATER30_23` `qt1` on((`qt1`.`std` = `qt2`.`std`))) left join `V_STUDENT_ABSCENCE_QUATER30_26` `qt3` on((`qt2`.`std` = `qt3`.`std`))) union select distinct `qt3`.`std` AS `std`,((coalesce(`qt1`.`total_hours`,0) + coalesce(`qt2`.`total_hours`,0)) + coalesce(`qt3`.`total_hours`,0)) AS `total_hours` from ((`V_STUDENT_ABSCENCE_QUATER30_26` `qt3` left join `V_STUDENT_ABSCENCE_QUATER30_23` `qt1` on((`qt1`.`std` = `qt3`.`std`))) left join `V_STUDENT_ABSCENCE_QUATER30_24` `qt2` on((`qt2`.`std` = `qt3`.`std`))) order by `std` */;

--
-- Final view structure for view `V_STUDENT_ABSCENCE_YEAR5_8`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_ABSCENCE_YEAR5_8`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_ABSCENCE_YEAR5_8` AS select distinct `qt1`.`std` AS `std`,((coalesce(`qt1`.`total_hours`,0) + coalesce(`qt2`.`total_hours`,0)) + coalesce(`qt3`.`total_hours`,0)) AS `total_hours` from ((`V_STUDENT_ABSCENCE_QUATER5_23` `qt1` left join `V_STUDENT_ABSCENCE_QUATER5_24` `qt2` on((`qt1`.`std` = `qt2`.`std`))) left join `V_STUDENT_ABSCENCE_QUATER5_26` `qt3` on((`qt1`.`std` = `qt3`.`std`))) union select distinct `qt2`.`std` AS `std`,((coalesce(`qt1`.`total_hours`,0) + coalesce(`qt2`.`total_hours`,0)) + coalesce(`qt3`.`total_hours`,0)) AS `total_hours` from ((`V_STUDENT_ABSCENCE_QUATER5_24` `qt2` left join `V_STUDENT_ABSCENCE_QUATER5_23` `qt1` on((`qt1`.`std` = `qt2`.`std`))) left join `V_STUDENT_ABSCENCE_QUATER5_26` `qt3` on((`qt2`.`std` = `qt3`.`std`))) union select distinct `qt3`.`std` AS `std`,((coalesce(`qt1`.`total_hours`,0) + coalesce(`qt2`.`total_hours`,0)) + coalesce(`qt3`.`total_hours`,0)) AS `total_hours` from ((`V_STUDENT_ABSCENCE_QUATER5_26` `qt3` left join `V_STUDENT_ABSCENCE_QUATER5_23` `qt1` on((`qt1`.`std` = `qt3`.`std`))) left join `V_STUDENT_ABSCENCE_QUATER5_24` `qt2` on((`qt2`.`std` = `qt3`.`std`))) order by `std` */;

--
-- Final view structure for view `V_STUDENT_ABSCENCE_YEAR6_8`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_ABSCENCE_YEAR6_8`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_ABSCENCE_YEAR6_8` AS select distinct `qt1`.`std` AS `std`,((coalesce(`qt1`.`total_hours`,0) + coalesce(`qt2`.`total_hours`,0)) + coalesce(`qt3`.`total_hours`,0)) AS `total_hours` from ((`V_STUDENT_ABSCENCE_QUATER6_23` `qt1` left join `V_STUDENT_ABSCENCE_QUATER6_24` `qt2` on((`qt1`.`std` = `qt2`.`std`))) left join `V_STUDENT_ABSCENCE_QUATER6_26` `qt3` on((`qt1`.`std` = `qt3`.`std`))) union select distinct `qt2`.`std` AS `std`,((coalesce(`qt1`.`total_hours`,0) + coalesce(`qt2`.`total_hours`,0)) + coalesce(`qt3`.`total_hours`,0)) AS `total_hours` from ((`V_STUDENT_ABSCENCE_QUATER6_24` `qt2` left join `V_STUDENT_ABSCENCE_QUATER6_23` `qt1` on((`qt1`.`std` = `qt2`.`std`))) left join `V_STUDENT_ABSCENCE_QUATER6_26` `qt3` on((`qt2`.`std` = `qt3`.`std`))) union select distinct `qt3`.`std` AS `std`,((coalesce(`qt1`.`total_hours`,0) + coalesce(`qt2`.`total_hours`,0)) + coalesce(`qt3`.`total_hours`,0)) AS `total_hours` from ((`V_STUDENT_ABSCENCE_QUATER6_26` `qt3` left join `V_STUDENT_ABSCENCE_QUATER6_23` `qt1` on((`qt1`.`std` = `qt3`.`std`))) left join `V_STUDENT_ABSCENCE_QUATER6_24` `qt2` on((`qt2`.`std` = `qt3`.`std`))) order by `std` */;

--
-- Final view structure for view `V_STUDENT_ABSCENCE_YEAR7_8`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_ABSCENCE_YEAR7_8`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_ABSCENCE_YEAR7_8` AS select distinct `qt1`.`std` AS `std`,((coalesce(`qt1`.`total_hours`,0) + coalesce(`qt2`.`total_hours`,0)) + coalesce(`qt3`.`total_hours`,0)) AS `total_hours` from ((`V_STUDENT_ABSCENCE_QUATER7_23` `qt1` left join `V_STUDENT_ABSCENCE_QUATER7_24` `qt2` on((`qt1`.`std` = `qt2`.`std`))) left join `V_STUDENT_ABSCENCE_QUATER7_26` `qt3` on((`qt1`.`std` = `qt3`.`std`))) union select distinct `qt2`.`std` AS `std`,((coalesce(`qt1`.`total_hours`,0) + coalesce(`qt2`.`total_hours`,0)) + coalesce(`qt3`.`total_hours`,0)) AS `total_hours` from ((`V_STUDENT_ABSCENCE_QUATER7_24` `qt2` left join `V_STUDENT_ABSCENCE_QUATER7_23` `qt1` on((`qt1`.`std` = `qt2`.`std`))) left join `V_STUDENT_ABSCENCE_QUATER7_26` `qt3` on((`qt2`.`std` = `qt3`.`std`))) union select distinct `qt3`.`std` AS `std`,((coalesce(`qt1`.`total_hours`,0) + coalesce(`qt2`.`total_hours`,0)) + coalesce(`qt3`.`total_hours`,0)) AS `total_hours` from ((`V_STUDENT_ABSCENCE_QUATER7_26` `qt3` left join `V_STUDENT_ABSCENCE_QUATER7_23` `qt1` on((`qt1`.`std` = `qt3`.`std`))) left join `V_STUDENT_ABSCENCE_QUATER7_24` `qt2` on((`qt2`.`std` = `qt3`.`std`))) order by `std` */;

--
-- Final view structure for view `V_STUDENT_ABSCENCE_YEAR8_8`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_ABSCENCE_YEAR8_8`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_ABSCENCE_YEAR8_8` AS select distinct `qt1`.`std` AS `std`,((coalesce(`qt1`.`total_hours`,0) + coalesce(`qt2`.`total_hours`,0)) + coalesce(`qt3`.`total_hours`,0)) AS `total_hours` from ((`V_STUDENT_ABSCENCE_QUATER8_23` `qt1` left join `V_STUDENT_ABSCENCE_QUATER8_24` `qt2` on((`qt1`.`std` = `qt2`.`std`))) left join `V_STUDENT_ABSCENCE_QUATER8_26` `qt3` on((`qt1`.`std` = `qt3`.`std`))) union select distinct `qt2`.`std` AS `std`,((coalesce(`qt1`.`total_hours`,0) + coalesce(`qt2`.`total_hours`,0)) + coalesce(`qt3`.`total_hours`,0)) AS `total_hours` from ((`V_STUDENT_ABSCENCE_QUATER8_24` `qt2` left join `V_STUDENT_ABSCENCE_QUATER8_23` `qt1` on((`qt1`.`std` = `qt2`.`std`))) left join `V_STUDENT_ABSCENCE_QUATER8_26` `qt3` on((`qt2`.`std` = `qt3`.`std`))) union select distinct `qt3`.`std` AS `std`,((coalesce(`qt1`.`total_hours`,0) + coalesce(`qt2`.`total_hours`,0)) + coalesce(`qt3`.`total_hours`,0)) AS `total_hours` from ((`V_STUDENT_ABSCENCE_QUATER8_26` `qt3` left join `V_STUDENT_ABSCENCE_QUATER8_23` `qt1` on((`qt1`.`std` = `qt3`.`std`))) left join `V_STUDENT_ABSCENCE_QUATER8_24` `qt2` on((`qt2`.`std` = `qt3`.`std`))) order by `std` */;

--
-- Final view structure for view `V_STUDENT_MARK_QUATER`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_QUATER`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_QUATER` AS select distinct `seq1`.`std` AS `std`,`seq1`.`crs` AS `crs`,`seq1`.`coef` AS `coef`,`seq1`.`value` AS `value1`,`seq1`.`weight` AS `weight1`,`seq2`.`value` AS `value2`,`seq2`.`weight` AS `weight2`,(((`seq1`.`value` * `seq1`.`weight`) + (`seq2`.`value` * `seq2`.`weight`)) / (`seq1`.`weight` + `seq2`.`weight`)) AS `value`,greatest(`seq1`.`weight`,`seq2`.`weight`) AS `weight`,((`seq1`.`mini` + `seq2`.`mini`) / 2) AS `mini`,((`seq1`.`maxi` + `seq2`.`maxi`) / 2) AS `maxi` from (`V_STUDENT_MARK_SEQ8_54` `seq1` left join `V_STUDENT_MARK_SEQ8_55` `seq2` on(((`seq1`.`std` = `seq2`.`std`) and (`seq1`.`crs` = `seq2`.`crs`)))) order by `seq1`.`std` */;

--
-- Final view structure for view `V_STUDENT_MARK_QUATER12_23`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_QUATER12_23`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_QUATER12_23` AS select distinct `seq1`.`std` AS `std`,`seq1`.`crs` AS `crs`,`seq1`.`coef` AS `coef`,`seq1`.`value` AS `value1`,`seq1`.`weight` AS `weight1`,`seq2`.`value` AS `value2`,`seq2`.`weight` AS `weight2`,((coalesce((`seq1`.`value` * `seq1`.`weight`),0) + coalesce((`seq2`.`value` * `seq2`.`weight`),0)) / (`seq1`.`weight` + `seq2`.`weight`)) AS `value`,greatest(`seq1`.`weight`,`seq2`.`weight`) AS `weight`,((`seq1`.`mini` + `seq2`.`mini`) / 2) AS `mini`,((`seq1`.`maxi` + `seq2`.`maxi`) / 2) AS `maxi` from (`V_STUDENT_MARK_SEQ12_46` `seq1` left join `V_STUDENT_MARK_SEQ12_47` `seq2` on(((`seq1`.`std` = `seq2`.`std`) and (`seq1`.`crs` = `seq2`.`crs`)))) order by `seq1`.`std` */;

--
-- Final view structure for view `V_STUDENT_MARK_QUATER12_24`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_QUATER12_24`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_QUATER12_24` AS select distinct `seq1`.`std` AS `std`,`seq1`.`crs` AS `crs`,`seq1`.`coef` AS `coef`,`seq1`.`value` AS `value1`,`seq1`.`weight` AS `weight1`,`seq2`.`value` AS `value2`,`seq2`.`weight` AS `weight2`,((coalesce((`seq1`.`value` * `seq1`.`weight`),0) + coalesce((`seq2`.`value` * `seq2`.`weight`),0)) / (`seq1`.`weight` + `seq2`.`weight`)) AS `value`,greatest(`seq1`.`weight`,`seq2`.`weight`) AS `weight`,((`seq1`.`mini` + `seq2`.`mini`) / 2) AS `mini`,((`seq1`.`maxi` + `seq2`.`maxi`) / 2) AS `maxi` from (`V_STUDENT_MARK_SEQ12_51` `seq1` left join `V_STUDENT_MARK_SEQ12_53` `seq2` on(((`seq1`.`std` = `seq2`.`std`) and (`seq1`.`crs` = `seq2`.`crs`)))) order by `seq1`.`std` */;

--
-- Final view structure for view `V_STUDENT_MARK_QUATER12_26`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_QUATER12_26`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_QUATER12_26` AS select distinct `seq1`.`std` AS `std`,`seq1`.`crs` AS `crs`,`seq1`.`coef` AS `coef`,`seq1`.`value` AS `value1`,`seq1`.`weight` AS `weight1`,`seq2`.`value` AS `value2`,`seq2`.`weight` AS `weight2`,((coalesce((`seq1`.`value` * `seq1`.`weight`),0) + coalesce((`seq2`.`value` * `seq2`.`weight`),0)) / (`seq1`.`weight` + `seq2`.`weight`)) AS `value`,greatest(`seq1`.`weight`,`seq2`.`weight`) AS `weight`,((`seq1`.`mini` + `seq2`.`mini`) / 2) AS `mini`,((`seq1`.`maxi` + `seq2`.`maxi`) / 2) AS `maxi` from (`V_STUDENT_MARK_SEQ12_54` `seq1` left join `V_STUDENT_MARK_SEQ12_55` `seq2` on(((`seq1`.`std` = `seq2`.`std`) and (`seq1`.`crs` = `seq2`.`crs`)))) order by `seq1`.`std` */;

--
-- Final view structure for view `V_STUDENT_MARK_QUATER13_26`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_QUATER13_26`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_QUATER13_26` AS select distinct `seq1`.`std` AS `std`,`seq1`.`crs` AS `crs`,`seq1`.`coef` AS `coef`,`seq1`.`value` AS `value1`,`seq1`.`weight` AS `weight1`,`seq2`.`value` AS `value2`,`seq2`.`weight` AS `weight2`,((coalesce((`seq1`.`value` * `seq1`.`weight`),0) + coalesce((`seq2`.`value` * `seq2`.`weight`),0)) / (`seq1`.`weight` + `seq2`.`weight`)) AS `value`,greatest(`seq1`.`weight`,`seq2`.`weight`) AS `weight`,((`seq1`.`mini` + `seq2`.`mini`) / 2) AS `mini`,((`seq1`.`maxi` + `seq2`.`maxi`) / 2) AS `maxi` from (`V_STUDENT_MARK_SEQ13_54` `seq1` left join `V_STUDENT_MARK_SEQ13_55` `seq2` on(((`seq1`.`std` = `seq2`.`std`) and (`seq1`.`crs` = `seq2`.`crs`)))) order by `seq1`.`std` */;

--
-- Final view structure for view `V_STUDENT_MARK_QUATER14_23`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_QUATER14_23`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_QUATER14_23` AS select distinct `seq1`.`std` AS `std`,`seq1`.`crs` AS `crs`,`seq1`.`coef` AS `coef`,`seq1`.`value` AS `value1`,`seq1`.`weight` AS `weight1`,`seq2`.`value` AS `value2`,`seq2`.`weight` AS `weight2`,((coalesce((`seq1`.`value` * `seq1`.`weight`),0) + coalesce((`seq2`.`value` * `seq2`.`weight`),0)) / (`seq1`.`weight` + `seq2`.`weight`)) AS `value`,greatest(`seq1`.`weight`,`seq2`.`weight`) AS `weight`,((`seq1`.`mini` + `seq2`.`mini`) / 2) AS `mini`,((`seq1`.`maxi` + `seq2`.`maxi`) / 2) AS `maxi` from (`V_STUDENT_MARK_SEQ14_46` `seq1` left join `V_STUDENT_MARK_SEQ14_47` `seq2` on(((`seq1`.`std` = `seq2`.`std`) and (`seq1`.`crs` = `seq2`.`crs`)))) order by `seq1`.`std` */;

--
-- Final view structure for view `V_STUDENT_MARK_QUATER14_24`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_QUATER14_24`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_QUATER14_24` AS select distinct `seq1`.`std` AS `std`,`seq1`.`crs` AS `crs`,`seq1`.`coef` AS `coef`,`seq1`.`value` AS `value1`,`seq1`.`weight` AS `weight1`,`seq2`.`value` AS `value2`,`seq2`.`weight` AS `weight2`,((coalesce((`seq1`.`value` * `seq1`.`weight`),0) + coalesce((`seq2`.`value` * `seq2`.`weight`),0)) / (`seq1`.`weight` + `seq2`.`weight`)) AS `value`,greatest(`seq1`.`weight`,`seq2`.`weight`) AS `weight`,((`seq1`.`mini` + `seq2`.`mini`) / 2) AS `mini`,((`seq1`.`maxi` + `seq2`.`maxi`) / 2) AS `maxi` from (`V_STUDENT_MARK_SEQ14_51` `seq1` left join `V_STUDENT_MARK_SEQ14_53` `seq2` on(((`seq1`.`std` = `seq2`.`std`) and (`seq1`.`crs` = `seq2`.`crs`)))) order by `seq1`.`std` */;

--
-- Final view structure for view `V_STUDENT_MARK_QUATER14_26`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_QUATER14_26`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_QUATER14_26` AS select distinct `seq1`.`std` AS `std`,`seq1`.`crs` AS `crs`,`seq1`.`coef` AS `coef`,`seq1`.`value` AS `value1`,`seq1`.`weight` AS `weight1`,`seq2`.`value` AS `value2`,`seq2`.`weight` AS `weight2`,((coalesce((`seq1`.`value` * `seq1`.`weight`),0) + coalesce((`seq2`.`value` * `seq2`.`weight`),0)) / (`seq1`.`weight` + `seq2`.`weight`)) AS `value`,greatest(`seq1`.`weight`,`seq2`.`weight`) AS `weight`,((`seq1`.`mini` + `seq2`.`mini`) / 2) AS `mini`,((`seq1`.`maxi` + `seq2`.`maxi`) / 2) AS `maxi` from (`V_STUDENT_MARK_SEQ14_54` `seq1` left join `V_STUDENT_MARK_SEQ14_55` `seq2` on(((`seq1`.`std` = `seq2`.`std`) and (`seq1`.`crs` = `seq2`.`crs`)))) order by `seq1`.`std` */;

--
-- Final view structure for view `V_STUDENT_MARK_QUATER15_23`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_QUATER15_23`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_QUATER15_23` AS select distinct `seq1`.`std` AS `std`,`seq1`.`crs` AS `crs`,`seq1`.`coef` AS `coef`,`seq1`.`value` AS `value1`,`seq1`.`weight` AS `weight1`,`seq2`.`value` AS `value2`,`seq2`.`weight` AS `weight2`,((coalesce((`seq1`.`value` * `seq1`.`weight`),0) + coalesce((`seq2`.`value` * `seq2`.`weight`),0)) / (`seq1`.`weight` + `seq2`.`weight`)) AS `value`,greatest(`seq1`.`weight`,`seq2`.`weight`) AS `weight`,((`seq1`.`mini` + `seq2`.`mini`) / 2) AS `mini`,((`seq1`.`maxi` + `seq2`.`maxi`) / 2) AS `maxi` from (`V_STUDENT_MARK_SEQ15_46` `seq1` left join `V_STUDENT_MARK_SEQ15_47` `seq2` on(((`seq1`.`std` = `seq2`.`std`) and (`seq1`.`crs` = `seq2`.`crs`)))) order by `seq1`.`std` */;

--
-- Final view structure for view `V_STUDENT_MARK_QUATER15_24`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_QUATER15_24`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_QUATER15_24` AS select distinct `seq1`.`std` AS `std`,`seq1`.`crs` AS `crs`,`seq1`.`coef` AS `coef`,`seq1`.`value` AS `value1`,`seq1`.`weight` AS `weight1`,`seq2`.`value` AS `value2`,`seq2`.`weight` AS `weight2`,((coalesce((`seq1`.`value` * `seq1`.`weight`),0) + coalesce((`seq2`.`value` * `seq2`.`weight`),0)) / (`seq1`.`weight` + `seq2`.`weight`)) AS `value`,greatest(`seq1`.`weight`,`seq2`.`weight`) AS `weight`,((`seq1`.`mini` + `seq2`.`mini`) / 2) AS `mini`,((`seq1`.`maxi` + `seq2`.`maxi`) / 2) AS `maxi` from (`V_STUDENT_MARK_SEQ15_51` `seq1` left join `V_STUDENT_MARK_SEQ15_53` `seq2` on(((`seq1`.`std` = `seq2`.`std`) and (`seq1`.`crs` = `seq2`.`crs`)))) order by `seq1`.`std` */;

--
-- Final view structure for view `V_STUDENT_MARK_QUATER15_26`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_QUATER15_26`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_QUATER15_26` AS select distinct `seq1`.`std` AS `std`,`seq1`.`crs` AS `crs`,`seq1`.`coef` AS `coef`,`seq1`.`value` AS `value1`,`seq1`.`weight` AS `weight1`,`seq2`.`value` AS `value2`,`seq2`.`weight` AS `weight2`,((coalesce((`seq1`.`value` * `seq1`.`weight`),0) + coalesce((`seq2`.`value` * `seq2`.`weight`),0)) / (`seq1`.`weight` + `seq2`.`weight`)) AS `value`,greatest(`seq1`.`weight`,`seq2`.`weight`) AS `weight`,((`seq1`.`mini` + `seq2`.`mini`) / 2) AS `mini`,((`seq1`.`maxi` + `seq2`.`maxi`) / 2) AS `maxi` from (`V_STUDENT_MARK_SEQ15_54` `seq1` left join `V_STUDENT_MARK_SEQ15_55` `seq2` on(((`seq1`.`std` = `seq2`.`std`) and (`seq1`.`crs` = `seq2`.`crs`)))) order by `seq1`.`std` */;

--
-- Final view structure for view `V_STUDENT_MARK_QUATER16_23`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_QUATER16_23`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_QUATER16_23` AS select distinct `seq1`.`std` AS `std`,`seq1`.`crs` AS `crs`,`seq1`.`coef` AS `coef`,`seq1`.`value` AS `value1`,`seq1`.`weight` AS `weight1`,`seq2`.`value` AS `value2`,`seq2`.`weight` AS `weight2`,((coalesce((`seq1`.`value` * `seq1`.`weight`),0) + coalesce((`seq2`.`value` * `seq2`.`weight`),0)) / (`seq1`.`weight` + `seq2`.`weight`)) AS `value`,greatest(`seq1`.`weight`,`seq2`.`weight`) AS `weight`,((`seq1`.`mini` + `seq2`.`mini`) / 2) AS `mini`,((`seq1`.`maxi` + `seq2`.`maxi`) / 2) AS `maxi` from (`V_STUDENT_MARK_SEQ16_46` `seq1` left join `V_STUDENT_MARK_SEQ16_47` `seq2` on(((`seq1`.`std` = `seq2`.`std`) and (`seq1`.`crs` = `seq2`.`crs`)))) order by `seq1`.`std` */;

--
-- Final view structure for view `V_STUDENT_MARK_QUATER16_24`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_QUATER16_24`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_QUATER16_24` AS select distinct `seq1`.`std` AS `std`,`seq1`.`crs` AS `crs`,`seq1`.`coef` AS `coef`,`seq1`.`value` AS `value1`,`seq1`.`weight` AS `weight1`,`seq2`.`value` AS `value2`,`seq2`.`weight` AS `weight2`,((coalesce((`seq1`.`value` * `seq1`.`weight`),0) + coalesce((`seq2`.`value` * `seq2`.`weight`),0)) / (`seq1`.`weight` + `seq2`.`weight`)) AS `value`,greatest(`seq1`.`weight`,`seq2`.`weight`) AS `weight`,((`seq1`.`mini` + `seq2`.`mini`) / 2) AS `mini`,((`seq1`.`maxi` + `seq2`.`maxi`) / 2) AS `maxi` from (`V_STUDENT_MARK_SEQ16_51` `seq1` left join `V_STUDENT_MARK_SEQ16_53` `seq2` on(((`seq1`.`std` = `seq2`.`std`) and (`seq1`.`crs` = `seq2`.`crs`)))) order by `seq1`.`std` */;

--
-- Final view structure for view `V_STUDENT_MARK_QUATER16_26`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_QUATER16_26`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_QUATER16_26` AS select distinct `seq1`.`std` AS `std`,`seq1`.`crs` AS `crs`,`seq1`.`coef` AS `coef`,`seq1`.`value` AS `value1`,`seq1`.`weight` AS `weight1`,`seq2`.`value` AS `value2`,`seq2`.`weight` AS `weight2`,((coalesce((`seq1`.`value` * `seq1`.`weight`),0) + coalesce((`seq2`.`value` * `seq2`.`weight`),0)) / (`seq1`.`weight` + `seq2`.`weight`)) AS `value`,greatest(`seq1`.`weight`,`seq2`.`weight`) AS `weight`,((`seq1`.`mini` + `seq2`.`mini`) / 2) AS `mini`,((`seq1`.`maxi` + `seq2`.`maxi`) / 2) AS `maxi` from (`V_STUDENT_MARK_SEQ16_54` `seq1` left join `V_STUDENT_MARK_SEQ16_55` `seq2` on(((`seq1`.`std` = `seq2`.`std`) and (`seq1`.`crs` = `seq2`.`crs`)))) order by `seq1`.`std` */;

--
-- Final view structure for view `V_STUDENT_MARK_QUATER19_23`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_QUATER19_23`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_QUATER19_23` AS select distinct `seq1`.`std` AS `std`,`seq1`.`crs` AS `crs`,`seq1`.`coef` AS `coef`,`seq1`.`value` AS `value1`,`seq1`.`weight` AS `weight1`,`seq2`.`value` AS `value2`,`seq2`.`weight` AS `weight2`,((coalesce((`seq1`.`value` * `seq1`.`weight`),0) + coalesce((`seq2`.`value` * `seq2`.`weight`),0)) / (`seq1`.`weight` + `seq2`.`weight`)) AS `value`,greatest(`seq1`.`weight`,`seq2`.`weight`) AS `weight`,((`seq1`.`mini` + `seq2`.`mini`) / 2) AS `mini`,((`seq1`.`maxi` + `seq2`.`maxi`) / 2) AS `maxi` from (`V_STUDENT_MARK_SEQ19_46` `seq1` left join `V_STUDENT_MARK_SEQ19_47` `seq2` on(((`seq1`.`std` = `seq2`.`std`) and (`seq1`.`crs` = `seq2`.`crs`)))) order by `seq1`.`std` */;

--
-- Final view structure for view `V_STUDENT_MARK_QUATER19_24`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_QUATER19_24`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_QUATER19_24` AS select distinct `seq1`.`std` AS `std`,`seq1`.`crs` AS `crs`,`seq1`.`coef` AS `coef`,`seq1`.`value` AS `value1`,`seq1`.`weight` AS `weight1`,`seq2`.`value` AS `value2`,`seq2`.`weight` AS `weight2`,((coalesce((`seq1`.`value` * `seq1`.`weight`),0) + coalesce((`seq2`.`value` * `seq2`.`weight`),0)) / (`seq1`.`weight` + `seq2`.`weight`)) AS `value`,greatest(`seq1`.`weight`,`seq2`.`weight`) AS `weight`,((`seq1`.`mini` + `seq2`.`mini`) / 2) AS `mini`,((`seq1`.`maxi` + `seq2`.`maxi`) / 2) AS `maxi` from (`V_STUDENT_MARK_SEQ19_51` `seq1` left join `V_STUDENT_MARK_SEQ19_53` `seq2` on(((`seq1`.`std` = `seq2`.`std`) and (`seq1`.`crs` = `seq2`.`crs`)))) order by `seq1`.`std` */;

--
-- Final view structure for view `V_STUDENT_MARK_QUATER19_26`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_QUATER19_26`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_QUATER19_26` AS select distinct `seq1`.`std` AS `std`,`seq1`.`crs` AS `crs`,`seq1`.`coef` AS `coef`,`seq1`.`value` AS `value1`,`seq1`.`weight` AS `weight1`,`seq2`.`value` AS `value2`,`seq2`.`weight` AS `weight2`,((coalesce((`seq1`.`value` * `seq1`.`weight`),0) + coalesce((`seq2`.`value` * `seq2`.`weight`),0)) / (`seq1`.`weight` + `seq2`.`weight`)) AS `value`,greatest(`seq1`.`weight`,`seq2`.`weight`) AS `weight`,((`seq1`.`mini` + `seq2`.`mini`) / 2) AS `mini`,((`seq1`.`maxi` + `seq2`.`maxi`) / 2) AS `maxi` from (`V_STUDENT_MARK_SEQ19_54` `seq1` left join `V_STUDENT_MARK_SEQ19_55` `seq2` on(((`seq1`.`std` = `seq2`.`std`) and (`seq1`.`crs` = `seq2`.`crs`)))) order by `seq1`.`std` */;

--
-- Final view structure for view `V_STUDENT_MARK_QUATER1_23`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_QUATER1_23`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_QUATER1_23` AS select distinct `seq1`.`std` AS `std`,`seq1`.`crs` AS `crs`,`seq1`.`coef` AS `coef`,`seq1`.`value` AS `value1`,`seq1`.`weight` AS `weight1`,`seq2`.`value` AS `value2`,`seq2`.`weight` AS `weight2`,((coalesce((`seq1`.`value` * `seq1`.`weight`),0) + coalesce((`seq2`.`value` * `seq2`.`weight`),0)) / (`seq1`.`weight` + `seq2`.`weight`)) AS `value`,greatest(`seq1`.`weight`,`seq2`.`weight`) AS `weight`,((`seq1`.`mini` + `seq2`.`mini`) / 2) AS `mini`,((`seq1`.`maxi` + `seq2`.`maxi`) / 2) AS `maxi` from (`V_STUDENT_MARK_SEQ1_46` `seq1` left join `V_STUDENT_MARK_SEQ1_47` `seq2` on(((`seq1`.`std` = `seq2`.`std`) and (`seq1`.`crs` = `seq2`.`crs`)))) order by `seq1`.`std` */;

--
-- Final view structure for view `V_STUDENT_MARK_QUATER1_24`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_QUATER1_24`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_QUATER1_24` AS select distinct `seq1`.`std` AS `std`,`seq1`.`crs` AS `crs`,`seq1`.`coef` AS `coef`,`seq1`.`value` AS `value1`,`seq1`.`weight` AS `weight1`,`seq2`.`value` AS `value2`,`seq2`.`weight` AS `weight2`,((coalesce((`seq1`.`value` * `seq1`.`weight`),0) + coalesce((`seq2`.`value` * `seq2`.`weight`),0)) / (`seq1`.`weight` + `seq2`.`weight`)) AS `value`,greatest(`seq1`.`weight`,`seq2`.`weight`) AS `weight`,((`seq1`.`mini` + `seq2`.`mini`) / 2) AS `mini`,((`seq1`.`maxi` + `seq2`.`maxi`) / 2) AS `maxi` from (`V_STUDENT_MARK_SEQ1_51` `seq1` left join `V_STUDENT_MARK_SEQ1_53` `seq2` on(((`seq1`.`std` = `seq2`.`std`) and (`seq1`.`crs` = `seq2`.`crs`)))) order by `seq1`.`std` */;

--
-- Final view structure for view `V_STUDENT_MARK_QUATER20_23`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_QUATER20_23`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_QUATER20_23` AS select distinct `seq1`.`std` AS `std`,`seq1`.`crs` AS `crs`,`seq1`.`coef` AS `coef`,`seq1`.`value` AS `value1`,`seq1`.`weight` AS `weight1`,`seq2`.`value` AS `value2`,`seq2`.`weight` AS `weight2`,((coalesce((`seq1`.`value` * `seq1`.`weight`),0) + coalesce((`seq2`.`value` * `seq2`.`weight`),0)) / (`seq1`.`weight` + `seq2`.`weight`)) AS `value`,greatest(`seq1`.`weight`,`seq2`.`weight`) AS `weight`,((`seq1`.`mini` + `seq2`.`mini`) / 2) AS `mini`,((`seq1`.`maxi` + `seq2`.`maxi`) / 2) AS `maxi` from (`V_STUDENT_MARK_SEQ20_46` `seq1` left join `V_STUDENT_MARK_SEQ20_47` `seq2` on(((`seq1`.`std` = `seq2`.`std`) and (`seq1`.`crs` = `seq2`.`crs`)))) order by `seq1`.`std` */;

--
-- Final view structure for view `V_STUDENT_MARK_QUATER20_24`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_QUATER20_24`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_QUATER20_24` AS select distinct `seq1`.`std` AS `std`,`seq1`.`crs` AS `crs`,`seq1`.`coef` AS `coef`,`seq1`.`value` AS `value1`,`seq1`.`weight` AS `weight1`,`seq2`.`value` AS `value2`,`seq2`.`weight` AS `weight2`,((coalesce((`seq1`.`value` * `seq1`.`weight`),0) + coalesce((`seq2`.`value` * `seq2`.`weight`),0)) / (`seq1`.`weight` + `seq2`.`weight`)) AS `value`,greatest(`seq1`.`weight`,`seq2`.`weight`) AS `weight`,((`seq1`.`mini` + `seq2`.`mini`) / 2) AS `mini`,((`seq1`.`maxi` + `seq2`.`maxi`) / 2) AS `maxi` from (`V_STUDENT_MARK_SEQ20_51` `seq1` left join `V_STUDENT_MARK_SEQ20_53` `seq2` on(((`seq1`.`std` = `seq2`.`std`) and (`seq1`.`crs` = `seq2`.`crs`)))) order by `seq1`.`std` */;

--
-- Final view structure for view `V_STUDENT_MARK_QUATER21_23`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_QUATER21_23`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_QUATER21_23` AS select distinct `seq1`.`std` AS `std`,`seq1`.`crs` AS `crs`,`seq1`.`coef` AS `coef`,`seq1`.`value` AS `value1`,`seq1`.`weight` AS `weight1`,`seq2`.`value` AS `value2`,`seq2`.`weight` AS `weight2`,((coalesce((`seq1`.`value` * `seq1`.`weight`),0) + coalesce((`seq2`.`value` * `seq2`.`weight`),0)) / (`seq1`.`weight` + `seq2`.`weight`)) AS `value`,greatest(`seq1`.`weight`,`seq2`.`weight`) AS `weight`,((`seq1`.`mini` + `seq2`.`mini`) / 2) AS `mini`,((`seq1`.`maxi` + `seq2`.`maxi`) / 2) AS `maxi` from (`V_STUDENT_MARK_SEQ21_46` `seq1` left join `V_STUDENT_MARK_SEQ21_47` `seq2` on(((`seq1`.`std` = `seq2`.`std`) and (`seq1`.`crs` = `seq2`.`crs`)))) order by `seq1`.`std` */;

--
-- Final view structure for view `V_STUDENT_MARK_QUATER21_24`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_QUATER21_24`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_QUATER21_24` AS select distinct `seq1`.`std` AS `std`,`seq1`.`crs` AS `crs`,`seq1`.`coef` AS `coef`,`seq1`.`value` AS `value1`,`seq1`.`weight` AS `weight1`,`seq2`.`value` AS `value2`,`seq2`.`weight` AS `weight2`,((coalesce((`seq1`.`value` * `seq1`.`weight`),0) + coalesce((`seq2`.`value` * `seq2`.`weight`),0)) / (`seq1`.`weight` + `seq2`.`weight`)) AS `value`,greatest(`seq1`.`weight`,`seq2`.`weight`) AS `weight`,((`seq1`.`mini` + `seq2`.`mini`) / 2) AS `mini`,((`seq1`.`maxi` + `seq2`.`maxi`) / 2) AS `maxi` from (`V_STUDENT_MARK_SEQ21_51` `seq1` left join `V_STUDENT_MARK_SEQ21_53` `seq2` on(((`seq1`.`std` = `seq2`.`std`) and (`seq1`.`crs` = `seq2`.`crs`)))) order by `seq1`.`std` */;

--
-- Final view structure for view `V_STUDENT_MARK_QUATER21_26`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_QUATER21_26`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_QUATER21_26` AS select distinct `seq1`.`std` AS `std`,`seq1`.`crs` AS `crs`,`seq1`.`coef` AS `coef`,`seq1`.`value` AS `value1`,`seq1`.`weight` AS `weight1`,`seq2`.`value` AS `value2`,`seq2`.`weight` AS `weight2`,((coalesce((`seq1`.`value` * `seq1`.`weight`),0) + coalesce((`seq2`.`value` * `seq2`.`weight`),0)) / (`seq1`.`weight` + `seq2`.`weight`)) AS `value`,greatest(`seq1`.`weight`,`seq2`.`weight`) AS `weight`,((`seq1`.`mini` + `seq2`.`mini`) / 2) AS `mini`,((`seq1`.`maxi` + `seq2`.`maxi`) / 2) AS `maxi` from (`V_STUDENT_MARK_SEQ21_54` `seq1` left join `V_STUDENT_MARK_SEQ21_55` `seq2` on(((`seq1`.`std` = `seq2`.`std`) and (`seq1`.`crs` = `seq2`.`crs`)))) order by `seq1`.`std` */;

--
-- Final view structure for view `V_STUDENT_MARK_QUATER25_23`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_QUATER25_23`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_QUATER25_23` AS select distinct `seq1`.`std` AS `std`,`seq1`.`crs` AS `crs`,`seq1`.`coef` AS `coef`,`seq1`.`value` AS `value1`,`seq1`.`weight` AS `weight1`,`seq2`.`value` AS `value2`,`seq2`.`weight` AS `weight2`,((coalesce((`seq1`.`value` * `seq1`.`weight`),0) + coalesce((`seq2`.`value` * `seq2`.`weight`),0)) / (`seq1`.`weight` + `seq2`.`weight`)) AS `value`,greatest(`seq1`.`weight`,`seq2`.`weight`) AS `weight`,((`seq1`.`mini` + `seq2`.`mini`) / 2) AS `mini`,((`seq1`.`maxi` + `seq2`.`maxi`) / 2) AS `maxi` from (`V_STUDENT_MARK_SEQ25_46` `seq1` left join `V_STUDENT_MARK_SEQ25_47` `seq2` on(((`seq1`.`std` = `seq2`.`std`) and (`seq1`.`crs` = `seq2`.`crs`)))) order by `seq1`.`std` */;

--
-- Final view structure for view `V_STUDENT_MARK_QUATER25_24`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_QUATER25_24`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_QUATER25_24` AS select distinct `seq1`.`std` AS `std`,`seq1`.`crs` AS `crs`,`seq1`.`coef` AS `coef`,`seq1`.`value` AS `value1`,`seq1`.`weight` AS `weight1`,`seq2`.`value` AS `value2`,`seq2`.`weight` AS `weight2`,((coalesce((`seq1`.`value` * `seq1`.`weight`),0) + coalesce((`seq2`.`value` * `seq2`.`weight`),0)) / (`seq1`.`weight` + `seq2`.`weight`)) AS `value`,greatest(`seq1`.`weight`,`seq2`.`weight`) AS `weight`,((`seq1`.`mini` + `seq2`.`mini`) / 2) AS `mini`,((`seq1`.`maxi` + `seq2`.`maxi`) / 2) AS `maxi` from (`V_STUDENT_MARK_SEQ25_51` `seq1` left join `V_STUDENT_MARK_SEQ25_53` `seq2` on(((`seq1`.`std` = `seq2`.`std`) and (`seq1`.`crs` = `seq2`.`crs`)))) order by `seq1`.`std` */;

--
-- Final view structure for view `V_STUDENT_MARK_QUATER26_23`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_QUATER26_23`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_QUATER26_23` AS select distinct `seq1`.`std` AS `std`,`seq1`.`crs` AS `crs`,`seq1`.`coef` AS `coef`,`seq1`.`value` AS `value1`,`seq1`.`weight` AS `weight1`,`seq2`.`value` AS `value2`,`seq2`.`weight` AS `weight2`,((coalesce((`seq1`.`value` * `seq1`.`weight`),0) + coalesce((`seq2`.`value` * `seq2`.`weight`),0)) / (`seq1`.`weight` + `seq2`.`weight`)) AS `value`,greatest(`seq1`.`weight`,`seq2`.`weight`) AS `weight`,((`seq1`.`mini` + `seq2`.`mini`) / 2) AS `mini`,((`seq1`.`maxi` + `seq2`.`maxi`) / 2) AS `maxi` from (`V_STUDENT_MARK_SEQ26_46` `seq1` left join `V_STUDENT_MARK_SEQ26_47` `seq2` on(((`seq1`.`std` = `seq2`.`std`) and (`seq1`.`crs` = `seq2`.`crs`)))) order by `seq1`.`std` */;

--
-- Final view structure for view `V_STUDENT_MARK_QUATER26_24`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_QUATER26_24`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_QUATER26_24` AS select distinct `seq1`.`std` AS `std`,`seq1`.`crs` AS `crs`,`seq1`.`coef` AS `coef`,`seq1`.`value` AS `value1`,`seq1`.`weight` AS `weight1`,`seq2`.`value` AS `value2`,`seq2`.`weight` AS `weight2`,((coalesce((`seq1`.`value` * `seq1`.`weight`),0) + coalesce((`seq2`.`value` * `seq2`.`weight`),0)) / (`seq1`.`weight` + `seq2`.`weight`)) AS `value`,greatest(`seq1`.`weight`,`seq2`.`weight`) AS `weight`,((`seq1`.`mini` + `seq2`.`mini`) / 2) AS `mini`,((`seq1`.`maxi` + `seq2`.`maxi`) / 2) AS `maxi` from (`V_STUDENT_MARK_SEQ26_51` `seq1` left join `V_STUDENT_MARK_SEQ26_53` `seq2` on(((`seq1`.`std` = `seq2`.`std`) and (`seq1`.`crs` = `seq2`.`crs`)))) order by `seq1`.`std` */;

--
-- Final view structure for view `V_STUDENT_MARK_QUATER2_23`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_QUATER2_23`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_QUATER2_23` AS select distinct `seq1`.`std` AS `std`,`seq1`.`crs` AS `crs`,`seq1`.`coef` AS `coef`,`seq1`.`value` AS `value1`,`seq1`.`weight` AS `weight1`,`seq2`.`value` AS `value2`,`seq2`.`weight` AS `weight2`,((coalesce((`seq1`.`value` * `seq1`.`weight`),0) + coalesce((`seq2`.`value` * `seq2`.`weight`),0)) / (`seq1`.`weight` + `seq2`.`weight`)) AS `value`,greatest(`seq1`.`weight`,`seq2`.`weight`) AS `weight`,((`seq1`.`mini` + `seq2`.`mini`) / 2) AS `mini`,((`seq1`.`maxi` + `seq2`.`maxi`) / 2) AS `maxi` from (`V_STUDENT_MARK_SEQ2_46` `seq1` left join `V_STUDENT_MARK_SEQ2_47` `seq2` on(((`seq1`.`std` = `seq2`.`std`) and (`seq1`.`crs` = `seq2`.`crs`)))) order by `seq1`.`std` */;

--
-- Final view structure for view `V_STUDENT_MARK_QUATER2_24`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_QUATER2_24`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_QUATER2_24` AS select distinct `seq1`.`std` AS `std`,`seq1`.`crs` AS `crs`,`seq1`.`coef` AS `coef`,`seq1`.`value` AS `value1`,`seq1`.`weight` AS `weight1`,`seq2`.`value` AS `value2`,`seq2`.`weight` AS `weight2`,((coalesce((`seq1`.`value` * `seq1`.`weight`),0) + coalesce((`seq2`.`value` * `seq2`.`weight`),0)) / (`seq1`.`weight` + `seq2`.`weight`)) AS `value`,greatest(`seq1`.`weight`,`seq2`.`weight`) AS `weight`,((`seq1`.`mini` + `seq2`.`mini`) / 2) AS `mini`,((`seq1`.`maxi` + `seq2`.`maxi`) / 2) AS `maxi` from (`V_STUDENT_MARK_SEQ2_51` `seq1` left join `V_STUDENT_MARK_SEQ2_53` `seq2` on(((`seq1`.`std` = `seq2`.`std`) and (`seq1`.`crs` = `seq2`.`crs`)))) order by `seq1`.`std` */;

--
-- Final view structure for view `V_STUDENT_MARK_QUATER30_23`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_QUATER30_23`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_QUATER30_23` AS select distinct `seq1`.`std` AS `std`,`seq1`.`crs` AS `crs`,`seq1`.`coef` AS `coef`,`seq1`.`value` AS `value1`,`seq1`.`weight` AS `weight1`,`seq2`.`value` AS `value2`,`seq2`.`weight` AS `weight2`,((coalesce((`seq1`.`value` * `seq1`.`weight`),0) + coalesce((`seq2`.`value` * `seq2`.`weight`),0)) / (`seq1`.`weight` + `seq2`.`weight`)) AS `value`,greatest(`seq1`.`weight`,`seq2`.`weight`) AS `weight`,((`seq1`.`mini` + `seq2`.`mini`) / 2) AS `mini`,((`seq1`.`maxi` + `seq2`.`maxi`) / 2) AS `maxi` from (`V_STUDENT_MARK_SEQ30_46` `seq1` left join `V_STUDENT_MARK_SEQ30_47` `seq2` on(((`seq1`.`std` = `seq2`.`std`) and (`seq1`.`crs` = `seq2`.`crs`)))) order by `seq1`.`std` */;

--
-- Final view structure for view `V_STUDENT_MARK_QUATER30_24`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_QUATER30_24`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_QUATER30_24` AS select distinct `seq1`.`std` AS `std`,`seq1`.`crs` AS `crs`,`seq1`.`coef` AS `coef`,`seq1`.`value` AS `value1`,`seq1`.`weight` AS `weight1`,`seq2`.`value` AS `value2`,`seq2`.`weight` AS `weight2`,((coalesce((`seq1`.`value` * `seq1`.`weight`),0) + coalesce((`seq2`.`value` * `seq2`.`weight`),0)) / (`seq1`.`weight` + `seq2`.`weight`)) AS `value`,greatest(`seq1`.`weight`,`seq2`.`weight`) AS `weight`,((`seq1`.`mini` + `seq2`.`mini`) / 2) AS `mini`,((`seq1`.`maxi` + `seq2`.`maxi`) / 2) AS `maxi` from (`V_STUDENT_MARK_SEQ30_51` `seq1` left join `V_STUDENT_MARK_SEQ30_53` `seq2` on(((`seq1`.`std` = `seq2`.`std`) and (`seq1`.`crs` = `seq2`.`crs`)))) order by `seq1`.`std` */;

--
-- Final view structure for view `V_STUDENT_MARK_QUATER30_26`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_QUATER30_26`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_QUATER30_26` AS select distinct `seq1`.`std` AS `std`,`seq1`.`crs` AS `crs`,`seq1`.`coef` AS `coef`,`seq1`.`value` AS `value1`,`seq1`.`weight` AS `weight1`,`seq2`.`value` AS `value2`,`seq2`.`weight` AS `weight2`,((coalesce((`seq1`.`value` * `seq1`.`weight`),0) + coalesce((`seq2`.`value` * `seq2`.`weight`),0)) / (`seq1`.`weight` + `seq2`.`weight`)) AS `value`,greatest(`seq1`.`weight`,`seq2`.`weight`) AS `weight`,((`seq1`.`mini` + `seq2`.`mini`) / 2) AS `mini`,((`seq1`.`maxi` + `seq2`.`maxi`) / 2) AS `maxi` from (`V_STUDENT_MARK_SEQ30_54` `seq1` left join `V_STUDENT_MARK_SEQ30_55` `seq2` on(((`seq1`.`std` = `seq2`.`std`) and (`seq1`.`crs` = `seq2`.`crs`)))) order by `seq1`.`std` */;

--
-- Final view structure for view `V_STUDENT_MARK_QUATER3_24`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_QUATER3_24`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_QUATER3_24` AS select distinct `seq1`.`std` AS `std`,`seq1`.`crs` AS `crs`,`seq1`.`coef` AS `coef`,`seq1`.`value` AS `value1`,`seq1`.`weight` AS `weight1`,`seq2`.`value` AS `value2`,`seq2`.`weight` AS `weight2`,((coalesce((`seq1`.`value` * `seq1`.`weight`),0) + coalesce((`seq2`.`value` * `seq2`.`weight`),0)) / (`seq1`.`weight` + `seq2`.`weight`)) AS `value`,greatest(`seq1`.`weight`,`seq2`.`weight`) AS `weight`,((`seq1`.`mini` + `seq2`.`mini`) / 2) AS `mini`,((`seq1`.`maxi` + `seq2`.`maxi`) / 2) AS `maxi` from (`V_STUDENT_MARK_SEQ3_51` `seq1` left join `V_STUDENT_MARK_SEQ3_53` `seq2` on(((`seq1`.`std` = `seq2`.`std`) and (`seq1`.`crs` = `seq2`.`crs`)))) order by `seq1`.`std` */;

--
-- Final view structure for view `V_STUDENT_MARK_QUATER4_24`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_QUATER4_24`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_QUATER4_24` AS select distinct `seq1`.`std` AS `std`,`seq1`.`crs` AS `crs`,`seq1`.`coef` AS `coef`,`seq1`.`value` AS `value1`,`seq1`.`weight` AS `weight1`,`seq2`.`value` AS `value2`,`seq2`.`weight` AS `weight2`,((coalesce((`seq1`.`value` * `seq1`.`weight`),0) + coalesce((`seq2`.`value` * `seq2`.`weight`),0)) / (`seq1`.`weight` + `seq2`.`weight`)) AS `value`,greatest(`seq1`.`weight`,`seq2`.`weight`) AS `weight`,((`seq1`.`mini` + `seq2`.`mini`) / 2) AS `mini`,((`seq1`.`maxi` + `seq2`.`maxi`) / 2) AS `maxi` from (`V_STUDENT_MARK_SEQ4_51` `seq1` left join `V_STUDENT_MARK_SEQ4_53` `seq2` on(((`seq1`.`std` = `seq2`.`std`) and (`seq1`.`crs` = `seq2`.`crs`)))) order by `seq1`.`std` */;

--
-- Final view structure for view `V_STUDENT_MARK_QUATER5_23`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_QUATER5_23`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_QUATER5_23` AS select distinct `seq1`.`std` AS `std`,`seq1`.`crs` AS `crs`,`seq1`.`coef` AS `coef`,`seq1`.`value` AS `value1`,`seq1`.`weight` AS `weight1`,`seq2`.`value` AS `value2`,`seq2`.`weight` AS `weight2`,((coalesce((`seq1`.`value` * `seq1`.`weight`),0) + coalesce((`seq2`.`value` * `seq2`.`weight`),0)) / (`seq1`.`weight` + `seq2`.`weight`)) AS `value`,greatest(`seq1`.`weight`,`seq2`.`weight`) AS `weight`,((`seq1`.`mini` + `seq2`.`mini`) / 2) AS `mini`,((`seq1`.`maxi` + `seq2`.`maxi`) / 2) AS `maxi` from (`V_STUDENT_MARK_SEQ5_46` `seq1` left join `V_STUDENT_MARK_SEQ5_47` `seq2` on(((`seq1`.`std` = `seq2`.`std`) and (`seq1`.`crs` = `seq2`.`crs`)))) order by `seq1`.`std` */;

--
-- Final view structure for view `V_STUDENT_MARK_QUATER5_24`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_QUATER5_24`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_QUATER5_24` AS select distinct `seq1`.`std` AS `std`,`seq1`.`crs` AS `crs`,`seq1`.`coef` AS `coef`,`seq1`.`value` AS `value1`,`seq1`.`weight` AS `weight1`,`seq2`.`value` AS `value2`,`seq2`.`weight` AS `weight2`,((coalesce((`seq1`.`value` * `seq1`.`weight`),0) + coalesce((`seq2`.`value` * `seq2`.`weight`),0)) / (`seq1`.`weight` + `seq2`.`weight`)) AS `value`,greatest(`seq1`.`weight`,`seq2`.`weight`) AS `weight`,((`seq1`.`mini` + `seq2`.`mini`) / 2) AS `mini`,((`seq1`.`maxi` + `seq2`.`maxi`) / 2) AS `maxi` from (`V_STUDENT_MARK_SEQ5_51` `seq1` left join `V_STUDENT_MARK_SEQ5_53` `seq2` on(((`seq1`.`std` = `seq2`.`std`) and (`seq1`.`crs` = `seq2`.`crs`)))) order by `seq1`.`std` */;

--
-- Final view structure for view `V_STUDENT_MARK_QUATER5_26`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_QUATER5_26`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_QUATER5_26` AS select distinct `seq1`.`std` AS `std`,`seq1`.`crs` AS `crs`,`seq1`.`coef` AS `coef`,`seq1`.`value` AS `value1`,`seq1`.`weight` AS `weight1`,`seq2`.`value` AS `value2`,`seq2`.`weight` AS `weight2`,((coalesce((`seq1`.`value` * `seq1`.`weight`),0) + coalesce((`seq2`.`value` * `seq2`.`weight`),0)) / (`seq1`.`weight` + `seq2`.`weight`)) AS `value`,greatest(`seq1`.`weight`,`seq2`.`weight`) AS `weight`,((`seq1`.`mini` + `seq2`.`mini`) / 2) AS `mini`,((`seq1`.`maxi` + `seq2`.`maxi`) / 2) AS `maxi` from (`V_STUDENT_MARK_SEQ5_54` `seq1` left join `V_STUDENT_MARK_SEQ5_55` `seq2` on(((`seq1`.`std` = `seq2`.`std`) and (`seq1`.`crs` = `seq2`.`crs`)))) order by `seq1`.`std` */;

--
-- Final view structure for view `V_STUDENT_MARK_QUATER6_23`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_QUATER6_23`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_QUATER6_23` AS select distinct `seq1`.`std` AS `std`,`seq1`.`crs` AS `crs`,`seq1`.`coef` AS `coef`,`seq1`.`value` AS `value1`,`seq1`.`weight` AS `weight1`,`seq2`.`value` AS `value2`,`seq2`.`weight` AS `weight2`,((coalesce((`seq1`.`value` * `seq1`.`weight`),0) + coalesce((`seq2`.`value` * `seq2`.`weight`),0)) / (`seq1`.`weight` + `seq2`.`weight`)) AS `value`,greatest(`seq1`.`weight`,`seq2`.`weight`) AS `weight`,((`seq1`.`mini` + `seq2`.`mini`) / 2) AS `mini`,((`seq1`.`maxi` + `seq2`.`maxi`) / 2) AS `maxi` from (`V_STUDENT_MARK_SEQ6_46` `seq1` left join `V_STUDENT_MARK_SEQ6_47` `seq2` on(((`seq1`.`std` = `seq2`.`std`) and (`seq1`.`crs` = `seq2`.`crs`)))) order by `seq1`.`std` */;

--
-- Final view structure for view `V_STUDENT_MARK_QUATER6_24`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_QUATER6_24`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_QUATER6_24` AS select distinct `seq1`.`std` AS `std`,`seq1`.`crs` AS `crs`,`seq1`.`coef` AS `coef`,`seq1`.`value` AS `value1`,`seq1`.`weight` AS `weight1`,`seq2`.`value` AS `value2`,`seq2`.`weight` AS `weight2`,((coalesce((`seq1`.`value` * `seq1`.`weight`),0) + coalesce((`seq2`.`value` * `seq2`.`weight`),0)) / (`seq1`.`weight` + `seq2`.`weight`)) AS `value`,greatest(`seq1`.`weight`,`seq2`.`weight`) AS `weight`,((`seq1`.`mini` + `seq2`.`mini`) / 2) AS `mini`,((`seq1`.`maxi` + `seq2`.`maxi`) / 2) AS `maxi` from (`V_STUDENT_MARK_SEQ6_51` `seq1` left join `V_STUDENT_MARK_SEQ6_53` `seq2` on(((`seq1`.`std` = `seq2`.`std`) and (`seq1`.`crs` = `seq2`.`crs`)))) order by `seq1`.`std` */;

--
-- Final view structure for view `V_STUDENT_MARK_QUATER6_26`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_QUATER6_26`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_QUATER6_26` AS select distinct `seq1`.`std` AS `std`,`seq1`.`crs` AS `crs`,`seq1`.`coef` AS `coef`,`seq1`.`value` AS `value1`,`seq1`.`weight` AS `weight1`,`seq2`.`value` AS `value2`,`seq2`.`weight` AS `weight2`,((coalesce((`seq1`.`value` * `seq1`.`weight`),0) + coalesce((`seq2`.`value` * `seq2`.`weight`),0)) / (`seq1`.`weight` + `seq2`.`weight`)) AS `value`,greatest(`seq1`.`weight`,`seq2`.`weight`) AS `weight`,((`seq1`.`mini` + `seq2`.`mini`) / 2) AS `mini`,((`seq1`.`maxi` + `seq2`.`maxi`) / 2) AS `maxi` from (`V_STUDENT_MARK_SEQ6_54` `seq1` left join `V_STUDENT_MARK_SEQ6_55` `seq2` on(((`seq1`.`std` = `seq2`.`std`) and (`seq1`.`crs` = `seq2`.`crs`)))) order by `seq1`.`std` */;

--
-- Final view structure for view `V_STUDENT_MARK_QUATER7_23`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_QUATER7_23`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_QUATER7_23` AS select distinct `seq1`.`std` AS `std`,`seq1`.`crs` AS `crs`,`seq1`.`coef` AS `coef`,`seq1`.`value` AS `value1`,`seq1`.`weight` AS `weight1`,`seq2`.`value` AS `value2`,`seq2`.`weight` AS `weight2`,((coalesce((`seq1`.`value` * `seq1`.`weight`),0) + coalesce((`seq2`.`value` * `seq2`.`weight`),0)) / (`seq1`.`weight` + `seq2`.`weight`)) AS `value`,greatest(`seq1`.`weight`,`seq2`.`weight`) AS `weight`,((`seq1`.`mini` + `seq2`.`mini`) / 2) AS `mini`,((`seq1`.`maxi` + `seq2`.`maxi`) / 2) AS `maxi` from (`V_STUDENT_MARK_SEQ7_46` `seq1` left join `V_STUDENT_MARK_SEQ7_47` `seq2` on(((`seq1`.`std` = `seq2`.`std`) and (`seq1`.`crs` = `seq2`.`crs`)))) order by `seq1`.`std` */;

--
-- Final view structure for view `V_STUDENT_MARK_QUATER7_24`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_QUATER7_24`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_QUATER7_24` AS select distinct `seq1`.`std` AS `std`,`seq1`.`crs` AS `crs`,`seq1`.`coef` AS `coef`,`seq1`.`value` AS `value1`,`seq1`.`weight` AS `weight1`,`seq2`.`value` AS `value2`,`seq2`.`weight` AS `weight2`,((coalesce((`seq1`.`value` * `seq1`.`weight`),0) + coalesce((`seq2`.`value` * `seq2`.`weight`),0)) / (`seq1`.`weight` + `seq2`.`weight`)) AS `value`,greatest(`seq1`.`weight`,`seq2`.`weight`) AS `weight`,((`seq1`.`mini` + `seq2`.`mini`) / 2) AS `mini`,((`seq1`.`maxi` + `seq2`.`maxi`) / 2) AS `maxi` from (`V_STUDENT_MARK_SEQ7_51` `seq1` left join `V_STUDENT_MARK_SEQ7_53` `seq2` on(((`seq1`.`std` = `seq2`.`std`) and (`seq1`.`crs` = `seq2`.`crs`)))) order by `seq1`.`std` */;

--
-- Final view structure for view `V_STUDENT_MARK_QUATER7_26`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_QUATER7_26`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_QUATER7_26` AS select distinct `seq1`.`std` AS `std`,`seq1`.`crs` AS `crs`,`seq1`.`coef` AS `coef`,`seq1`.`value` AS `value1`,`seq1`.`weight` AS `weight1`,`seq2`.`value` AS `value2`,`seq2`.`weight` AS `weight2`,((coalesce((`seq1`.`value` * `seq1`.`weight`),0) + coalesce((`seq2`.`value` * `seq2`.`weight`),0)) / (`seq1`.`weight` + `seq2`.`weight`)) AS `value`,greatest(`seq1`.`weight`,`seq2`.`weight`) AS `weight`,((`seq1`.`mini` + `seq2`.`mini`) / 2) AS `mini`,((`seq1`.`maxi` + `seq2`.`maxi`) / 2) AS `maxi` from (`V_STUDENT_MARK_SEQ7_54` `seq1` left join `V_STUDENT_MARK_SEQ7_55` `seq2` on(((`seq1`.`std` = `seq2`.`std`) and (`seq1`.`crs` = `seq2`.`crs`)))) order by `seq1`.`std` */;

--
-- Final view structure for view `V_STUDENT_MARK_QUATER8_23`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_QUATER8_23`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_QUATER8_23` AS select distinct `seq1`.`std` AS `std`,`seq1`.`crs` AS `crs`,`seq1`.`coef` AS `coef`,`seq1`.`value` AS `value1`,`seq1`.`weight` AS `weight1`,`seq2`.`value` AS `value2`,`seq2`.`weight` AS `weight2`,((coalesce((`seq1`.`value` * `seq1`.`weight`),0) + coalesce((`seq2`.`value` * `seq2`.`weight`),0)) / (`seq1`.`weight` + `seq2`.`weight`)) AS `value`,greatest(`seq1`.`weight`,`seq2`.`weight`) AS `weight`,((`seq1`.`mini` + `seq2`.`mini`) / 2) AS `mini`,((`seq1`.`maxi` + `seq2`.`maxi`) / 2) AS `maxi` from (`V_STUDENT_MARK_SEQ8_46` `seq1` left join `V_STUDENT_MARK_SEQ8_47` `seq2` on(((`seq1`.`std` = `seq2`.`std`) and (`seq1`.`crs` = `seq2`.`crs`)))) order by `seq1`.`std` */;

--
-- Final view structure for view `V_STUDENT_MARK_QUATER8_24`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_QUATER8_24`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_QUATER8_24` AS select distinct `seq1`.`std` AS `std`,`seq1`.`crs` AS `crs`,`seq1`.`coef` AS `coef`,`seq1`.`value` AS `value1`,`seq1`.`weight` AS `weight1`,`seq2`.`value` AS `value2`,`seq2`.`weight` AS `weight2`,((coalesce((`seq1`.`value` * `seq1`.`weight`),0) + coalesce((`seq2`.`value` * `seq2`.`weight`),0)) / (`seq1`.`weight` + `seq2`.`weight`)) AS `value`,greatest(`seq1`.`weight`,`seq2`.`weight`) AS `weight`,((`seq1`.`mini` + `seq2`.`mini`) / 2) AS `mini`,((`seq1`.`maxi` + `seq2`.`maxi`) / 2) AS `maxi` from (`V_STUDENT_MARK_SEQ8_51` `seq1` left join `V_STUDENT_MARK_SEQ8_53` `seq2` on(((`seq1`.`std` = `seq2`.`std`) and (`seq1`.`crs` = `seq2`.`crs`)))) order by `seq1`.`std` */;

--
-- Final view structure for view `V_STUDENT_MARK_QUATER8_26`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_QUATER8_26`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_QUATER8_26` AS select distinct `seq1`.`std` AS `std`,`seq1`.`crs` AS `crs`,`seq1`.`coef` AS `coef`,`seq1`.`value` AS `value1`,`seq1`.`weight` AS `weight1`,`seq2`.`value` AS `value2`,`seq2`.`weight` AS `weight2`,((coalesce((`seq1`.`value` * `seq1`.`weight`),0) + coalesce((`seq2`.`value` * `seq2`.`weight`),0)) / (`seq1`.`weight` + `seq2`.`weight`)) AS `value`,greatest(`seq1`.`weight`,`seq2`.`weight`) AS `weight`,((`seq1`.`mini` + `seq2`.`mini`) / 2) AS `mini`,((`seq1`.`maxi` + `seq2`.`maxi`) / 2) AS `maxi` from (`V_STUDENT_MARK_SEQ8_54` `seq1` left join `V_STUDENT_MARK_SEQ8_55` `seq2` on(((`seq1`.`std` = `seq2`.`std`) and (`seq1`.`crs` = `seq2`.`crs`)))) order by `seq1`.`std` */;

--
-- Final view structure for view `V_STUDENT_MARK_QUATER9_24`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_QUATER9_24`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_QUATER9_24` AS select distinct `seq1`.`std` AS `std`,`seq1`.`crs` AS `crs`,`seq1`.`coef` AS `coef`,`seq1`.`value` AS `value1`,`seq1`.`weight` AS `weight1`,`seq2`.`value` AS `value2`,`seq2`.`weight` AS `weight2`,((coalesce((`seq1`.`value` * `seq1`.`weight`),0) + coalesce((`seq2`.`value` * `seq2`.`weight`),0)) / (`seq1`.`weight` + `seq2`.`weight`)) AS `value`,greatest(`seq1`.`weight`,`seq2`.`weight`) AS `weight`,((`seq1`.`mini` + `seq2`.`mini`) / 2) AS `mini`,((`seq1`.`maxi` + `seq2`.`maxi`) / 2) AS `maxi` from (`V_STUDENT_MARK_SEQ9_51` `seq1` left join `V_STUDENT_MARK_SEQ9_53` `seq2` on(((`seq1`.`std` = `seq2`.`std`) and (`seq1`.`crs` = `seq2`.`crs`)))) order by `seq1`.`std` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ10_51`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ10_51`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ10_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` = '10') and (`eval`.`sequence_id` = '51')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ10_53`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ10_53`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ10_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` = '10') and (`eval`.`sequence_id` = '53')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ12_46`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ12_46`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ12_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` = '12') and (`eval`.`sequence_id` = '46')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ12_47`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ12_47`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ12_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` = '12') and (`eval`.`sequence_id` = '47')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ12_51`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ12_51`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ12_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` = '12') and (`eval`.`sequence_id` = '51')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ12_53`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ12_53`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ12_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` = '12') and (`eval`.`sequence_id` = '53')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ12_54`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ12_54`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ12_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` = '12') and (`eval`.`sequence_id` = '54')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ12_55`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ12_55`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ12_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` = '12') and (`eval`.`sequence_id` = '55')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ13_51`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ13_51`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ13_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` = '13') and (`eval`.`sequence_id` = '51')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ13_53`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ13_53`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ13_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` = '13') and (`eval`.`sequence_id` = '53')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ13_54`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ13_54`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ13_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` = '13') and (`eval`.`sequence_id` = '54')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ13_55`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ13_55`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ13_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` = '13') and (`eval`.`sequence_id` = '55')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ14_46`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ14_46`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ14_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` = '14') and (`eval`.`sequence_id` = '46')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ14_47`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ14_47`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ14_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` = '14') and (`eval`.`sequence_id` = '47')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ14_51`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ14_51`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ14_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` = '14') and (`eval`.`sequence_id` = '51')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ14_53`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ14_53`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ14_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` = '14') and (`eval`.`sequence_id` = '53')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ14_54`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ14_54`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ14_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` = '14') and (`eval`.`sequence_id` = '54')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ14_55`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ14_55`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ14_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` = '14') and (`eval`.`sequence_id` = '55')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ15_46`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ15_46`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ15_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` = '15') and (`eval`.`sequence_id` = '46')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ15_47`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ15_47`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ15_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` = '15') and (`eval`.`sequence_id` = '47')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ15_51`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ15_51`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ15_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` = '15') and (`eval`.`sequence_id` = '51')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ15_53`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ15_53`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ15_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` = '15') and (`eval`.`sequence_id` = '53')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ15_54`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ15_54`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ15_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` = '15') and (`eval`.`sequence_id` = '54')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ15_55`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ15_55`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ15_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` = '15') and (`eval`.`sequence_id` = '55')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ16_46`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ16_46`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ16_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` = '16') and (`eval`.`sequence_id` = '46')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ16_47`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ16_47`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ16_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` = '16') and (`eval`.`sequence_id` = '47')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ16_51`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ16_51`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ16_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` = '16') and (`eval`.`sequence_id` = '51')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ16_53`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ16_53`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ16_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` = '16') and (`eval`.`sequence_id` = '53')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ16_54`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ16_54`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ16_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` = '16') and (`eval`.`sequence_id` = '54')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ16_55`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ16_55`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ16_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` = '16') and (`eval`.`sequence_id` = '55')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ17_51`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ17_51`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ17_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` = '17') and (`eval`.`sequence_id` = '51')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ17_53`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ17_53`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ17_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` = '17') and (`eval`.`sequence_id` = '53')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ18_51`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ18_51`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ18_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` = '18') and (`eval`.`sequence_id` = '51')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ18_53`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ18_53`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ18_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` = '18') and (`eval`.`sequence_id` = '53')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ19_46`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ19_46`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ19_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` = '19') and (`eval`.`sequence_id` = '46')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ19_47`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ19_47`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ19_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` = '19') and (`eval`.`sequence_id` = '47')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ19_51`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ19_51`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ19_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` = '19') and (`eval`.`sequence_id` = '51')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ19_53`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ19_53`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ19_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` = '19') and (`eval`.`sequence_id` = '53')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ19_54`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ19_54`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ19_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` = '19') and (`eval`.`sequence_id` = '54')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ19_55`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ19_55`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ19_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` = '19') and (`eval`.`sequence_id` = '55')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ1_46`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ1_46`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ1_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` = '1') and (`eval`.`sequence_id` = '46')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ1_47`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ1_47`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ1_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` = '1') and (`eval`.`sequence_id` = '47')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ1_51`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ1_51`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ1_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` = '1') and (`eval`.`sequence_id` = '51')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ1_53`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ1_53`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ1_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` = '1') and (`eval`.`sequence_id` = '53')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ20_46`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ20_46`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ20_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` = '20') and (`eval`.`sequence_id` = '46')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ20_47`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ20_47`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ20_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` = '20') and (`eval`.`sequence_id` = '47')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ20_51`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ20_51`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ20_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` = '20') and (`eval`.`sequence_id` = '51')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ20_53`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ20_53`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ20_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` = '20') and (`eval`.`sequence_id` = '53')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ20_54`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ20_54`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ20_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` = '20') and (`eval`.`sequence_id` = '54')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ21_46`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ21_46`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ21_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` = '21') and (`eval`.`sequence_id` = '46')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ21_47`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ21_47`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ21_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` = '21') and (`eval`.`sequence_id` = '47')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ21_51`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ21_51`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ21_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` = '21') and (`eval`.`sequence_id` = '51')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ21_53`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ21_53`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ21_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` = '21') and (`eval`.`sequence_id` = '53')) order by `std`,`crs` */;

--
-- 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_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_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_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_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_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_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_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_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_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_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_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_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_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_YEAR12_8`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_YEAR12_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_YEAR19_8`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_YEAR19_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_YEAR30_8`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_YEAR30_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_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_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_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_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_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_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 */;


