Counting the number of days between dates
In this exercise, you will calculate the difference between the order date and ship date.
Deze oefening maakt deel uit van de cursus
Intermediate SQL Server
Oefeninstructies
Write a query that returns the number of days between OrderDate and ShipDate.
Praktische interactieve oefening
Probeer deze oefening eens door deze voorbeeldcode in te vullen.
-- Return the difference in OrderDate and ShipDate
SELECT OrderDate, ShipDate,
___(___, OrderDate, ShipDate) AS Duration
FROM Shipments