宋代社会风貌:美食天堂与特色生活

版权申诉
0 下载量 119 浏览量 更新于2024-09-11 收藏 1.13MB PPT 举报
在《美食的天堂-11万千气象的宋代社会风貌1》这一PPT文档中,主要探讨了宋代社会的多方面生活风貌,特别是其丰富的物质生活和精神生活。章节标题"美食的天堂"聚焦于宋朝时期的饮食文化,揭示了南北饮食的显著差异。 首先,北方饮食以面食和羊肉为主,如包子、饺子、索饼(面条)等,体现出北方人对于主食的偏好和羊肉的普遍食用。另一方面,南方则以米饭和鱼肉为主,反映了南方湿润气候下的饮食习惯,如浮团子(汤圆)、火腿和各种鱼类菜肴。 宋代的烹饪技术十分发达,提供了多种烹饪方法,如烹、烧、烤、炒、爆、溜、煮、炖、卤、蒸、腊、冻、腌等,展示了那个时代丰富多样的烹饪艺术。此外,还提及了当时的特色小吃,如焦碱水锥(炸元宵)、爆米花等,这些都体现了宋代人民的饮食生活丰富多彩。 在衣食住行的讨论中,宋朝初期政府曾推崇简朴,但随着经济发展,奢靡之风逐渐兴起,体现在服饰上,官僚贵族的服饰色彩与官位紧密相关,而普通百姓受限于制度,着装较为单一。女性则受到士大夫的影响,缠足陋习逐渐流传,反映出当时社会的性别角色和审美观念。 居住条件方面,农村居民以低矮的茅屋为主,城市平民的住所稍显讲究,内部结构可能较为简单。贵族官邸则更为豪华,配有附属设施。交通方面,宋朝的交通网络发达,尤其是达官贵人的出行普遍使用车辆,旅店业也随之兴盛。 瓦子是宋代城市中的重要娱乐场所,集娱乐与商业于一体,如东京城内的瓦子设有表演区域,成为市民文化生活的重要组成部分。宋代的传统节日,如春节、元宵节、端午节和中秋节等都受到重视,尤其是春节被视为新年,是全年最重要的节日,有着丰富的庆祝习俗。 这个PPT通过深入挖掘宋代社会的衣食住行以及节日文化,展现了那个时期繁荣且多元的社会面貌,尤其突出了饮食作为日常生活中不可或缺的一部分,是理解宋代社会的一个重要窗口。

优化代码,并提供新脚本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'))

2023-05-25 上传

优化代码SELECT SUM(IF(order_date BETWEEN '2022-10-31' AND '2022-11-11' AND is_new_customer = 1, 1, 0)) AS new_customer_count, SUM(IF(order_date BETWEEN '2022-10-31' AND '2022-11-11' AND is_new_customer = 0, 1, 0)) AS old_customer_count, SUM(IF(order_date BETWEEN '2022-10-31' AND '2022-11-11' AND is_new_customer = 1, payment_amount, 0)) AS new_customer_payment_amount, SUM(IF(order_date BETWEEN '2022-10-31' AND '2022-11-11' AND is_new_customer = 0, payment_amount, 0)) AS old_customer_payment_amount, SUM(IF(order_date BETWEEN '2022-10-31' AND '2022-11-11' AND category = 'A', 1, 0)) AS category_A_customer_count, SUM(IF(order_date BETWEEN '2022-10-31' AND '2022-11-11' AND category = 'A', payment_amount, 0)) AS category_A_payment_amount, SUM(IF(order_date BETWEEN '2022-10-31' AND '2022-11-11' AND category = 'B', 1, 0)) AS category_B_customer_count, SUM(IF(order_date BETWEEN '2022-10-31' AND '2022-11-11' AND category = 'B', payment_amount, 0)) AS category_B_payment_amount, SUM(IF(order_date BETWEEN '2022-10-31' AND '2022-11-11' AND product_id = 'P1', 1, 0)) AS product_P1_customer_count, SUM(IF(order_date BETWEEN '2022-10-31' AND '2022-11-11' AND product_id = 'P1', payment_amount, 0)) AS product_P1_payment_amount FROM orders o LEFT JOIN (SELECT DISTINCT order_date FROM orders WHERE order_date BETWEEN '2022-10-31' AND '2022-11-11') d1 ON o.order_date = d1.order_date LEFT JOIN (SELECT DISTINCT order_date FROM orders WHERE 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')) d2 ON o.order_date = d2.order_date LEFT JOIN (SELECT DISTINCT order_date FROM orders WHERE 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')) d3 ON o.order_date = d3.order_date WHERE d1.order_date IS NOT NULL OR d2.order_date IS NOT NULL OR d3.order_date IS NOT NULL;

2023-05-25 上传