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 Réponses

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.