0

About Sql

Can you help me to solve the question here,please? The Question is:orders shipped more than 10days after their order date are to be given a refund of 10% of the total price.list the orderid of these orders,the number of days taken to ship the order,and the discount applicable (uses the ORD table) But my answer is Select orderid,ship price*0.1 where day =10order by orderid from order What is the problem of my answer?

8th Mar 2022, 8:06 AM
Kawing Shum
3 odpowiedzi
0
Looks like homework. If you have a more specific question or an attempt we can help you.
8th Mar 2022, 8:21 PM
William Jönsson
William Jönsson - avatar
0
Yes it is homework,but i just dont know how to do
9th Mar 2022, 6:26 AM
Kawing Shum
0
Maybe it's because you're not using the ORD table. Also it says more than 10 days, not 10 days exactly.
9th Mar 2022, 8:49 AM
William Jönsson
William Jönsson - avatar