德国格式
编写查询，显示每一天以及纽约市各 Borough 的 TotalDistance、TotalRideTime 和 TotalFare。以德国本地化格式显示日期、距离、行程时长和费用总计。
本练习是课程的一部分
SQL Server 中的函数与存储过程编写
练习说明
- 将
PickupDate转换为date并以德国日期格式显示。 - 按德国数字格式显示
TotalDistance和TotalRideTime（'n'格式类型参数）。 - 按德国货币格式显示
Total Fare（'c'格式类型参数）。
交互式实操练习
通过完成这段示例代码来试试这个练习。
SELECT
-- Cast PickupDate as a date and display as a German date
___(___(___ AS date), 'd', 'de-de') AS 'PickupDate',
Zone.Borough,
-- Display TotalDistance in the German format
___(SUM(TripDistance), '___', 'de-de') AS 'TotalDistance',
-- Display TotalRideTime in the German format
___(SUM(DATEDIFF(minute, PickupDate, DropoffDate)), '___', 'de-de') AS 'TotalRideTime',
-- Display TotalFare in German currency
___(SUM(TotalAmount), '___', 'de-de') AS 'TotalFare'
FROM YellowTripData
INNER JOIN TaxiZoneLookup AS Zone
ON PULocationID = Zone.LocationID
GROUP BY
CAST(PickupDate as date),
Zone.Borough
ORDER BY
CAST(PickupDate as date),
Zone.Borough;