Sales Tax Exemption Certificate Expiry SQL Generator

SELECT c.customer_id, c.customer_name, e.state_code, e.certificate_no, e.expiry_date,
       DATEDIFF(day, GETDATE(), e.expiry_date) AS days_left
FROM customer_tax_exemption e
JOIN customer c ON c.customer_id = e.customer_id
WHERE e.expiry_date <= DATEADD(day, 60, GETDATE())
ORDER BY e.expiry_date;

SELECT c.customer_id, c.customer_name, e.state_code, e.certificate_no, e.expiry_date,
       (e.expiry_date::date - CURRENT_DATE) AS days_left
FROM customer_tax_exemption e
JOIN customer c ON c.customer_id = e.customer_id
WHERE e.expiry_date <= CURRENT_DATE + INTERVAL '60 days'
ORDER BY e.expiry_date;

SELECT c.customer_id, c.customer_name, e.state_code, e.certificate_no, e.expiry_date,
       TRUNC(e.expiry_date) - TRUNC(SYSDATE) AS days_left
FROM customer_tax_exemption e
JOIN customer c ON c.customer_id = e.customer_id
WHERE e.expiry_date <= SYSDATE + 60
ORDER BY e.expiry_date;

SELECT c.customer_id, c.customer_name
FROM customer c
LEFT JOIN customer_tax_exemption e ON e.customer_id = c.customer_id
WHERE e.certificate_no IS NULL;
-- Add your own filter on the column that marks a customer as tax exempt.