山皮土施工方案.doc资源-CSDN下载

5 浏览量 2025-08-11 06:04:04 上传评论收藏 41KB DOC 举报

资源推荐

资源详情

资源评论

SELECT * FROM (SELECT count() h8_30_to_9 FROM store_sales, household_demographics, time_dim, store WHERE ss_sold_time_sk = time_dim.t_time_sk AND ss_hdemo_sk = household_demographics.hd_demo_sk AND ss_store_sk = s_store_sk AND time_dim.t_hour = 8 AND time_dim.t_minute >= 30 AND ( (household_demographics.hd_dep_count = 4 AND household_demographics.hd_vehicle_count <= 4 + 2) OR (household_demographics.hd_dep_count = 2 AND household_demographics.hd_vehicle_count <= 2 + 2) OR (household_demographics.hd_dep_count = 0 AND household_demographics.hd_vehicle_count <= 0 + 2)) AND store.s_store_name = 'ese') s1, (SELECT count() h9_to_9_30 FROM store_sales, household_demographics, time_dim, store WHERE ss_sold_time_sk = time_dim.t_time_sk AND ss_hdemo_sk = household_demographics.hd_demo_sk AND ss_store_sk = s_store_sk AND time_dim.t_hour = 9 AND time_dim.t_minute < 30 AND ( (household_demographics.hd_dep_count = 4 AND household_demographics.hd_vehicle_count <= 4 + 2) OR (household_demographics.hd_dep_count = 2 AND household_demographics.hd_vehicle_count <= 2 + 2) OR (household_demographics.hd_dep_count = 0 AND household_demographics.hd_vehicle_count <= 0 + 2)) AND store.s_store_name = 'ese') s2, (SELECT count() h9_30_to_10 FROM store_sales, household_demographics, time_dim, store WHERE ss_sold_time_sk = time_dim.t_time_sk AND ss_hdemo_sk = household_demographics.hd_demo_sk AND ss_store_sk = s_store_sk AND time_dim.t_hour = 9 AND time_dim.t_minute >= 30 AND ( (household_demographics.hd_dep_count = 4 AND household_demographics.hd_vehicle_count <= 4 + 2) OR (household_demographics.hd_dep_count = 2 AND household_demographics.hd_vehicle_count <= 2 + 2) OR (household_demographics.hd_dep_count = 0 AND household_demographics.hd_vehicle_count <= 0 + 2)) AND store.s_store_name = 'ese') s3, (SELECT count() h10_to_10_30 FROM store_sales, household_demographics, time_dim, store WHERE ss_sold_time_sk = time_dim.t_time_sk AND ss_hdemo_sk = household_demographics.hd_demo_sk AND ss_store_sk = s_store_sk AND time_dim.t_hour = 10 AND time_dim.t_minute < 30 AND ( (household_demographics.hd_dep_count = 4 AND household_demographics.hd_vehicle_count <= 4 + 2) OR (household_demographics.hd_dep_count = 2 AND household_demographics.hd_vehicle_count <= 2 + 2) OR (household_demographics.hd_dep_count = 0 AND household_demographics.hd_vehicle_count <= 0 + 2)) AND store.s_store_name = 'ese') s4, (SELECT count() h10_30_to_11 FROM store_sales, household_demographics, time_dim, store WHERE ss_sold_time_sk = time_dim.t_time_sk AND ss_hdemo_sk = household_demographics.hd_demo_sk AND ss_store_sk = s_store_sk AND time_dim.t_hour = 10 AND time_dim.t_minute >= 30 AND ( (household_demographics.hd_dep_count = 4 AND household_demographics.hd_vehicle_count <= 4 + 2) OR (household_demographics.hd_dep_count = 2 AND household_demographics.hd_vehicle_count <= 2 + 2) OR (household_demographics.hd_dep_count = 0 AND household_demographics.hd_vehicle_count <= 0 + 2)) AND store.s_store_name = 'ese') s5, (SELECT count() h11_to_11_30 FROM store_sales, household_demographics, time_dim, store WHERE ss_sold_time_sk = time_dim.t_time_sk AND ss_hdemo_sk = household_demographics.hd_demo_sk AND ss_store_sk = s_store_sk AND time_dim.t_hour = 11 AND time_dim.t_minute < 30 AND ( (household_demographics.hd_dep_count = 4 AND household_demographics.hd_vehicle_count <= 4 + 2) OR (household_demographics.hd_dep_count = 2 AND household_demographics.hd_vehicle_count <= 2 + 2) OR (household_demographics.hd_dep_count = 0 AND household_demographics.hd_vehicle_count <= 0 + 2)) AND store.s_store_name = 'ese') s6, (SELECT count() h11_30_to_12 FROM store_sales, household_demographics, time_dim, store WHERE ss_sold_time_sk = time_dim.t_time_sk AND ss_hdemo_sk = household_demographics.hd_demo_sk AND ss_store_sk = s_store_sk AND time_dim.t_hour = 11 AND time_dim.t_minute >= 30 AND ( (household_demographics.hd_dep_count = 4 AND household_demographics.hd_vehicle_count <= 4 + 2) OR (household_demographics.hd_dep_count = 2 AND household_demographics.hd_vehicle_count <= 2 + 2) OR (household_demographics.hd_dep_count = 0 AND household_demographics.hd_vehicle_count <= 0 + 2)) AND store.s_store_name = 'ese') s7, (SELECT count() h12_to_12_30 FROM store_sales, household_demographics, time_dim, store WHERE ss_sold_time_sk = time_dim.t_time_sk AND ss_hdemo_sk = household_demographics.hd_demo_sk AND ss_store_sk = s_store_sk AND time_dim.t_hour = 12 AND time_dim.t_minute < 30 AND ( (household_demographics.hd_dep_count = 4 AND household_demographics.hd_vehicle_count <= 4 + 2) OR (household_demographics.hd_dep_count = 2 AND household_demographics.hd_vehicle_count <= 2 + 2) OR (household_demographics.hd_dep_count = 0 AND household_demographics.hd_vehicle_count <= 0 + 2)) AND store.s_store_name = 'ese') s8

