quote:

---

Originally posted by kbreitsprecher

Ok, I'm sorry I can't answer all your questions because I don't know what some of them mean. But I will try my best.

The question is from Chapter 6, Question 40 from Modern Database Management, tenth edition by Hoffer, Ramesh and Topi. And it is exactly:

"For each order, list the order ID, customer ID, order date, and most recent date among all orders."

the Order_t table has the following fields, OrderID, OrerDate, FullfillmentDate,Salesperson and ShipAdrsID.

I assumed the question wanted a list that would look something like this.

OrderId CustomerId OrderDate MostRecentDate
1 1 10/10/1990 10/21/2001
2 1 10/21/2001 10/21/2001
4 2 1/12/1998 1/12/1998
3 3 5/26/2010 4/30/2011
6 3 4/30/2011 4/30/2011
etc

I don't know what you mean by DDL and all the constraints. I know DDL stands for Data Definition Language, something I learned from this course, but I don't know exactly what your asking me.

I do know what books online is, and I don't have SQL server installed. I am using Access(it is what my teacher is using), and Universal SQL Editor.

So I don't know exactly what the question is asking, only my interpretation of it.

---

OrderId CustomerId OrderDate   MostRecentDate
1       1          10/10/1990  10/21/2001
2       1          10/21/2001  10/21/2001
4       2           1/12/1998   1/12/1998
3       3           5/26/2010   4/30/2011
6       3           4/30/2011   4/30/2011

OrderID	OrderDate			CustomerID	FulfillmentDate		SalesPersonID	ShipAdrsID
1		2009-09-08 00:00:00	4			2009-11-25 00:00:00	3				(null)
2		2009-10-04 00:00:00	3			(null)				3				(null)
3		2009-07-19 00:00:00	1			(null)				2				(null)
4		2009-11-01 00:00:00	6			(null)				5				(null)
5		2009-07-28 00:00:00	4			(null)				3				(null)
6		2009-08-27 00:00:00	4			(null)				3				(null)
7		2009-09-16 00:00:00	1			(null)				2				(null)
8		2009-09-16 00:00:00	4			(null)				3				(null)
9		2009-09-16 00:00:00	6			(null)				5				(null)
19		2010-03-05 00:00:00	4			(null)				3				(null)