Feb. 12, 2024, 1:50 p.m. | Kamireddy Mahendra

Towards AI - Medium pub.towardsai.net

“Consistent practice is the key to unlocking success in clearing any coding interview.”

Concepts used: Window functions, CTE, Joins, Subqueries, and GROUP BY

Photo by Christian Wiediger on Unsplash

Q1. Assume you’re given a table containing data on Amazon customers and their spending on products in different categories, and write a query to identify the top two highest-grossing products within each category in the year 2022. The output should include the category, product, and total spend.

Image designed by author …

amazon coding companies concepts consistent customers data data analyst data engineering functions gates interview interview questions joins key practice products questions spending sql success table the key

Research Scholar (Technical Research)

@ Centre for the Governance of AI | Hybrid; Oxford, UK

HPC Engineer (x/f/m) - DACH

@ Meshcapade GmbH | Remote, Germany

Senior Analytics Engineer (Retail)

@ Lightspeed Commerce | Toronto, Ontario, Canada

Data Scientist II, BIA GPS India Operations

@ Bristol Myers Squibb | Hyderabad

Analytics Engineer

@ Bestpass | Remote

Senior Analyst - Data Management

@ Marsh McLennan | Mumbai - Hiranandani