Asked in JP Morgan SQL | Card Launch Success | SQL Interview | Data Analyst | SQL Developer #sql

Problem : https://datalemur.com/questions/card-launch-success

CREATE TABLE "SYS"."MONTHLY_CARDS_ISSUED"
( "CARD_NAME" VARCHAR2(50 BYTE),
"ISSUED_AMOUNT" NUMBER,
"ISSUE_MONTH" NUMBER(2,0),
"ISSUE_YEAR" NUMBER(4,0)
);

REM INSERTING into MONTHLY_CARDS_ISSUED
SET DEFINE OFF;
Insert into MONTHLY_CARDS_ISSUED (CARD_NAME,ISSUED_AMOUNT,ISSUE_MONTH,ISSUE_YEAR) values ('Chase Sapphire Reserve',160000,12,2020);
Insert into MONTHLY_CARDS_ISSUED (CARD_NAME,ISSUED_AMOUNT,ISSUE_MONTH,ISSUE_YEAR) values ('Chase Sapphire Reserve',170000,1,2021);
Insert into MONTHLY_CARDS_ISSUED (CARD_NAME,ISSUED_AMOUNT,ISSUE_MONTH,ISSUE_YEAR) values ('Chase Sapphire Reserve',175000,2,2021);
Insert into MONTHLY_CARDS_ISSUED (CARD_NAME,ISSUED_AMOUNT,ISSUE_MONTH,ISSUE_YEAR) values ('Chase Sapphire Reserve',180000,3,2021);
Insert into MONTHLY_CARDS_ISSUED (CARD_NAME,ISSUED_AMOUNT,ISSUE_MONTH,ISSUE_YEAR) values ('Chase Freedom Flex',55000,1,2021);
Insert into MONTHLY_CARDS_ISSUED (CARD_NAME,ISSUED_AMOUNT,ISSUE_MONTH,ISSUE_YEAR) values ('Chase Freedom Flex',60000,2,2021);
Insert into MONTHLY_CARDS_ISSUED (CARD_NAME,ISSUED_AMOUNT,ISSUE_MONTH,ISSUE_YEAR) values ('Chase Freedom Flex',65000,3,2021);
Insert into MONTHLY_CARDS_ISSUED (CARD_NAME,ISSUED_AMOUNT,ISSUE_MONTH,ISSUE_YEAR) values ('Chase Freedom Flex',70000,4,2021);
Insert into MONTHLY_CARDS_ISSUED (CARD_NAME,ISSUED_AMOUNT,ISSUE_MONTH,ISSUE_YEAR) values ('Chase Sapphire Reserve',150000,11,2020);
Oracle :

SELECT
card_name,
issued_amount
FROM
(
SELECT
card_name,
issued_amount,
issue_month,
issue_year,
RANK()
OVER(PARTITION BY issue_year
ORDER BY
issue_month, card_name
) AS rnk
FROM
monthly_cards_issued
)
WHERE
rnk = 1;

faang interview, sql questions asked in interview, everyday data science, data science interview questions, day in life of data analyst, data science, datalemur, linkedin data analyst, linkedin data science interview, linkedin data science profile, how to solve data science problems, how to solve data science case study, sql interview questions, sql solutions, learn sql in 1 hour, eds, data, personal finance, stocks to buy now, tiktok viral, failing bank, faang pay, stripe

#SQL #DataLemur #SQLInterviewQuestions #DataAnalytics #PizzaProblem #SQLJoins #LearnSQL #TechInterviewPrep
faang interview,sql questions asked in interview,everyday data science,data science interview questions,day in life of data analyst,data science,datalemur,linkedin data analyst,linkedin data science interview,linkedin data science profile,how to solve data science problems,how to solve data science case study,sql interview questions,sql solutions,learn sql in 1 hour,eds,data,personal finance,stocks to buy now,tiktok viral,failing bank,faang pay,stripe

Видео Asked in JP Morgan SQL | Card Launch Success | SQL Interview | Data Analyst | SQL Developer #sql канала vikas_vooradi