Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT c.account_id,
- CASE
- WHEN c.last_sale IS NULL AND MAX(s.sale_date) IS NOT NULL THEN MAX(s.sale_date)
- WHEN MAX(s.sale_date) IS NULL THEN c.last_sale
- WHEN MAX(s.sale_date) IS NOT NULL AND c.last_sale IS NOT NULL AND c.last_sale < s.sale_date THEN s.sale_date
- ELSE c.last_sale
- END AS 'sale_date'
- FROM customers c
- LEFT JOIN sales s ON c.account_id = s.account_id
- WHERE sale_date <> ''
- GROUP BY c.account_id
Add Comment
Please, Sign In to add comment