tags:

views:

67

answers:

3

im doing some practice sql problems

one of the questions is:

Prepare a shipping statement for customer 'C001' it should show the date, the legend 'Delivery' and the total value of the products shipped on each day.

'delivery' is not a table nor is it a column in any table.

what does legend mean??

+3  A: 

It doesn't mean anything in SQL. In English it means the label at the top of the column or next to the data that explains what the data is.

In other words, produce a listing showing the customer number, the date, and a column labeled "Delivery" that shows the total value of goods shipped to that customer on that date.

Larry Lustig
+1  A: 

In this case I think it means the title for the shipping statement.

From the dictionary -

Legend

3 an inscription, esp. on a coin or medal. • a caption : a picture of a tiger with the legend “Go ahead, make my day.” • the wording on a map or diagram explaining the symbols used

Robert Conn
+1  A: 

"Legend" is not strictly speaking an SQL term - but in that case it is used to indicate the name of the column. Somewhat poor naming, since legend actually means overall set of labels/explanations and not a single label

DVK