054_cards_issued_difference.md

SQL Everyday #054

Cards Issued Difference

Site: DataLemur
Difficulty per Site: Easy

Problem

Your team at JPMorgan Chase is preparing to launch a new credit card, and to gain some insights, you're analyzing how many credit cards were issued each month.

Write a query that outputs the name of each credit card and the difference in the number of issued cards between the month with the highest issuance cards and the lowest issuance. Arrange the results based on the largest disparity. [Full Description]

Submitted Solution

-- Submitted Solution
SELECT 
  card_name
  ,MAX(issued_amount) - MIN(issued_amount) AS difference 
FROM monthly_cards_issued
GROUP BY card_name
ORDER BY difference DESC
;

Site Solution

-- DataLemur Solution 
-- Site solution is essentially the same.

Notes

TODO

Go to Table of Contents
Go to Overview