JP Morgan Phase SQL Interview Question | SQL Interview Preparation | Easy-level

Learn how to calculate monthly differences in credit card issuance using real-world data from JPMorgan Chase. Table: monthly_cards_issued Script - -- Create the table CREATE TABLE credit_card_issuance ( card_name VARCHAR(50) NOT NULL, issued_amount INT NOT NULL, issue_month TINYINT NOT NULL CHECK (issue_month BETWEEN 1 AND 12), issue_year YEAR NOT NULL, PRIMARY KEY (card_name, issue_month, issue_year) ); -- Insert the data INSERT INTO credit_card_issuance (card_name, issued_amount, issue_month, issue_year) VALUES ('Chase Freedom Flex', 55000, 1, 2021), ('Chase Freedom Flex', 60000, 2, 2021), ('Chase Freedom Flex', 65000, 3, 2021), ('Chase Freedom Flex', 70000, 4, 2021), ('Chase Sapphire Reserve', 170000, 1, 2021), ('Chase Sapphire Reserve', 175000, 2, 2021), ('Chase Sapphire Reserve', 180000, 3, #sql #dataanalysts #dataengineer #dataanalysis #interviewquestion #sqlinterview #sqlinterviewquestions