17. Write a query to display the details of those orders for which no discount was offered

select* from sales.salesOrderDetail
Where specialofferID=(select spcialofferID
from sales.specialoffer where type= 'No Discont')