Who is the winner? | 谁是赢家？

IMAGE LINK|图片链接: https://supload.com/BJewu-AVef

Image source: www.pixabay.com

So you ran a contest and people are supposed to leave a comment with the guess/answer. Now, how do you figure out who came and what comment? This was the post in which I had a contest recent:

那你举办了一场比赛或游戏，人们应该对猜测/答案留言。现在，又如何知道谁参于和谁和谁的答案？这是我最近参加比赛的帖：

📷#colorchallenge #yellowwednesday #dailyfoodphotography • and chance to WIN 8 steem | 赢8Steem游戏

🎶Meanwhile, some music for you to enjoy as you read. This piece is part of Vivaldi’s The Four Seasons, particular the first of the 4 violin concertos, called Winter.
🎶让大家继续读的时候，欣赏一点音乐。这件作品是维瓦尔第的“四季”的一部分 - 4小提琴协奏曲中的第一首，名为“冬天”。
Source | 来源: https://musopen.org/

Working on the result… | 找出结果。。。

First, take a look at my last contest and note the Title and the link.

首先，看看我的游戏帖，注意标题和链接。

Title: 📷#colorchallenge #yellowwednesday #dailyfoodphotography • and chance to WIN 8 steem | 赢8Steem游戏 (by @ace108)
Link:

https://steemit.com/colorchallenge/@ace108/colorchallenge-yellowwednesday-dailyfoodphotography-and-chance-to-win-8-steem-or-8steem-by-ace108#@homeartpictures/re-ace108-colorchallenge-yellowwednesday-dailyfoodphotography-and-chance-to-win-8-steem-or-8steem-by-ace108-20171122t074233205z

Then, let's find the level 1 comment on that post with this SQL.

然后，让我们用这个SQL找到关于该帖的第1层留言。

select 
cmd.created created_wo_time, 
'@' + cmd.author commenter, 
cmd.body Full_comments
from 
   Comments cmd WITH (NOLOCK)
where 
    ( cmd.depth = 1)
and (cmd.root_title like '%#colorchallenge #yellowwednesday #dailyfoodphotography%and chance to WIN 8 steem%|%by @ace108)%')     ---- POST TITLE
and cmd.parent_author = 'ace108'
order by 
created_wo_time desc, commenter

Notice the condition for root_title. I did that to avoid the emoji and non-English characters which sometimes don't work very well but I'm sure it gets the comment for my contest post.

注意 root_title 的条件。我这样做是为了避免表情符号和非英文字符，这些字符有时候给不好的效果，但是我相信这会得到我要看的留言。

Now, who gave the answer according to the format I want which I consider as participating. Let's fine tune the SQL. I want the comment like '%1%2%3%' to be considered as entry. But who then is the winner? My answer is 1-F 2-S 3-A. That means must fine tune the SQL some more so the comment must be like '%1%F%2%S%3%A%'. Were there any? Let’s see my updated SQL query.

现在，谁按照我规定的模式提交答呢？我们调整之前的SQL，我要有“％1％2％3％”这样的留言。但那谁是赢家呢？我的答案是1-F 2-S 3-A。这指必须再调我的SQL，所以留言必须是'％1％F％2％S％3％A％'模式。有没有？让我们看看我更新的SQL查询。

select 
cmd.created created_wo_time, 
'@' + cmd.author commenter, 
cmd.body Full_comments,
case when 
    ( cmd.body like '%1%2%3%' )
then
    'Yes' 
else 
    'No'
end Entry,
case when 
    ( cmd.body like '%1%F%2%S%3%A%' )
then
    'Maybe' 
else 
    'No Way'
end Right_Answer
from 
   Comments cmd WITH (NOLOCK)
where 
    ( cmd.depth = 1)
and (cmd.root_title like '%#colorchallenge #yellowwednesday #dailyfoodphotography%and chance to WIN 8 steem%|%by @ace108)%')     ---- POST TITLE
and cmd.parent_author = 'ace108'
order by 
created_wo_time desc, commenter

I ran it and exported to Excel and look.

我跑了这SQL把结果输出到 Excel 去看看。

IMAGE LINK|图片链接:

The “Entry” column looks like need improvement. Anyone has any suggestion?/

“Entry”那列好像有问题。有朋友提议怎么改进吗？

3 “Maybe”s. Is there a tie?

3 个“Maybe”=”可能”。需要打破僵局吗？

In the contest, the food photo quite obviously included rice and vegetables but the meat was what I thought will be doubtful. A couple guess chicken and the answer is fish.