#TIL Result of guess and win price of dinner with help of steemsql.com | 通过steemsql.com的帮助,找出猜测晚餐话费的结果 (by @ace108)

in cn •  7 years ago  (edited)

In this previous post where I shared my dinner, I asked to guess how much I paid for dinner:
之前的这一帖里,我要大家猜猜那晚餐花了我多少钱。
FIRST14
#BeautifulSunday. #Eatwithme. Before the close encounter of the matcha cake | 亲密接触抹茶蛋糕之前

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 Summer.
让大家继续读的时候,欣赏一点音乐。这件作品是维瓦尔第的“四季”的一部分 - 4小提琴协奏曲中的第一首,名为“夏天”。
Source | 来源: https://musopen.org/

Source: https://musopen.org/music/2213/antonio-vivaldi/the-four-seasons/ Violin Concerto in G minor, RV 315 'Summer' - Complete Concerto

Reviewing what I ate again | 再看看之前吃过的

Green tea.
绿茶。
SSS100
IMAGE LINK|图片链接: https://supload.com/SJeiIZfSS-

Fried chicken.
炸鸡。
SSS110
IMAGE LINK|图片链接: https://supload.com/BJZoUbMSS-

Gyozas.
锅贴。
SSS130
IMAGE LINK|图片链接: https://supload.com/BJXoIbGBSZ

Maki.
寿司。
SSS150
IMAGE LINK|图片链接: https://supload.com/rJrsU-MBr-

Chawan mushi.
茶碗蒸。
SSS160
IMAGE LINK|图片链接: https://supload.com/BkltYWfHBW

Matcha cake.
抹茶蛋糕。
SSS180
IMAGE LINK|图片链接: https://supload.com/HybKY-fHSZ

Recognise this cake now?
认得这蛋糕了吗?

Result of Guess and win | 猜测赢奖结果

The total price for the dinner was $36.60. Was your guess right or close?
晚餐总消费$36.60. 你的猜测对或茶不多?
SSS190
IMAGE LINK|图片链接: https://supload.com/ByGU-oPH-


Now, for the #TIL, I learn to use steemsql.com to extract comments for the post.
现在,学会了使用 steemsql.com 来提取对帖的回复。
SSS10
IMAGE LINK|图片链接: https://supload.com/Hyr11VCSW

Comparing the data and the comments and looks about right.
比较数据和回复。看来差不多。
SSS20
IMAGE LINK|图片链接: https://supload.com/SyDIkECBZ

Go through the data and find the winner.
经过数据并找到获胜者。
SSS30
IMAGE LINK|图片链接: https://supload.com/H155WNCB-

The winner is @incrediblesnow | 获奖者是 @incrediblesnow

UserCommentsPrice differences
@kitcatI would guess $39.5! :) delicious dishes!2.9
@foodie.warriorOMG I'm so hungry, and greener than the matcha cake!! This is fun! I would guess, on average: Rainbow maki - $11 Chawanmushi - $4 Tori Karaage - $9 Gyoza - $3.50 Green Tea - $2 each = $4 Matcha crepe cake = $5.50 Wet towels = $.40 each = $.80 TOTAL w/0 GST =$37.80 **TOTAL w GST OF 7% = $40.45**3.85
@incrediblesnow我猜$414.4
@travelgirlI'll take a guess - $34.50 :)2.1
Guess was not the exact total price. So, price to be transfer will be 1 steem.
猜测不是最准确的全消费。所以,将送出的奖金是1 steem.

Using steemsql.com helps quite a bit though there is still room for improvement in the process.
使用steemsql.com帮助很多,虽然仍有改进的空间。


ACE108-SignaturePhoto167f6.png
FIRST2
Steemitphotochallenge 📷 # 45 - Entry 3 Yellow Bell | 作品3 黄钟花 ()
FIRST3
📸🏙 YourCityVibez Entry• YCV 8 - Waiting for fireworks
FIRST4
📷🍨Color Challenge, Wednesday Yellow - My tip on how to shoot ice cream indoor | 拍摄雪糕小贴士🍨
FIRST5
Meme challenge # 26 - We blog and get paid? (@ace108)
FIRST6
📷🌳Banana trees in the school for #treetuesday | 学校里的香蕉树
FIRST7
📸 bwphotocontest Entry 1 - Singapore Marriott Tang Plaza Hotel | 黑白照片比赛作品1 - 新加坡万豪酒店
FIRST8
Meme challenge # 26 - Frappucino? Seriously? (@ace108)
FIRST9
🎆🎆🥂1st Anniversary 49 SBD Giveaway result - rep 71 recently | 1周年送49SBD奖结果 - 最近的信誉达71

Please see my other posts: @ace108
请看我其他帖: @ace108

ACE108-SignatureV1Bc45c8.gif
FollowACE108-1cdc5f.gif

I See👀. I Shoot📷. I Steemit♨️.


Authors get paid when people like you upvote their post.
If you enjoyed what you read here, create your account today and start earning FREE STEEM!
Sort Order:  

Very delicious food. Interesting. Thank you. I'm DOCTOR OATMEAL from the Original Oregon Island. I'm the one & only JOEY ARNOLD of VIETNAM HAWAII. I'm the Ghetto Joe Cool Kid of MAGA.

Send in proccess | 送出途中...

谢谢你!支持你!

不客气。

看起来真好吃呀.

还好。尤其蛋糕。👍。
谢谢捧场。

覺得千層蛋糕好吃的話記得要試試lady M 喔 保證一試難忘

Nice dinner! 我也要学steemsql

Good especially the cake. steemsql. 好玩。值得研究。但如果会Python可能更快。下一站吧。

I‘ve only learned traditional sql. Seems like it's really useful to learn Python, but I'm really bad at programming. Learned java, C# before, didn't work out.

哇!不错哦!我错过了😝

哈哈,以后还有机会。

wow impressive

Thank you and thanks for your comment.

Very good job writing that query!

Thank you. Still starting out much figuring out to be done but the fun begins.

those are pretty greta picture

Thank you and thanks for your comment

Nice meal. Congrats to the winner.

Thank you and thanks for stopping to leave a comment.

Mmm. The food looks really delicious. Lucky you. X

We have good variety of food cheap and more luxury. So, you could say lucky.
Thanks for your comment

Matcha cake looks so delicious! :)

yes. I'm hungry for one now.😎

Great post! Do check out my easy sausage gravy for lazy people like me ,hhahhttps://steemit.com/food/@alexkoshy/easy-to-make-sausage-gravy-for-lazy-people-like-me

Congrats to the winner :)

Thank you.

Yay I got the correct price for Rainbow Maki!! :))

My tori karaage guess was too expensive haha also, the GST is already included in the prices.. :) This was a fun challenge, @ace108! :)

Yes, this time round people were quite close too.

pls follow me. and also like my post you will like this

https://steemit.com/food/@soni786/buffalo-chicken-drumsticks-with-blue-cheese-dip

Thank for reading and leaving a comment. I'll suggest you don't cut and paste your same comment to many posts as it can be considered spam. There is risk of being flag.