#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:
之前的这一帖里,我要大家猜猜那晚餐花了我多少钱。
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 | 再看看之前吃过的
绿茶。
Fried chicken.
炸鸡。
Gyozas.
锅贴。
Maki.
寿司。
Chawan mushi.
茶碗蒸。
Matcha cake.
抹茶蛋糕。
Recognise this cake now?
认得这蛋糕了吗?
Result of Guess and win | 猜测赢奖结果
晚餐总消费$36.60. 你的猜测对或茶不多?
Now, for the #TIL, I learn to use steemsql.com to extract comments for the post.
现在,学会了使用 steemsql.com 来提取对帖的回复。
Comparing the data and the comments and looks about right.
比较数据和回复。看来差不多。
Go through the data and find the winner.
经过数据并找到获胜者。
The winner is @incrediblesnow | 获奖者是 @incrediblesnow
User | Comments | Price differences |
@kitcat | I would guess $39.5! :) delicious dishes! | 2.9 |
@foodie.warrior | OMG 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 | 我猜$41 | 4.4 |
@travelgirl | I'll take a guess - $34.50 :) | 2.1 |
猜测不是最准确的全消费。所以,将送出的奖金是1 steem.
Using steemsql.com helps quite a bit though there is still room for improvement in the process.
使用steemsql.com帮助很多,虽然仍有改进的空间。
Please see my other posts: @ace108
请看我其他帖: @ace108
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