puzzleup2012谜题，请用SQL或PLSQL解答

newkid

udfrog 发表于 2012-12-7 06:56
这题初看真一懵,还好nk给了信心先,"纸老虎"很关键啊.不过你这为啥要两表关联呢.

没必要关联，我当时想的时候是两拨人分开的，所以用了两个子查询。

lastwinner

newkid 发表于 2012-12-6 02:00
花花说得对，我那个公式是错的，比如7题分5个人就错了，应该直接用CEIL。

哈，还真是有问题，我没找小的数去检验

〇〇

结束了，目前榜单只有2个CHINA

Click here to see all the puzzles. Puzzleup 2012 has come to an end. You may send or review your answers until the 26th of December at 10:59 GMT. Final score table will be announced in the first two weeks of January. Good luck to everyone.

Top 10 - Competitors 1. Vincent Lefèvre 990 1. Sergey Shtyka 990 1. Yılmaz Ekici 990 1. Romon Christian 990 1. Daniel Collignon 990 1. Pi-hung Liu 990 1. Chia-tche Chang 990 1. Clive Dawson 990 1. Alexander Bichek 990 1. Bi Zqh 990