JPMorgan Chase SQL Interview Question | DataLemur

Wed Oct 09 2024 10:54:36 GMT+0000 (Coordinated Universal Time)

Saved by @vhasepta

SELECT card_name, max(issued_amount)-min(issued_amount)as diffrence
FROM monthly_cards_issued
GROUP BY card_name
ORDER BY 2 desc;