Hacker Rank Coding Challenge: SQL: Online Shopping Report https://youtu.be/gNQA3_0zfeM
An auditing firm needs a report of transaction counts for shoppers on 5 platforms. Write an SQL query to generate a report that shows how many transactions each customer had on each of the platforms. The report should have the following columns: CUSTOMER NAME, Amazon, Flipkart, Myntra, Zara, Snapdeal.