between and 效率_so-and-so,总感觉哪里不对,但它是正确的

#学浪计划# #英语丰富多彩的习语# #英语#

乍看就把 so-and-so 跟 and so on 挂上钩,实际上 so-and-so 跟我们想象的意思差很多,它是一个习惯用语,可以意为“某某人(或事物);恼人的家伙;讨厌鬼”等,通常是指叫不上名字的人、物,或泛指,寓意:

8a86dc9af68c6126826ced3ec609e293.png

used in the place of someone's name, indicating that the person is of little importance

用来代替某人的名字,表示这个人不重要

used in place of a person or thing when you are speaking generally

当大体上描述时,用来代替人或物

it can also be used as euphemism to describe an unpleasant person

它也可以作为委婉语来形容一个令人不快的人

can be used in place of a swear word

可以用来代替脏话

79672a0b7c6b95797fb5a80c67f71ab5.png

解析:swear word 意为“诅咒语,骂人的话,脏话”。

例如:

I love how June is always telling us how she met so-and-so on her travels. Everyone knows that she is making it up.

我喜欢琼总是告诉我们她是如何在旅行中认识某某的。大家都知道她在编造。

解析:短语动词 make up 除了“编造”的意思,还有“形成;拼装;凑数;配药;临时铺床”等意思。

e43ec47c997119a9b73b66a16339e553.png

Book club is mostly used for gossiping. Peter bought a new car, so-and-so had surgery on her face.

读书俱乐部主要是用来说三道四的。彼得买了一辆新车,某某做了脸部手术。

解析:so-and-so 的复数形式是 so-and-sos.

You are welcome to bring so-and-so to our party on Friday night. We don't bother remembering their names anymore.

欢迎你星期五晚上带某某来参加我们的聚会。我们不再费心记住他们的名字了。

解析:bother 后面还可以接带 to 不定式,例如:

a1226291fb6f0bb6a0e9030a9a6a66c7.png

He hasn't even bothered to write.

他甚至懒得写信。

My new boss is a real so-and-so. He is rude to everyone.

我的新老板真是个恼人的家伙。他对每个人都很粗鲁。

优化代码,并提供新脚本SELECT SUM(CASE WHEN order_date BETWEEN '2022-10-31' AND '2022-11-11' AND is_new_customer = 1 THEN 1 ELSE 0 END) AS new_customer_count, SUM(CASE WHEN order_date BETWEEN '2022-10-31' AND '2022-11-11' AND is_new_customer = 0 THEN 1 ELSE 0 END) AS old_customer_count, SUM(CASE WHEN order_date BETWEEN '2022-10-31' AND '2022-11-11' AND is_new_customer = 1 THEN payment_amount ELSE 0 END) AS new_customer_payment_amount, SUM(CASE WHEN order_date BETWEEN '2022-10-31' AND '2022-11-11' AND is_new_customer = 0 THEN payment_amount ELSE 0 END) AS old_customer_payment_amount, SUM(CASE WHEN order_date BETWEEN '2022-10-31' AND '2022-11-11' THEN CASE WHEN category = 'A' THEN 1 ELSE 0 END ELSE 0 END) AS category_A_customer_count, SUM(CASE WHEN order_date BETWEEN '2022-10-31' AND '2022-11-11' THEN CASE WHEN category = 'A' THEN payment_amount ELSE 0 END ELSE 0 END) AS category_A_payment_amount, SUM(CASE WHEN order_date BETWEEN '2022-10-31' AND '2022-11-11' THEN CASE WHEN category = 'B' THEN 1 ELSE 0 END ELSE 0 END) AS category_B_customer_count, SUM(CASE WHEN order_date BETWEEN '2022-10-31' AND '2022-11-11' THEN CASE WHEN category = 'B' THEN payment_amount ELSE 0 END ELSE 0 END) AS category_B_payment_amount, SUM(CASE WHEN order_date BETWEEN '2022-10-31' AND '2022-11-11' THEN CASE WHEN product_id = 'P1' THEN 1 ELSE 0 END ELSE 0 END) AS product_P1_customer_count, SUM(CASE WHEN order_date BETWEEN '2022-10-31' AND '2022-11-11' THEN CASE WHEN product_id = 'P1' THEN payment_amount ELSE 0 END ELSE 0 END) AS product_P1_payment_amount FROM orders WHERE (order_date BETWEEN '2022-10-31' AND '2022-11-11') OR (order_date BETWEEN '2021-10-31' AND '2022-10-30' AND order_date NOT IN (SELECT order_date FROM orders WHERE order_date BETWEEN '2022-10-31' AND '2022-11-11')) OR (order_date BETWEEN '2021-11-12' AND '2022-10-30' AND order_date IN (SELECT order_date FROM orders WHERE order_date BETWEEN '2022-10-31' AND '2022-11-11'))
05-25
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值