2021-06-30

Some people think that the best way to reduce the time spent in travelling to work is to replace parks and gardens close to the city center with apartment buildings for commuters, but others disagree. Discuss both views and give your own opinion.

Nowadays, working efficiency has been attached increasing attention by all the commuters. The suggestion that residential areas can replace public areas to provide closer living condition is a hot topic supported by many. But I think it is not worth to sacrifice outdoor relaxing places to save time.

There are many aspects people should consider besides the convenience of going to work from home when developing a city. Since the urbanization leads to transfer the city into the concrete jungle, public areas, especially parks, play an essential part in citizens’ daily life which can bring a lot of greens to make the living environment more lively and energetic. The meaning of public places is more than beatifying the city; actually they have many practical functions which can provide an area for residents to do some outdoor activities to keep healthy, and for some old people and young kids, the places is where they can socialize with others to expend and maintain relationships.

However, it is undeniable that constructing more apartments is a good way to give workers more choices of where to live, helping them reduce the traveling time, by which they can also be released from the rush hours and have more time to relax. But the advantage does not mean the necessity of converting public areas into houses, because the high-quality living environment is priceless; meanwhile, many other effective methods can be regarded as the solution of a long commute, like improving the infrastructures of road and updating the public transportations.

In conclusion, although building more houses is an option to save people’s time, city planners should tend to think about the overall development to create a better living environment in the future; thus solving this problem can use various ideas.

在这里插入图片描述

以下是一个更复杂的 SQL 查询语句,它使用了多个子查询和窗口函数: WITH -- 定义一个子查询,获取销售额排名前10的产品 top_products AS ( SELECT product_id, SUM(sales) AS total_sales FROM orders WHERE order_date BETWEEN '2021-01-01' AND '2021-06-30' GROUP BY product_id ORDER BY total_sales DESC LIMIT 10 ), -- 定义一个子查询,获取销售额排名前10的客户 top_customers AS ( SELECT customer_id, SUM(sales) AS total_sales FROM orders WHERE order_date BETWEEN '2021-01-01' AND '2021-06-30' GROUP BY customer_id ORDER BY total_sales DESC LIMIT 10 ), -- 定义一个窗口函数,计算每个客户的销售额排名 customer_sales_rank AS ( SELECT customer_id, SUM(sales) AS total_sales, ROW_NUMBER() OVER (ORDER BY SUM(sales) DESC) AS sales_rank FROM orders WHERE order_date BETWEEN '2021-01-01' AND '2021-06-30' GROUP BY customer_id ) -- 最终查询,获取纽约市销售额排名前10的客户,以及他们购买的销售额排名前10的产品 SELECT customers.id AS customer_id, customers.name AS customer_name, products.id AS product_id, products.name AS product_name, SUM(orders.sales) AS total_sales FROM orders -- 连接顾客信息 INNER JOIN customers ON orders.customer_id = customers.id -- 连接产品信息 INNER JOIN products ON orders.product_id = products.id -- 仅查询纽约市的客户 WHERE customers.city = 'New York' -- 仅查询销售额排名前10的客户 AND customers.id IN (SELECT customer_id FROM top_customers) -- 仅查询销售额排名前10的产品 AND products.id IN (SELECT product_id FROM top_products) -- 仅查询客户销售额排名前10的订单 AND customers.id IN (SELECT customer_id FROM customer_sales_rank WHERE sales_rank <= 10) GROUP BY customers.id, customers.name, products.id, products.name ORDER BY customers.id, total_sales DESC, products.id;
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值