✅ 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.
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.
