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


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


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
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
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♨️.



H2
H3
H4
3 columns
2 columns
1 column
31 Comments