18. Write a query to display the sales order IDs and the credit card IDs of those cards which are expiring in the year 2007.

select salesOrderIds, CreditcardID
from sales.salesOrderHeader
where CreditCardID in (select CreditcardID
from sales.CreditCard where ExpYear=2007)