My issue
but is showing wrong
My code
WITH top_purchase AS (
SELECT Purchase_id, Customer_id, Purchase_Amt
FROM Purchase
ORDER BY Purchase_Amt DESC
LIMIT 3
)
SELECT
Customer.Customer_id,
Customer.Customer_Name,
top_purchase.Purchase_id,
top_purchase.Customer_id AS Purchase_Customer_id,
top_purchase.Purchase_Amt
FROM
Customer
JOIN
top_purchase
ON
Customer.Customer_id = top_purchase.Customer_id;
Learning course: 212CSE2305: Database Management Systems
Problem Link: https://www.codechef.com/learn/course/kl-dbms-cs-2024/KLDBMS2420/problems/GSQ68E