harsha547
3/11/2017 - 5:00 PM

Days to ship the product to customer

Days to ship the product to customer

--Download the super samplestore database for SQL Server

SELECT  [Product Name], 
		[Order Date],[Ship Date] , 
		DATEDIFF("d",[Order Date],[Ship Date]) As 'Shipping Days'
 FROM Orders 
 ORDER BY [Shipping Days] Desc