Amazon Data Analyst interview questions 2025 SQL Questions (1–7) 1. Find customers who purchased more than 3 times in the last month. SELECT customer_id, COUNT(*) AS purchase_count FROM orders WHERE order_date >= DATEADD(month, -1, GETDATE()) GROUP BY customer_id HAVING COUNT(*) > 3; 2. Write a query to find the second highest salary. SELECT MAX(salary) FROM employees WHERE salary < (SELECT […]
The Reserve Bank of India (RBI) has once again issued a notification regarding the ₹2000 note. Even two years after the announcement of its withdrawal, a surprising amount of these notes is still lying with the public. While most of the currency has already returned to the banking system, people are still holding on to a chunk worth several thousand […]
When learning Python, one of the most important concepts to understand is data structures. Python provides several built-in data structures like lists, sets, dictionaries, and tuples. Among these, tuples play a key role in storing and organizing data. In this article, we will explore what a tuple is, why it is used, its advantages, and practical examples that make the […]
Breaking into a career in data analytics requires more than technical skills—it also demands strong problem-solving, business understanding, and communication abilities. Whether you’re preparing for your first data analyst role or aiming for a senior position, interviewers test not only your technical knowledge but also your ability to apply it in real-world scenarios. To help you succeed, we’ve compiled 50 […]