<think>我们正在优化一个涉及多个子查询的SQL查询，这些子查询用于过滤时间区间和人口统计条件，......

路基换填山皮土施工方案

一、工程简介

1、工程概况

五行路:起点为现状南环路，终点至人民西大街；起点桩号为K3+376.222，终点桩号为

K5+324.539，路线全长为1.948km。

3.0m（人行道）+11m（行车道）+2.0m（中央分隔带）+11m（行车道）+3.0m（人行

道），总宽30m。

车行道路面构造：4cm细粒式沥青混凝土（AC-13C，SBS 改性沥青）+6cm 中粒式沥青混

凝土（AC-20F）＋1cm下封层+18cm 水泥稳定碎石（7 天无侧限抗压强度不小于3.5MPa）+18cm

水泥稳定碎石（7 天无侧限抗压强度不小于3.0MPa）+15cm 石灰粉煤灰土（12：35：53），

总厚61cm。

人行道路面构造:人行道采用如下构造：9cm 铺装+15cm石灰土（10％）+15cm石灰土

（10％），总厚39cm。

义方街:起点为西环路（五名山大道），终点至现状南环路；起点桩号为K0+746.136，终点

桩号为K3+376.222，路线全长为2.630km。沿线设跨新开么河桥一座。

3.0m（人行道）+11m（行车道）+2.0m（中央分隔带）+11m（行车道）+3.0m（人行

道），总宽30m。

车行道路面构造：

4cm细粒式沥青混凝土（AC-13C，SBS 改性沥青）+6cm中粒式沥青混凝土（AC-20F）＋

1cm下封层+18cm水泥稳定碎石（7 天无侧限抗压强度不小于3.5MPa）+18cm水泥稳定碎石

（7 天无侧限抗压强度不小于3.0MPa）+15cm石灰粉煤灰土（12：35：53），总厚61cm。

人行道路面构造

人行道采用如下构造：9cm铺装+15cm石灰土（10％）+15cm石灰土（10％），总厚39cm。

本内容试读结束，登录后可阅读更多

下载后可阅读完整内容，剩余9页未读，立即下载

评论收藏

内容反馈

huono2599

粉丝: 0

山皮土施工方案.doc

pchqoAAA明渠施工方案.doc

小区道路施工方案.doc

毛石挡土墙施工组织方案.doc

2021-2022年收藏的精品资料沟塘处理施工方案.doc

全玻璃温室工程施工设计方案.doc

现浇箱梁施工组织方案.doc

驳岸工程施工组织设计方案.doc

土方开挖工程安全专项施工组织方案.doc

建筑施工组织2021-保证软土路基施工质量的方案.doc

关键施工技术工艺设计重点难点分析和解决方案.doc

建设工程施工设计方案范例.doc

临时施工便道工程施工设计方案(精).doc

经典排盐方案说明.doc

临时便道方案4.5米改.doc

广场东路工程监理安全规划_工程施工土建监理资料建筑监理工作规划方案报告.doc

加气砼砌块砌筑工程施工技术交底.doc

土方开挖工程安全专项施工组织设计及对策.doc

机场机坪与周边服务车道沥青摊铺、二跑道消防集.doc

高层煤矸石空心砖填充墙砌筑技术交底大全全套专项技术方案设计.doc

路面工程监理实施细则.doc

真空预压论文的相关材料.doc

最新scratch3.编程课件+源码.zip

青少年python编程课程体系四阶63节（仅含PPT）.zip

数据挖掘导论（完整版）PPT.

Python教程2020版 完全入门 达到Python工程师水平 笔记+代码+课件+资料

C#教程PPT完整版.rar

C语言程序设计（第4版）苏小红

2020最新_C++全套视频教程（首发）源码+笔记+课件

计算机网络谢希仁第七版全套课件.pdf

诸神缄默不语-个人技术博文与视频目录

最新资源

Python教程2020版完全入门达到Python工程师水平笔记+代码+课件+资料