Counting the number of days between dates
In this exercise, you will calculate the difference between the order date and ship date.
Bu egzersiz
Intermediate SQL Server
kursunun bir parçasıdırEgzersiz talimatları
Write a query that returns the number of days between OrderDate and ShipDate.
Uygulamalı interaktif egzersiz
Bu örnek kodu tamamlayarak bu egzersizi bitirin.
-- Return the difference in OrderDate and ShipDate
SELECT OrderDate, ShipDate,
___(___, OrderDate, ShipDate) AS Duration
FROM Shipments