carthook-2.sql

/*
1. Write a SQL query that returns names and emails of customers whose credit cards are about to get expired (in the next 14 days). Data model looks like this:*
1. Table Customer (id, name, address, email)
2. Table CustomerCreditCards(id,customer_id, ccnumber, cvs, expirationdate)
*/
SELECT name, email FROM Customer
INNER JOIN CustomerCreditCards
ON Customer.id  = CustomerCreditCards.customer_id
WHERE DATEDIFF(CustomerCreditCards.expirationdate,NOW()) <= 14;