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?
3 Respuestas
0
Looks like homework. If you have a more specific question or an attempt we can help you.
0
Yes it is homework,but i just dont know how to do
0
Maybe it's because you're not using the ORD table.
Also it says more than 10 days, not 10 days exactly.