sql group new data 19.02
Sat Feb 19 2022 12:18:16 GMT+0000 (Coordinated Universal Time)
Saved by @vvnezapnopwnz #json
[{"format":"","format_id":54,"subjects":[{"subject":{"subject_id":14,"subject_name":"История Казахстана"},"tests":[{"format":"Вто рой","subject_id":14,"test_date":"2022-01-30T18:00:00.000Z","student_id":584,"student_name":"Кенебаев Манас","max_points":15,"points":8,"score_five":89,"score_four":69,"score_three":49,"last_date":"2022-01-30T18:00:00.000Z","grade":3,"percents":"53"},{"format":"Вто рой","subject_id":14,"test_date":"2022-01-30T18:00:00.000Z","student_id":585,"student_name":"Мадина Тлектесова","max_points":15,"points":5,"score_five":89,"score_four":69,"score_three":49,"last_date":"2022-01-30T18:00:00.000Z","grade":2,"percents":"33"},{"format":"Вто рой","subject_id":14,"test_date":"2022-01-30T18:00:00.000Z","student_id":614,"student_name":"Камила Темирбек","max_points":15,"points":10,"score_five":89,"score_four":69,"score_three":49,"last_date":"2022-01-30T18:00:00.000Z","grade":3,"percents":"67"}]},{"subject":{"subject_id":17,"subject_name":"География"},"tests":[{"format":"Вто рой","subject_id":14,"test_date":"2022-01-30T18:00:00.000Z","student_id":584,"student_name":"Кенебаев Манас","max_points":15,"points":8,"score_five":89,"score_four":69,"score_three":49,"last_date":"2022-01-30T18:00:00.000Z","grade":3,"percents":"53"},{"format":"Вто рой","subject_id":14,"test_date":"2022-01-30T18:00:00.000Z","student_id":585,"student_name":"Мадина Тлектесова","max_points":15,"points":5,"score_five":89,"score_four":69,"score_three":49,"last_date":"2022-01-30T18:00:00.000Z","grade":2,"percents":"33"},{"format":"Вто рой","subject_id":14,"test_date":"2022-01-30T18:00:00.000Z","student_id":614,"student_name":"Камила Темирбек","max_points":15,"points":10,"score_five":89,"score_four":69,"score_three":49,"last_date":"2022-01-30T18:00:00.000Z","grade":3,"percents":"67"}]}]},{"format":"Вто рой","format_id":24,"subjects":[{"subject":{"subject_id":14,"subject_name":"История Казахстана"},"tests":[{"format":"Вто рой","subject_id":14,"test_date":"2022-01-30T18:00:00.000Z","student_id":584,"student_name":"Кенебаев Манас","max_points":15,"points":8,"score_five":89,"score_four":69,"score_three":49,"last_date":"2022-01-30T18:00:00.000Z","grade":3,"percents":"53"},{"format":"Вто рой","subject_id":14,"test_date":"2022-01-30T18:00:00.000Z","student_id":585,"student_name":"Мадина Тлектесова","max_points":15,"points":5,"score_five":89,"score_four":69,"score_three":49,"last_date":"2022-01-30T18:00:00.000Z","grade":2,"percents":"33"},{"format":"Вто рой","subject_id":14,"test_date":"2022-01-30T18:00:00.000Z","student_id":614,"student_name":"Камила Темирбек","max_points":15,"points":10,"score_five":89,"score_four":69,"score_three":49,"last_date":"2022-01-30T18:00:00.000Z","grade":3,"percents":"67"}]},{"subject":{"subject_id":17,"subject_name":"География"},"tests":[{"format":"Вто рой","subject_id":14,"test_date":"2022-01-30T18:00:00.000Z","student_id":584,"student_name":"Кенебаев Манас","max_points":15,"points":8,"score_five":89,"score_four":69,"score_three":49,"last_date":"2022-01-30T18:00:00.000Z","grade":3,"percents":"53"},{"format":"Вто рой","subject_id":14,"test_date":"2022-01-30T18:00:00.000Z","student_id":585,"student_name":"Мадина Тлектесова","max_points":15,"points":5,"score_five":89,"score_four":69,"score_three":49,"last_date":"2022-01-30T18:00:00.000Z","grade":2,"percents":"33"},{"format":"Вто рой","subject_id":14,"test_date":"2022-01-30T18:00:00.000Z","student_id":614,"student_name":"Камила Темирбек","max_points":15,"points":10,"score_five":89,"score_four":69,"score_three":49,"last_date":"2022-01-30T18:00:00.000Z","grade":3,"percents":"67"}]}]},{"format":"Новый","format_id":62,"subjects":[]},{"format":"Пробные тесты ЕНТ","format_id":57,"subjects":[{"subject":{"subject_id":1,"subject_name":"Математика"},"tests":[{"format":"Вто рой","subject_id":14,"test_date":"2022-01-30T18:00:00.000Z","student_id":584,"student_name":"Кенебаев Манас","max_points":15,"points":8,"score_five":89,"score_four":69,"score_three":49,"last_date":"2022-01-30T18:00:00.000Z","grade":3,"percents":"53"},{"format":"Вто рой","subject_id":14,"test_date":"2022-01-30T18:00:00.000Z","student_id":585,"student_name":"Мадина Тлектесова","max_points":15,"points":5,"score_five":89,"score_four":69,"score_three":49,"last_date":"2022-01-30T18:00:00.000Z","grade":2,"percents":"33"},{"format":"Вто рой","subject_id":14,"test_date":"2022-01-30T18:00:00.000Z","student_id":614,"student_name":"Камила Темирбек","max_points":15,"points":10,"score_five":89,"score_four":69,"score_three":49,"last_date":"2022-01-30T18:00:00.000Z","grade":3,"percents":"67"}]},{"subject":{"subject_id":4,"subject_name":"Казахский язык"},"tests":[{"format":"Вто рой","subject_id":14,"test_date":"2022-01-30T18:00:00.000Z","student_id":584,"student_name":"Кенебаев Манас","max_points":15,"points":8,"score_five":89,"score_four":69,"score_three":49,"last_date":"2022-01-30T18:00:00.000Z","grade":3,"percents":"53"},{"format":"Вто рой","subject_id":14,"test_date":"2022-01-30T18:00:00.000Z","student_id":585,"student_name":"Мадина Тлектесова","max_points":15,"points":5,"score_five":89,"score_four":69,"score_three":49,"last_date":"2022-01-30T18:00:00.000Z","grade":2,"percents":"33"},{"format":"Вто рой","subject_id":14,"test_date":"2022-01-30T18:00:00.000Z","student_id":614,"student_name":"Камила Темирбек","max_points":15,"points":10,"score_five":89,"score_four":69,"score_three":49,"last_date":"2022-01-30T18:00:00.000Z","grade":3,"percents":"67"}]},{"subject":{"subject_id":14,"subject_name":"История Казахстана"},"tests":[{"format":"Вто рой","subject_id":14,"test_date":"2022-01-30T18:00:00.000Z","student_id":584,"student_name":"Кенебаев Манас","max_points":15,"points":8,"score_five":89,"score_four":69,"score_three":49,"last_date":"2022-01-30T18:00:00.000Z","grade":3,"percents":"53"},{"format":"Вто рой","subject_id":14,"test_date":"2022-01-30T18:00:00.000Z","student_id":585,"student_name":"Мадина Тлектесова","max_points":15,"points":5,"score_five":89,"score_four":69,"score_three":49,"last_date":"2022-01-30T18:00:00.000Z","grade":2,"percents":"33"},{"format":"Вто рой","subject_id":14,"test_date":"2022-01-30T18:00:00.000Z","student_id":614,"student_name":"Камила Темирбек","max_points":15,"points":10,"score_five":89,"score_four":69,"score_three":49,"last_date":"2022-01-30T18:00:00.000Z","grade":3,"percents":"67"}]}]},{"format":"Рейтинговый тест","format_id":71,"subjects":[{"subject":{"subject_id":1,"subject_name":"Математика"},"tests":[{"format":"Вто рой","subject_id":14,"test_date":"2022-01-30T18:00:00.000Z","student_id":584,"student_name":"Кенебаев Манас","max_points":15,"points":8,"score_five":89,"score_four":69,"score_three":49,"last_date":"2022-01-30T18:00:00.000Z","grade":3,"percents":"53"},{"format":"Вто рой","subject_id":14,"test_date":"2022-01-30T18:00:00.000Z","student_id":585,"student_name":"Мадина Тлектесова","max_points":15,"points":5,"score_five":89,"score_four":69,"score_three":49,"last_date":"2022-01-30T18:00:00.000Z","grade":2,"percents":"33"},{"format":"Вто рой","subject_id":14,"test_date":"2022-01-30T18:00:00.000Z","student_id":614,"student_name":"Камила Темирбек","max_points":15,"points":10,"score_five":89,"score_four":69,"score_three":49,"last_date":"2022-01-30T18:00:00.000Z","grade":3,"percents":"67"}]}]},{"format":"Третий","format_id":25,"subjects":[{"subject":{"subject_id":14,"subject_name":"История Казахстана"},"tests":[{"format":"Вто рой","subject_id":14,"test_date":"2022-01-30T18:00:00.000Z","student_id":584,"student_name":"Кенебаев Манас","max_points":15,"points":8,"score_five":89,"score_four":69,"score_three":49,"last_date":"2022-01-30T18:00:00.000Z","grade":3,"percents":"53"},{"format":"Вто рой","subject_id":14,"test_date":"2022-01-30T18:00:00.000Z","student_id":585,"student_name":"Мадина Тлектесова","max_points":15,"points":5,"score_five":89,"score_four":69,"score_three":49,"last_date":"2022-01-30T18:00:00.000Z","grade":2,"percents":"33"},{"format":"Вто рой","subject_id":14,"test_date":"2022-01-30T18:00:00.000Z","student_id":614,"student_name":"Камила Темирбек","max_points":15,"points":10,"score_five":89,"score_four":69,"score_three":49,"last_date":"2022-01-30T18:00:00.000Z","grade":3,"percents":"67"}]},{"subject":{"subject_id":17,"subject_name":"География"},"tests":[{"format":"Вто рой","subject_id":14,"test_date":"2022-01-30T18:00:00.000Z","student_id":584,"student_name":"Кенебаев Манас","max_points":15,"points":8,"score_five":89,"score_four":69,"score_three":49,"last_date":"2022-01-30T18:00:00.000Z","grade":3,"percents":"53"},{"format":"Вто рой","subject_id":14,"test_date":"2022-01-30T18:00:00.000Z","student_id":585,"student_name":"Мадина Тлектесова","max_points":15,"points":5,"score_five":89,"score_four":69,"score_three":49,"last_date":"2022-01-30T18:00:00.000Z","grade":2,"percents":"33"},{"format":"Вто рой","subject_id":14,"test_date":"2022-01-30T18:00:00.000Z","student_id":614,"student_name":"Камила Темирбек","max_points":15,"points":10,"score_five":89,"score_four":69,"score_three":49,"last_date":"2022-01-30T18:00:00.000Z","grade":3,"percents":"67"}]}]},{"format":"Четвертый","format_id":38,"subjects":[{"subject":{"subject_id":14,"subject_name":"История Казахстана"},"tests":[{"format":"Вто рой","subject_id":14,"test_date":"2022-01-30T18:00:00.000Z","student_id":584,"student_name":"Кенебаев Манас","max_points":15,"points":8,"score_five":89,"score_four":69,"score_three":49,"last_date":"2022-01-30T18:00:00.000Z","grade":3,"percents":"53"},{"format":"Вто рой","subject_id":14,"test_date":"2022-01-30T18:00:00.000Z","student_id":585,"student_name":"Мадина Тлектесова","max_points":15,"points":5,"score_five":89,"score_four":69,"score_three":49,"last_date":"2022-01-30T18:00:00.000Z","grade":2,"percents":"33"},{"format":"Вто рой","subject_id":14,"test_date":"2022-01-30T18:00:00.000Z","student_id":614,"student_name":"Камила Темирбек","max_points":15,"points":10,"score_five":89,"score_four":69,"score_three":49,"last_date":"2022-01-30T18:00:00.000Z","grade":3,"percents":"67"}]},{"subject":{"subject_id":17,"subject_name":"География"},"tests":[{"format":"Вто рой","subject_id":14,"test_date":"2022-01-30T18:00:00.000Z","student_id":584,"student_name":"Кенебаев Манас","max_points":15,"points":8,"score_five":89,"score_four":69,"score_three":49,"last_date":"2022-01-30T18:00:00.000Z","grade":3,"percents":"53"},{"format":"Вто рой","subject_id":14,"test_date":"2022-01-30T18:00:00.000Z","student_id":585,"student_name":"Мадина Тлектесова","max_points":15,"points":5,"score_five":89,"score_four":69,"score_three":49,"last_date":"2022-01-30T18:00:00.000Z","grade":2,"percents":"33"},{"format":"Вто рой","subject_id":14,"test_date":"2022-01-30T18:00:00.000Z","student_id":614,"student_name":"Камила Темирбек","max_points":15,"points":10,"score_five":89,"score_four":69,"score_three":49,"last_date":"2022-01-30T18:00:00.000Z","grade":3,"percents":"67"}]}]}]
Comments