WHY
ΪʲôҪÌå¼ì
ÎÒÃǶ¼ÖªµÀÌå¼ìºÜÖØÒª£¬Ìå¼ìÊÇΪÁËÖ¤Ã÷Ô±¹¤ÉíÌåÊǽ¡¿µµÄ£¬µ«ÊÇÎÒÃÇÕæµÄÖªµÀΪʲôҪÌå¼ìô£¿
Ìå¼ìÖ÷ÒªÓÐÁ½¸öÄ¿µÄ£¬¼´±£Ö¤Ò©Æ·µÄÖÊÁ¿ºÍ±£»¤Ô±¹¤µÄ°²È«¡£
Ìå¼ì»î¶¯µÄÊ×ҪĿµÄÊDZ£Ö¤Ò©Æ·µÄÖÊÁ¿£¬½ø¶ø±£Ö¤»¼ÕßµÄÓÃÒ©°²È«£¬¶ÔÔ±¹¤½øÐж¨ÆÚºÍÓÐЧµÄ½¡¿µ¼ì²é£¬¿ÉÒÔ´Ó·ÀÖ¹Ò©Æ·ÎÛȾºÍÓÐЧʶ±ð´ÎÆ·Á½¸ö·½Ãæ±£Ö¤Ò©Æ·ÖÊÁ¿¡£ÁíÍ⣬Ìå¼ì»î¶¯¿ÉÒÔ¼°Ê±·¢ÏÖÔ±¹¤µÄ½¡¿µÇé¿ö£¬·ÀÖ¹¿ÉÄܽӴ¥µÄÒ©Æ·¶ÔÉú²úÔ±¹¤Ôì³ÉÉ˺¦£¬±ÈÈç¹ýÃô¡¢´Ì¼¤µÈ¡£
WHAT
Ìå¼ìʲôÏîÄ¿
Ã÷°×ÁËÌå¼ìµÄÄ¿µÄ£¬ÄÇô£¬Ó¦¸Ã¼ì²éÄÄЩÏîÄ¿ÄØ£¿³ýÁË»ù±¾µÄÉí¸ß¡¢ÌåÖØ¡¢Ö«Ìå»î¶¯¡¢Ðķι¦ÄÜÖ®Íâ£¬ÖØµãÓ¦¸ÃÊÇ´«È¾²¡ÏîÄ¿ºÍÊÓÁ¦ÏîÄ¿£¬ÕâÁ½¸öÏîĿҲ·Ç³£ÈÝÒ×±»Ò©Æóµ¥Î»ËùºöÊÓ£¬ÎÒÃÇÏÂÃæ¶ÔÈÝÒ׺öÊÓµÄÌå¼ìÏîÄ¿ÒÀ´Î½øÐзÖÎö£º
´«È¾²¡£º´«È¾²¡Ö÷ÒªÊÇÖ¸ºôÎüÀàµÄ´«È¾²¡ºÍƤ·ô²¡£¬Ç°ÕßÖ÷Òª°üÀ¨·Î½áºËµÈµäÐͺôÎüÀ༲²¡£»ºóÕßÖ÷Òª°üÀ¨¾ßÓд«È¾ÐÔÖÊµÄÆ¤·ô²¡£¬±ÈÈç¸÷ÖÖÒòÕæ¾úÒýÆðµÄÑ¢£¬ÒòΪ²¡¶¾ÒýÆðµÄÕîµÈ¡£Èç¹û»¼ÓÐÀàËÆµÄ¼²²¡£¬»áÒòΪÒ·þµÄ½»²æÊ¹ÓûòÕß½èÖú¿ÕÆø½øÐд«²¥¡£Èç¹û¼ÌÐø´ÓÊÂÉú²ú²Ù×÷£¬ÄÇôÔÚÒ©Æ·Éú²ú¹ý³ÌÖУ¬´«È¾²¡¶¾»òϸ¾úÓпÉÄÜ»áÎÛȾÉú²ú»·¾³£¬ÓÈÆäÊÇÓÐ΢ÉúÎï¿ØÖÆÏîÄ¿µÄÉú²ú»·¾³£¬ÉõÖÁ»áÎÛȾҩƷ»òÕß°ü²Ä£¬½ø¶øÎ£º¦»¼ÕߵĽ¡¿µ¡£ÁíÍ⣬´ËÀ༲²¡Ò²ÓпÉÄܻᴫȾÆäËûÉú²úÈËÔ±£¬Ó°ÏìÉú²ú»î¶¯µÄÕý³£ÔËÐС£
ÊÓÁ¦£ºÊÓÁ¦ÔÚÒ©Æ·Éú²úºÍ¼ìÑé»î¶¯ÖÐÓÐÊ®·ÖÖØÒªµÄ×÷Óã¬×´Ì¬±êʶµÄʶ±ð¡¢²é¿´ÒÇ±í¡¢¼ì²éÒìÎï¡¢±æ±ðÑÕÉ«¡¢²é¿´×¢ÒâÊÂÏîµÈ¶¼Àë²»¿ªÁ¼ºÃµÄÊÓÁ¦¡£ÎªÁËÄܹ»ÓÐЧµÄÍê³ÉÕâЩ¹¤×÷£¬ÐèÒª¶¨ÆÚ¶ÔÊÓÁ¦½øÐмì²é£¬¼ì²éÏîÄ¿Ö÷ÒªÓУºÉ«Ã¤¡¢É«Èõ¡¢½üÊÓ¡¢Ô¶ÊÓ¡¢½ÃÕýÊÓÁ¦µÈ¡£
Ìå±íÉ˿ڣº¶ÔÓÚÖ±½Ó»ò¼ä½Ó½Ó´¥ÎïÁÏ»òÕß²úÆ·µÄ¸Ú룬»¹Ó¦¸Ã½øÐÐÌå±íÉ˿ڵļì²é£¬ÒÔ·ÀÖ¹ÎïÁÏ»òÕß²úƷͨ¹ýÉË¿ÚÎüÊÕ»òÕßÓ°ÏìÉË¿ÚÓúºÏ£¬·ÀÖ¹É˿ڶÔÎïÁÏ»ò²úÆ·²úÉúDZÔÚµÄÎÛȾ¡£
¹ýÃôÔ»ò¹ýÃôÊ·£º¶ÔÓÚÉú²ú¸ßÖÂÃô»òÕ߸߻îÐÔÒ©Æ·µÄÉú²ú£¬±ÈÈ翹ÉúËØ£¨Ö÷ÒªÖ¸ÇàÃ¹ËØºÍβ-ÄÚõ£°·ÀàÒ©Æ·£©¡¢»¨·ÛµÈ£¬»¹Ó¦¸Ã½øÐйýÃôÔ»ò¹ýÃôÊ·µÄ¼ì²é£¬±ØÒªÊ±½øÐйýÃô²âÊÔ£¬±ÈÈçÆ¤·ô²âÊÔ£¨Æ¤ÊÔ£©µÈ¡£
wher
ÔÚÄÄÀïÌå¼ì
ÔÚʲôÑùµÄ»ú¹¹½øÐÐÌå¼ì²¢Ã»ÓÐÃ÷È·µÄ·¨¹æÒªÇ󣬵«ÊÇÖÁÉÙÓ¦¸ÃÔÚ¾ßÓÐÒ½ÁÆ»òÕßÌå¼ì×ÊÖʵĵط½½øÐУ¬±ÈÈçÒ½Ôº¡¢·ÀÒßÕ¾¡¢×¨ÒµµÄÌå¼ìÖÐÐĵȡ£ÁíÍ⣬һЩ¼òµ¥µÄ¼ì²é£¬±ÈÈçɫä¡¢½ÃÕýÊÓÁ¦µÄ¼ì²éµÈ£¬ÔÚÓÐÁ¼ºÃ³ÌÐò¿ØÖƵÄǰÌáÏ£¬¹«Ë¾¿ÉÒÔ×Ô¼º½øÐмì²é¡£
WHICH
ʲô¸ÚλÐèÒªÌå¼ì
ʲôÑùµÄ¸ÚλÐèÒªÌå¼ì£¬»òÕßʲô¸ÚλÐèÒªÖØµã¼ì²éÄÄЩÏîÄ¿ÊÇÒ»Ö±À§ÈÅÆóÒµµÄÎÊÌ⣬ÔÚGMP¼ì²éÖÐÒ²×îÈÝÒ׳öÏÖÎÊÌâ¡£
Ò»°ãÇé¿öÏ£¬ºÍÎïÁÏÓпÉÄܽӴ¥µÄ¸Úλ»òÕßÓÐÎïÁϱ©Â¶µÄ¸ÚλÒÔ¼°½à¾»Çø¸ÚλµÄÈËÔ±ÐèÒªÖØµã½øÐд«È¾²¡µÄ¼ì²é£¬±ÈÈçÈ¡ÑùÈËÔ±¡¢ÎïÁϳÆÁ¿ÈËÔ±¡¢ÎïÁÏ·Ö×°ÈËÔ±¡¢½à¾»ÇøÈËÔ±¡¢¿Õµ÷¸Úλ¡¢ÖÆË®¸Úλ¡¢Î¬ÐÞÈËÔ±µÈ£¬ÆäÖпյ÷¸Úλ¡¢ÖÆË®¸Úλ¡¢Î¬ÐÞÈËÔ±ÊDZȽÏÈÝÒ׺öÊӵĵط½¡£
¶ÔÓÚÐèÒª±æ±ðÑÕÉ«µÄ¸ÚλÐèÒª½øÐÐɫäµÄ¼ì²é£¬±ÈÈçQCµÄÀí»¯¼ìÑé¸Úλ¡¢µÆ¼ì¸Úλ¡¢±æÉ«¸Ú루±ÈÈçÓеÄÖÆ¼ÁÆóÒµ£¬½«Ò©Æ·µÄÉè¼Æ³É²»Í¬µÄÑÕÉ«ÒÔÇø·Ö²»Í¬µÄ¹æ¸ñ£©¡£
¶ÔÓÚÐèÒª¹Û²ìÒìÎï»òÕßʶ±ðÒDZíµÄ¸Ú룬ÐèÒª½øÐнÃÕýÊÓÁ¦µÄ¼ì²é£¬±ÈÈçµÆ¼ì¸Úλ¡¢ÖпظÚλ¡¢¹Ø¼üµÄÉú²ú¸ÚλµÈ¡£
WHEN
ʲôʱ¼äÌå¼ì
²ûÊöÁËÒÔÉÏÎÊÌ⣬ÄÇôԱ¹¤ÐèÒªÔÚʲôʱ¼äµã½øÐÐÌå¼ìÄØ£¿
¶ÔÓÚÐÂÈëÖ°µÄÔ±¹¤£¬ÐèÒªÔÚÈëְǰÌå¼ì£¬½øÐÐÈ«ÃæµÄ½¡¿µ¼ì²é£¬Èç¹û²»·ûºÏÏàÓ¦µÄ¸ÚλҪÇó¾Í²»ÄÜÉϸڡ£
¶ÔÓÚÒѾÔÚ¸ÚλµÄÔ±¹¤£¬Ó¦¸Ã¶¨ÆÚ½øÐÐÌå¼ì£¬ÆµÂÊÒ»°ã²»ÄܵÍÓÚÿÄêÒ»´Î£¬¶ÔÓڹؼü¸Ú룬±ÈÈçµÆ¼ì¡¢¿É¼ûÒìÎï¹Û²ìµÈ¸Ú룬³ýÁËÿÄêµÄ¼¯ÖÐÌå¼ìÍ⣬»¹Ó¦¸ÃÒÔ¸ü¸ßµÄƵÂʽøÐÐÊÓÁ¦¼ì²é£¬±ÈÈçÿ¸öÔÂÒ»´Î£¬ÕâÑùµÄ¼ì²é¹«Ë¾ÄÚ²¿×Ô¼ºÖ´Ðм´¿É¡£
Èç¹ûÓÐÔ±¹¤È¥¹ý´«È¾²¡µÄÒßÇø£¬±ÈÈçÔÚÂÃÓÎʱȥ¹ýÕýÔÚ±¬·¢ÇÝÁ÷¸ÐµÄÒßÇø£¬ÄÇôÔÚÉϸÚǰӦ¸Ã½øÐн¡¿µ¼ì²é£¬ÅųýûÓиÐȾÇÝÁ÷¸Ð²¡¶¾ºóÔÙÉϸڡ£
Èç¹ûÓÐÔ±¹¤ÒòΪ´«È¾ÐÔ¼²²¡Ðݼ٣¬ÄÇô¿µ¸´ºóÔÚÉϸÚ֮ǰ£¬Ò²Ó¦¸Ã½øÐн¡¿µ¼ì²é£¬Ö»ÓÐÖ¤Ã÷´«È¾ÐÔ¼²²¡È¬Óúºó£¬²ÅÄܹ»ÔÙ´ÎÉϸڡ£
SUM
×ܽá
ÒÔÉÏÊǶÔÌå¼ìÎÊÌâ½øÐеÄ×ۺϷÖÎö£¬ÏàÐÅ´ó¼ÒÒѾÓÐËùÁ˽âÁ˰ɣ¬Êµ¼ÊÖ´Ðйý³ÌÖÐÐèÒª¹«Ë¾¸ù¾Ýʵ¼ÊÇé¿ö½øÐÐÈ¡ÉᣬÌå¼ìÏîÄ¿µÄÉèÖÃÒª½ôÃܽáºÏ¸ÚλµÄÌØµã£¬±ØÒªÊ±ÒýÈë·çÏÕÆÀ¹À¹¤¾ß½øÐÐÆÀ¹À¡£