2019”N05ŒŽ28“ú

•½¬‚R‚P”N“xtŠú ‰ž—pî•ñ‹ZpŽÒŽŽŒ±–â‘è –â‚Q‚W

–â‚Q‚W

‰ß‹Ž‚R”N•ª‚Ì‹L˜^‚ð•Û‘¶‚µ‚Ä‚¢‚égŽŽŒ±Œ‹‰Êh•\‚©‚çA2018”N“x‚Ì•½‹Ï“_”‚ª600“_ˆÈã‚Æ‚È‚Á‚½ƒNƒ‰ƒX‚̃Nƒ‰ƒX–¼‚Æ•½‹Ï“_”‚̈ꗗ‚ðŽæ“¾‚·‚é‚r‚p‚k•¶‚Í‚Ç‚ê‚©B‚±‚±‚ŁAŽÀü‚̉ºü‚ÍŽåƒL[‚ð•\‚·B

@@ŽŽŒ±Œ‹‰Ê (Šw¶”ԍ†, ŽóŒ±”NŒŽ“ú, “_”, ƒNƒ‰ƒX–¼)

ƒA@SELECT ƒNƒ‰ƒX–¼, AVG(“_”), FROM ŽŽŒ±Œ‹‰Ê
@@GROUP BY ƒNƒ‰ƒX–¼ HAVING AVG(“_”) >= 600

ƒC@SELECT ƒNƒ‰ƒX–¼, AVG(“_”), FROM ŽŽŒ±Œ‹‰Ê
@@WHERE ŽóŒ±”NŒŽ“ú BETWEEN e2018-04-01f AND e2019-03-31f
@@GROUP BY ƒNƒ‰ƒX–¼ HAVING AVG(“_”) >= 600

ƒE@SELECT ƒNƒ‰ƒX–¼, AVG(“_”), FROM ŽŽŒ±Œ‹‰Ê
@@WHERE ŽóŒ±”NŒŽ“ú BETWEEN e2018-04-01f AND e2019-03-31f
@@GROUP BY ƒNƒ‰ƒX–¼ HAVING “_” >= 600

ƒG@SELECT ƒNƒ‰ƒX–¼, AVG(“_”), FROM ŽŽŒ±Œ‹‰Ê
@@WHERE “_” >= 600
@@GROUP BY ƒNƒ‰ƒX–¼
@@HAVING (MAX(ŽóŒ±”NŒŽ“ú)
@@@BETWEEN e2018-04-01f AND e2019-03-31f)




“š‚¦‚Í‚±‚¿‚ç
posted by ƒtƒ@[ƒXƒgƒ}ƒNƒ at 20:19| Comment(0) | H31t‰ž—pî•ñ‹ZpŽÒ