ã¯ã¨ãªã®å®è¡æéãé·ãããå ´åãããªã½ã¼ã¹ã®æ¶è²»æ°ãå¤ãããå ´åã¯ãã¯ã¨ãªããã£ã³ã»ã«ãã¾ãããã®ä¾ã¨ãã¦ã¯ããã±ãã販売è ã®ååã¨è²©å£²æ¸ã¿ã®ãã±ããæ°ãè¨è¼ãããªã¹ãããä½æãããã¨ãã¦ãããããªå ´åãæãããã¾ãã以ä¸ã®ã¯ã¨ãªã§ã¯ãSALES ãã¼ãã«ã¨ USERS ãã¼ãã«ãããã¼ã¿ãé¸æããWHERE å¥å 㧠SELLERID 㨠USERID ãä¸è´ããããã¨ã§ 2 ã¤ã®ãã¼ãã«ãçµåãã¦ãã¾ãã SELECT sellerid, firstname, lastname, sum(qtysold) FROM sales, users WHERE sales.sellerid = users.userid GROUP BY sellerid, firstname, lastname ORDER BY 4 desc;çµæã¯ä»¥ä¸ã®ããã«ãªãã¾ãã sellerid | firstnam
{{#tags}}- {{label}}
{{/tags}}