【文件属性】：
文件名称：SQL_Excel_Project_Capital_Bikeshare:使用Captial Bikeshare的MS数据集展示SQL和Excel专业知识的项目
文件大小：873KB
文件格式：ZIP
更新时间：2021-03-29 11:09:53
项目＃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)