About Sql

Question

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?

Answer 1

Looks like homework. If you have a more specific question or an attempt we can help you.

Answer 2

Yes it is homework,but i just dont know how to do

Answer 3

Maybe it's because you're not using the ORD table.
Also it says more than 10 days, not 10 days exactly.