文件名称：SQL_Excel_Project_Capital_Bikeshare:使用Captial Bikeshare的MS数据集展示SQL和Excel专业知识的项目
文件大小：873KB
文件格式：ZIP
更新时间：2024-04-18 04:56:33
项目＃1-SQL和Excel-Capital Bikeshare 问题：每年每个月有几次旅行？ 询问： WITH MONTH_WISE_TRIPS AS ( SELECT DATE_PART( ' YEAR ' , START_TIME) AS YEAR, DATE_PART( ' MONTH ' , START_TIME) AS MONTH, COUNT ( * ) AS NUM_TRIPS FROM CAPITALBIKESHARE_2019 GROUP BY 1 , 2 UNION ALL SELECT DATE_PART( ' YEAR ' , START_TIME) AS YEAR, DATE_PART( ' MONTH ' , START_TIME) AS MONTH, COUNT ( * ) AS NUM_TRIPS FROM CAPITALBIKESH
【文件预览】：
SQL_Excel_Project_Capital_Bikeshare-main
----Project_SQL__Excel - Capital_Bikeshare.pdf(436KB)
----README()
--------Untitled12.png(186KB)
--------Untitled7.png(62KB)
--------Untitled10.png(26KB)
--------Untitled9.png(45KB)
--------Untitled.png(49KB)
--------Untitled4.png(36KB)
--------Untitled3.png(18KB)
--------Untitled6.png(68KB)
--------Untitled1.png(29KB)
--------Untitled2.png(29KB)
--------Untitled8.png(58KB)
--------Untitled11.png(27KB)
--------Untitled5.png(27KB)
----README.md(13KB)