ʵ Ñé ±¨ ¸æ5 ÏÂÔØ±¾ÎÄ

2¡¢Ð´Ò»¶ÎT-SQL³ÌÐòµ÷ÓÃÉÏÊöº¯Êý¡£µ±ÓÃEmployees±í²åÈëÒ»ÐмǼʱ£¬Ê×Ïȵ÷Óú¯ÊýCKECK_ID¼ìË÷¸Ã¼Ç¼µÄDpartmentIDÖµÔÚ±íDepartmentsµÄDepartmentID×Ö¶ÎÖÐÊÇ·ñ´æÔÚ¶ÔÓ¦Öµ£¬Èô´æÔÚ£¬Ôò½«¸Ã¼Ç¼²åÈëEmployees±í¡£ 3¡¢×Ô¶¨ÒåÒ»¸öº¯Êý£¬¼ÆËãÒ»¸öÊýµÄ½×³Ë¡£ £¨Î壩ϵͳº¯ÊýµÄʹÓà 1¡¢ÇóÒ»¸öÊýµÄ¾ø¶ÔÖµ 2¡¢Ê¹ÓÃrand£¨£©º¯Êý²úÉúÒ»¸ö0~1µÄËæ»úÖµ¡£ 3¡¢Ê¹ÓÃsquare£¨£©º¯Êý»ñµÃÒ»¸öÊýµÄƽ·½¡£ 4¡¢Ê¹ÓÃsqrt£¨£©·µ»ØÒ»¸öÊýµÄƽ·½¸ù¡£ 5¡¢Çó²ÆÎñ²¿¹ÍÔ±µÄ×ÜÈËÊý 6¡¢Çó²ÆÎñ²¿ÊÕÈë×î¸ßµÄÔ±¹¤ÐÕÃû 7¡¢²éѯԱ¹¤ÊÕÈëµÄƽ¾ùÊý¡£ 8¡¢Ê¹ÓÃASC¢òº¯Êý·µ»Ø×Ö·û±í´ïʽ×î×ó¶Ë×Ö·ûµÄASC¢òÖµ¡£ 9¡¢Ê¹ÓÃCHAR( )º¯Êý½«ASC¢òÂë´ú±íµÄ×Ö·û×é³É×Ö·û´®¡£ 10¡¢Ê¹ÓÃLEFT£¨£©º¯Êý·µ»Ø´Ó×Ö·û´®¡®abcdef¡¯×ó±ß¿ªÊ¼µÄ3¸ö×Ö·û¡£ 11¡¢»ñµÃµ±Ç°µÄÈÕÆÚºÍʱ¼ä¡£ 12¡¢²éѯYGGLÊý¾Ý¿âÖÐÔ±¹¤ºÅΪ000001µÄÔ±¹¤³öÉúµÄÄê·Ý¡£ 13¡¢Ê¹ÓÃDAY£¨£©º¯Êý·µ»ØÖ¸¶¨ÈÕÆÚʱ¼äµÄÌìÊý¡£ 14¡¢ÁоٳöÆäËûµÄʱ¼äÈÕÆÚº¯Êý¡£