✅ SQL code
"Create a procedure that receives a value in the variable, 'NoDays' (int), to
check how many days there are between the order date and shipment and to
See which freighters have been used. Where shipping has begun less than 2 weeks
within RequiredDate.
Run the procedure and search for the ships where the time between the order date and the
Shipping is longer than 30 days.
Show the employee's first name (responsible for the order), the ship's name and the time between
and RequiredDate as "Time between Shipping and Required Date".
Use the DATEDIFF() function. The result is 20 lines."
I have written this program and it works but i can´t seem to get the order right, i don´t really understand in what order it is supposed to be in.
5 Replies
the problem asks you to use the name for ordering
Hmm okay but this is the photo our teacher gives us and it’s not in alphabetical order
because it is wrong
point that out to the teacher
in the problem it clearly says to order by name
Yes okay thank you!
!close
Closed!