Data Analyst Interview Resources

🪙 +30.560$ with 300$ in a month of trading! We can teach you how to earn! FREE! It was a challenge - a marathon 300$ to 30.000$ on trading, together with Lisa! What is the essence of earning?: "Analyze and open a deal on the exchange, knowing where the currency rate will go. Lisa trades every day and posts signals on her channel for free." 🔹Start: $150 🔹 Goal: $20,000 🔹Period: 1.5 months. Join and get started, there will be no second chance👇 https://t.me/+5-1kxQkkjOczMzIy

🚀 𝐁𝐞𝐜𝐨𝐦𝐞 𝐚 𝐓𝐎𝐏 𝐍𝐎𝐓𝐂𝐇 𝐃𝐀𝐓𝐀 𝐒𝐂𝐈𝐄𝐍𝐓𝐈𝐒𝐓😍 Learn Data Analytics, Data Science, & AI Curriculum designed and taught by Alumni from IITs 10+ Hiring Drives Every Month To Get Placed 𝐏𝐫𝐨𝐠𝐫𝐚𝐦 𝐇𝐢𝐠𝐡𝐥𝐢𝐠𝐡𝐭𝐬:- 🌟 2000+ Students Placed 🤝 500+ Hiring Partners 💼 Avg. Rs. 7.4 LPA 🚀 41 LPA Highest Package Eligibility: BTech / BCA / BSc / MCA / MSc  𝐀𝐩𝐩𝐥𝐲 𝐍𝐨𝐰👇 : https://bit.ly/4g3kyT6 ( Limited Slots💫🏃‍♂️ )

DATA ANALYST Interview Questions (0-3 yr) (SQL, Power BI) 👉 Power BI: Q1: Explain step-by-step how you will create a sales dashboard from scratch. Q2: Explain how you can optimize a slow Power BI report. Q3: Explain Any 5 Chart Types and Their Uses in Representing Different Aspects of Data. 👉SQL: Q1: Explain the difference between RANK(), DENSE_RANK(), and ROW_NUMBER() functions using example. Q2 – Q4 use Table: employee (EmpID, ManagerID, JoinDate, Dept, Salary) Q2: Find the nth highest salary from the Employee table. Q3: You have an employee table with employee ID and manager ID. Find all employees under a specific manager, including their subordinates at any level. Q4: Write a query to find the cumulative salary of employees department-wise, who have joined the company in the last 30 days. Q5: Find the top 2 customers with the highest order amount for each product category, handling ties appropriately. Table: Customer (CustomerID, ProductCategory, OrderAmount) 👉Behavioral: Q1: Why do you want to become a data analyst and why did you apply to this company? Q2: Describe a time when you had to manage a difficult task with tight deadlines. How did you handle it? I have curated best 80+ top-notch Data Analytics Resources 👇👇 https://whatsapp.com/channel/0029VaGgzAk72WTmQFERKh02 Hope this helps you 😊

To Restore the Nord Stream 2. The Trump-like Deal. A close friend of Putin has been engineering a restart of Russia’s Nord Stream 2 gas pipeline to Europe with the backing of US investors, a once unthinkable move that shows the breadth of Trump’s rapprochement with Moscow. The efforts on a deal, according to several people aware of the discussions, were the brainchild of Matthias Warnig, an ex-Stasi officer in East Germany who until 2023 ran Nord Stream 2’s parent company for the Kremlin-controlled gas giant Gazprom. Warnig’s plan involved outreach to the Trump team through US businessmen, the people said, as part of back-channel efforts to broker an end to the war in Ukraine while deepening economic ties between the US and Russia. Some prominent Trump administration figures are aware of the initiative to bring in US investors, according to officials in Washington, and they see it as part of the push to rebuild relations with Moscow. While there have been several expressions of interest, one US-led consortium of investors has drawn up the outlines of a post-sanctions deal with Gazprom, according to one person with direct knowledge of talks who declined to disclose the identity of the prospective investors. Senior EU officials became aware of the Nord Stream 2 discussion in recent weeks. Leaders of several European countries are concerned and have discussed the matter, according to several officials with knowledge of the discussions. One of Nord Stream 2’s two pipelines was blown up in sabotage attacks in September 2022 that destroyed both pipelines of its older sister project Nord Stream 1. The other Nord Stream 2 pipeline, which has an annual capacity of 27.5bn cubic metres of natural gas, is undamaged but has never been used. The latest plan would in theory give the US unparalleled sway over energy supplies to Europe, the people said, after EU countries moved to end their dependence on Russian gas in the aftermath of the invasion. But the obstacles are considerable. It would require the US to lift sanctions against Russia, Russia to agree to resume sales it cut off during the war, and Germany to allow the gas to flow to any potential buyers in Europe.

“The US would say, ‘Well, now Russia will be dependable because trustworthy Americans are in the middle of it,"

said a former senior US official, who was aware of some of the dealmaking efforts. The US investors would collect “money for nothing”, he added. The talks come as the Trump administration races to seal a peace deal through bilateral discussions with Russia that have excluded Europe and Ukraine, spooking European capitals who fear a US détente with Moscow could threaten the continent. Trump has promised deeper economic co-operation with Russia if a peace agreement can be reached. Putin has talked up the economic benefits he says the US could reap with the Kremlin in the event of a settlement in Ukraine, claiming that “several companies” were already in touch over potential deals. Nord Stream 2 AG, the pipeline’s Swiss-based parent company, received an exceptional stay on bankruptcy proceedings in January by at least four months. According to a redacted court document, Nord Stream 2’s shareholder — Gazprom — argued that the new Trump administration, as well as the German election in February 2025, “presumably can have significant consequences on the circumstances of Nord Stream 2” to warrant a delay. #NordStream2 #restore #Deal 📱 American Оbserver - Stay up to date on all important events 🇺🇸

Final Preparation Guide for Data Analytics Interviews: (IMP) ➡Key SQL Concepts: - Master SELECT statements, focusing on WHERE, ORDER BY, GROUP BY, and HAVING clauses. - Understand the basics of JOINS: INNER, LEFT, RIGHT, FULL. - Get comfortable with aggregate functions like COUNT, SUM, AVG, MAX, and MIN. - Study subqueries and Common Table Expressions. - Explore advanced topics like CASE statements, complex JOIN strategies, and Window functions (OVER, PARTITION BY, ROW_NUMBER, RANK). ➡Python for Data Analysis: - Review the basics of Python syntax, control structures, and data structures (lists, dictionaries). - Dive into data manipulation using Pandas and NumPy, covering DataFrames, Series, and group by operations. - Learn basic plotting techniques with Matplotlib and Seaborn for data visualization. ➡ Excel Skills: - Practice cell operations and essential formulas like SUMIFS, COUNTIFS, and AVERAGEIFS. - Familiarize yourself with PivotTables, PivotCharts, data validation, and What-if analysis. - Explore advanced formulas and work with the Data Model & Power Pivot. ➡ Power BI Proficiency: - Focus on data modeling, including importing data and managing relationships. - Learn data transformation techniques with Power Query and use DAX for calculated columns and measures. - Create interactive reports and dashboards, and work on visualizations. ➡ Basic Statistics: - Understand fundamental concepts like Mean, Median, Mode, Standard Deviation, and Variance. - Study probability distributions, Hypothesis Testing, and P-values. - Learn about Confidence Intervals, Correlation, and Simple Linear Regression. I have curated best 80+ top-notch Data Analytics Resources 👇👇 https://whatsapp.com/channel/0029VaGgzAk72WTmQFERKh02 Hope this helps you 😊

𝗙𝗥𝗘𝗘 𝗖𝗼𝘂𝗿𝘀𝗲𝘀 𝘁𝗼 𝗠𝗮𝘀𝘁𝗲𝗿 𝗗𝗮𝘁𝗮 𝗦𝗰𝗶𝗲𝗻𝗰𝗲 & 𝗔𝗜!😍 Want to boost your career with in-demand skills like 𝗗𝗮𝘁𝗮 𝗦𝗰𝗶𝗲𝗻𝗰𝗲, 𝗔𝗜, 𝗠𝗮𝗰𝗵𝗶𝗻𝗲 𝗟𝗲𝗮𝗿𝗻𝗶𝗻𝗴, 𝗣𝘆𝘁𝗵𝗼𝗻, 𝗮𝗻𝗱 𝗦𝗤𝗟?📊 These 𝗙𝗥𝗘𝗘 𝗖𝗼𝘂𝗿𝘀𝗲𝘀 provide hands-on learning with interactive labs and certifications 𝗖𝗲𝗿𝘁𝗶𝗳𝗶𝗰𝗮𝘁𝗶𝗼𝗻𝘀 to enhance your 𝗥𝗲𝘀𝘂𝗺𝗲📍 𝐋𝐢𝐧𝐤👇:- https://pdlink.in/3Xrrouh Perfect for beginners & professionals looking to upgrade their expertise—taught by industry experts!✅️

Must Study: Key Questions for Data Analysts 4.0 Advanced SQL 1. How do you handle hierarchical data and perform recursive queries in SQL? 2. What are common techniques for SQL performance tuning beyond indexing? 3. How do you implement SQL transactions and ensure atomicity in complex queries? Excel Advanced 1. How do you use Power Pivot to manage and analyze large datasets in Excel? 2. What are the best practices for creating and using Excel macros for automation? 3. How do you leverage Excel’s advanced charting tools for dynamic data visualization? Power BI 1. How do you use Power Query to merge and transform data from multiple sources? 2. What are the key differences between calculated columns and measures in Power BI? 3. How do you design effective Power BI dashboards for executive reporting? Python 1. How do you use Python’s pandas library for advanced data manipulation and analysis? 2. What are the best practices for deploying machine learning models using Python? 3. How do you perform time series analysis and forecasting with Python? Data Visualization 1. How do you ensure your visualizations are accessible to people with visual impairments? 2. What are effective methods for visualizing multivariate data? 3. How do you use storytelling techniques to make your data visualizations more engaging? Soft Skills 1. How do you handle conflicts and disagreements within a data team or with stakeholders? 2. What strategies do you use to effectively present complex data insights to a broad audience? 3. How do you stay updated with the latest trends and tools in data analytics? I have curated Data Analytics Resources 👇👇 https://whatsapp.com/channel/0029VaGgzAk72WTmQFERKh02 Hope this helps you 😊

𝗕𝗼𝗼𝘀𝘁 𝗬𝗼𝘂𝗿 𝗖𝗮𝗿𝗲𝗲𝗿 𝘄𝗶𝘁𝗵 𝗙𝗥𝗘𝗘 𝗖𝗶𝘀𝗰𝗼 𝗣𝗿𝗼𝗳𝗲𝘀𝘀𝗶𝗼𝗻𝗮𝗹 𝗦𝗸𝗶𝗹𝗹𝘀 𝗖𝗼𝘂𝗿𝘀𝗲𝘀!😍 Want to stand out in the tech industry? 🌟 🔥Cisco offers FREE courses to help you develop career-ready skills like: 𝐋𝐢𝐧𝐤👇:- https://pdlink.in/3DbhE0s Don’t miss this opportunity! Start learning now✅

Most Asked SQL Interview Questions at MAANG Companies🔥🔥 Preparing for an SQL Interview at MAANG Companies? Here are some crucial SQL Questions you should be ready to tackle: 1. How do you retrieve all columns from a table? SELECT * FROM table_name; 2. What SQL statement is used to filter records? SELECT * FROM table_name WHERE condition; The WHERE clause is used to filter records based on a specified condition. 3. How can you join multiple tables? Describe different types of JOINs. SELECT columns FROM table1 JOIN table2 ON table1.column = table2.column JOIN table3 ON table2.column = table3.column; Types of JOINs: 1. INNER JOIN: Returns records with matching values in both tables SELECT * FROM table1 INNER JOIN table2 ON table1.column = table2.column; 2. LEFT JOIN: Returns all records from the left table & matched records from the right table. Unmatched records will have NULL values. SELECT * FROM table1 LEFT JOIN table2 ON table1.column = table2.column; 3. RIGHT JOIN: Returns all records from the right table & matched records from the left table. Unmatched records will have NULL values. SELECT * FROM table1 RIGHT JOIN table2 ON table1.column = table2.column; 4. FULL JOIN: Returns records when there is a match in either left or right table. Unmatched records will have NULL values. SELECT * FROM table1 FULL JOIN table2 ON table1.column = table2.column; 4. What is the difference between WHERE & HAVING clauses? WHERE: Filters records before any groupings are made. SELECT * FROM table_name WHERE condition; HAVING: Filters records after groupings are made. SELECT column, COUNT(*) FROM table_name GROUP BY column HAVING COUNT(*) > value; 5. How do you calculate average, sum, minimum & maximum values in a column? Average: SELECT AVG(column_name) FROM table_name; Sum: SELECT SUM(column_name) FROM table_name; Minimum: SELECT MIN(column_name) FROM table_name; Maximum: SELECT MAX(column_name) FROM table_name; Here you can find essential SQL Interview Resources👇 https://whatsapp.com/channel/0029VanC5rODzgT6TiTGoa1v Like this post if you need more 👍❤️ Hope it helps :)

𝟰 𝗔𝗜 𝗖𝗲𝗿𝘁𝗶𝗳𝗶𝗰𝗮𝘁𝗶𝗼𝗻𝘀 𝘁𝗼 𝗕𝗼𝗼𝘀𝘁 𝗬𝗼𝘂𝗿 𝗖𝗮𝗿𝗲𝗲𝗿 𝗶𝗻 𝗔𝗜 𝗗𝗲𝘃𝗲𝗹𝗼𝗽𝗺𝗲𝗻𝘁!😍 Want to stand out as an AI developer?✨️ These 4 AI certifications will help you build expertise, understand AI ethics, and develop impactful solutions! 💡🤖 𝐋𝐢𝐧𝐤👇:- https://pdlink.in/41hvSoy Perfect for Beginners & Developers Looking to Upskill!✅️

Almost everyone knows that these are the tools a Data Analyst works with: ➡️ SQL ➡️ Excel ➡️ Power BI/Tableau ➡️ Python But people getting started with analytics are confused about the preferences of picking these tools. There are various kinds of data analytics roles available in the market : ➡️ BI + SQL: Will primarily be involved in BI development. ➡️ SQL + Excel: Will primarily work on Excel reporting. ➡️ SQL + Python: Will primarily do data analysis using python. Now, If you are getting started with learning analytics, choose any one role that interests you the most and focus on completing the primary tools that the role requires. Learn them VERY WELL. Learn any of the above combinations that interests you first and then start looking out for opportunities which ask for these primary tools and simultaneously start learning the basics of the 3rd tool. You don't have to focus on being good with each and every tool but being good with any of the above combinations always works. Hope this helps you 😊

𝗔𝗜/𝗠𝗟 𝗙𝗥𝗘𝗘 𝗢𝗻𝗹𝗶𝗻𝗲 𝗠𝗮𝘀𝘁𝗲𝗿𝗰𝗹𝗮𝘀𝘀😍 Master AI & ML and Kickstart Your Career – In Just 5 Steps! - Build a strong foundation in machine learning and artificial intelligence. - Discover the best online resources, courses, and communities to keep learning. 𝗘𝗹𝗶𝗴𝗶𝗯𝗶𝗹𝗶𝘁𝘆 :- Students, Freshers & Working Professionals  𝐑𝐞𝐠𝐢𝐬𝐭𝐞𝐫 𝐅𝐨𝐫 𝐅𝐑𝐄𝐄 👇:-  https://pdlink.in/4knLiAc  (Limited Slots Available – Hurry Up!🏃‍♂️) 𝗗𝗮𝘁𝗲 & 𝗧𝗶𝗺𝗲:- March 02, 2025, 2025, at 5 PM

5 frequently Asked SQL Interview Questions with Answers in Data Engineering interviews: 𝐃𝐢𝐟𝐟𝐢𝐜𝐮𝐥𝐭𝐲 - 𝐌𝐞𝐝𝐢𝐮𝐦 ⚫️Determine the Top 5 Products with the Highest Revenue in Each Category. Schema: Products (ProductID, Name, CategoryID), Sales (SaleID, ProductID, Amount) WITH ProductRevenue AS ( SELECT p.ProductID, p.Name, p.CategoryID, SUM(s.Amount) AS TotalRevenue, RANK() OVER (PARTITION BY p.CategoryID ORDER BY SUM(s.Amount) DESC) AS RevenueRank FROM Products p JOIN Sales s ON p.ProductID = s.ProductID GROUP BY p.ProductID, p.Name, p.CategoryID ) SELECT ProductID, Name, CategoryID, TotalRevenue FROM ProductRevenue WHERE RevenueRank <= 5; ⚫️ Identify Employees with Increasing Sales for Four Consecutive Quarters. Schema: Sales (EmployeeID, SaleDate, Amount) WITH QuarterlySales AS ( SELECT EmployeeID, DATE_TRUNC('quarter', SaleDate) AS Quarter, SUM(Amount) AS QuarterlyAmount FROM Sales GROUP BY EmployeeID, DATE_TRUNC('quarter', SaleDate) ), SalesTrend AS ( SELECT EmployeeID, Quarter, QuarterlyAmount, LAG(QuarterlyAmount, 1) OVER (PARTITION BY EmployeeID ORDER BY Quarter) AS PrevQuarter1, LAG(QuarterlyAmount, 2) OVER (PARTITION BY EmployeeID ORDER BY Quarter) AS PrevQuarter2, LAG(QuarterlyAmount, 3) OVER (PARTITION BY EmployeeID ORDER BY Quarter) AS PrevQuarter3 FROM QuarterlySales ) SELECT EmployeeID, Quarter, QuarterlyAmount FROM SalesTrend WHERE QuarterlyAmount > PrevQuarter1 AND PrevQuarter1 > PrevQuarter2 AND PrevQuarter2 > PrevQuarter3; ⚫️ List Customers Who Made Purchases in Each of the Last Three Years. Schema: Orders (OrderID, CustomerID, OrderDate) WITH YearlyOrders AS ( SELECT CustomerID, EXTRACT(YEAR FROM OrderDate) AS OrderYear FROM Orders GROUP BY CustomerID, EXTRACT(YEAR FROM OrderDate) ), RecentYears AS ( SELECT DISTINCT OrderYear FROM Orders WHERE OrderDate >= CURRENT_DATE - INTERVAL '3 years' ), CustomerYearlyOrders AS ( SELECT CustomerID, COUNT(DISTINCT OrderYear) AS YearCount FROM YearlyOrders WHERE OrderYear IN (SELECT OrderYear FROM RecentYears) GROUP BY CustomerID ) SELECT CustomerID FROM CustomerYearlyOrders WHERE YearCount = 3; ⚫️ Find the Third Lowest Price for Each Product Category. Schema: Products (ProductID, Name, CategoryID, Price) WITH RankedPrices AS ( SELECT CategoryID, Price, DENSE_RANK() OVER (PARTITION BY CategoryID ORDER BY Price ASC) AS PriceRank FROM Products ) SELECT CategoryID, Price FROM RankedPrices WHERE PriceRank = 3; ⚫️ Identify Products with Total Sales Exceeding a Specified Threshold Over the Last 30 Days. Schema: Sales (SaleID, ProductID, SaleDate, Amount) WITH RecentSales AS ( SELECT ProductID, SUM(Amount) AS TotalSales FROM Sales WHERE SaleDate >= CURRENT_DATE - INTERVAL '30 days' GROUP BY ProductID ) SELECT ProductID, TotalSales FROM RecentSales WHERE TotalSales > 200; Here you can find essential SQL Interview Resources👇 https://topmate.io/analyst/864764 Like this post if you need more 👍❤️ Hope it helps :)

𝟯 𝗕𝗲𝘀𝘁 𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘁𝗶𝗰𝘀 𝗙𝗥𝗘𝗘 𝗖𝗲𝗿𝘁𝗶𝗳𝗶𝗰𝗮𝘁𝗶𝗼𝗻 𝗖𝗼𝘂𝗿𝘀𝗲𝘀 😍 ✅ Data Analytics Essentials(Cisco) ✅ Google Data Analytics ✅ Microsoft Power BI 𝐋𝐢𝐧𝐤 👇:-  https://pdlink.in/3QXCl3n Enroll For FREE & Get Certified🎓

Preparing for an online data analyst interview? Here’s a complete guide to ensure you’re ready to impress: 1. Mental Preparation Visualize Success: Imagine yourself confidently answering questions and solving problems. Stay Calm: Practice relaxation techniques like deep breathing or meditation to manage interview stress. Set Clear Goals: Define what you aim to achieve and focus on showcasing your strengths. 2. Technical Setup Check Your Equipment: Test your computer, camera, microphone, and internet connection to avoid technical glitches. Platform Familiarity: Familiarize yourself with the video conferencing tool (Zoom, Teams, etc.) and ensure it’s updated. Professional Background: Choose a clean, well-lit space or use a virtual background if necessary. 3. Environment Quiet Space: Select a quiet room free from interruptions and let others know about your interview schedule. Lighting and Camera: Position your camera at eye level and ensure you’re well-lit from the front to avoid shadows. 4. Interview Preparation Review Key Concepts: Brush up on SQL, data manipulation, and visualization tools relevant to the role. Practice with Online Tools: Get comfortable with online whiteboards or screen-sharing features if they’ll be used. Prepare Your Questions: Develop insightful questions about the role, team, and company. 5. Day Before the Interview Test Your Setup: Conduct a trial run with a friend or family member to ensure everything works smoothly. Organize Documents: Have your resume, cover letter, and any required documents easily accessible on your computer. Dress Professionally: Choose professional attire to set the right tone and boost your confidence. 6. Interview Day Log in Early: Join the meeting a few minutes early to resolve any last-minute issues and show punctuality. Engage Actively: Maintain eye contact by looking at the camera, and engage thoughtfully with the interviewer. Data Analytics Resources 👇👇 https://whatsapp.com/channel/0029VaGgzAk72WTmQFERKh02 Hope this helps you 😊

𝗧𝗼𝗽 𝗠𝗡𝗖𝘀 𝗛𝗶𝗿𝗶𝗻𝗴 𝗗𝗮𝘁𝗮 𝗦𝗰𝗶𝗲𝗻𝘁𝗶𝘀𝘁𝘀 & 𝗗𝗮𝘁𝗮 𝗘𝗻𝗴𝗶𝗻𝗲𝗲𝗿𝘀 😍 GE:- https://pdlink.in/3DmQsf4 United:- https://pdlink.in/3F6ZwVW Birlasoft :- https://pdlink.in/41B0umg KPMG:- https://pdlink.in/4ifHDCB Lightcast:- https://pdlink.in/4gXt3im Barlcays :- https://pdlink.in/4bpnvfm Apply before the link expires 💫

Most Important Python Topics for Data Analyst Interview: #Basics of Python: 1. Data Types 2. Lists 3. Dictionaries 4. Control Structures: - if-elif-else - Loops 5. Functions 6. Practice basic FAQs questions, below mentioned are few examples: - How to reverse a string in Python? - How to find the largest/smallest number in a list? - How to remove duplicates from a list? - How to count the occurrences of each element in a list? - How to check if a string is a palindrome? #Pandas: 1. Pandas Data Structures (Series, DataFrame) 2. Creating and Manipulating DataFrames 3. Filtering and Selecting Data 4. Grouping and Aggregating Data 5. Handling Missing Values 6. Merging and Joining DataFrames 7. Adding and Removing Columns 8. Exploratory Data Analysis (EDA): - Descriptive Statistics - Data Visualization with Pandas (Line Plots, Bar Plots, Histograms) - Correlation and Covariance - Handling Duplicates - Data Transformation #Numpy: 1. NumPy Arrays 2. Array Operations: - Creating Arrays - Slicing and Indexing - Arithmetic Operations #Integration with Other Libraries: 1. Basic Data Visualization with Pandas (Line Plots, Bar Plots) #Key Concepts to Revise: 1. Data Manipulation with Pandas and NumPy 2. Data Cleaning Techniques 3. File Handling (reading and writing CSV files, JSON files) 4. Handling Missing and Duplicate Values 5. Data Transformation (scaling, normalization) 6. Data Aggregation and Group Operations 7. Combining and Merging Datasets Hope this helps you 😊

𝗢𝗿𝗮𝗰𝗹𝗲 𝗙𝗥𝗘𝗘 𝗖𝗲𝗿𝘁𝗶𝗳𝗶𝗰𝗮𝘁𝗶𝗼𝗻 𝗖𝗼𝘂𝗿𝘀𝗲𝘀 | 𝗦𝗤𝗟 😍 SQL is a must-have skill for Data Science, Analytics, and Data Engineering roles! Mastering SQL can boost your resume, help you land high-paying roles, and make you stand out in Data Science & Analytics! 𝐋𝐢𝐧𝐤👇:- https://pdlink.in/4bjJaFv Enroll Now & Get Certfied 🎓

SQL table interview questions: 1. What is a DUAL table and why do we need it? - it is a special table which gets created automatically when we install Oracle database. It can be used to select pseudo columns, perform calculations and also as sequence generator etc. 2. How many columns and rows are present in DUAL table? - one column & one row by default. 3. Can we insert more rows in to DUAL table? - Yes. 4. What's the easiest wah to backup a table / how can we create a table based on existing table? - CREATE TABLE SALES_COPY AS SELECT * FROM SALES. 5. Can we drop all the columns from a table? - No. 6. What is the difference between count(1) and count(*)? - Both are same. Both consume same amount of resources, Both perform same operation

5⃣ frequently Asked SQL Interview Questions with Answers in data analyst interviews 📍1. Write a SQL query to find the average purchase amount for each customer. Assume you have two tables: Customers (CustomerID, Name) and Orders (OrderID, CustomerID, Amount).

SELECT c.CustomerID, c. Name, AVG(o.Amount) AS AveragePurchase FROM Customers c JOIN Orders o ON c.CustomerID = o.CustomerID GROUP BY c.CustomerID, c. Name;

📍2. Write a query to find the employee with the minimum salary in each department from a table Employees with columns EmployeeID, Name, DepartmentID, and Salary.

SELECT e1.DepartmentID, e1.EmployeeID, e1 .Name, e1.Salary FROM Employees e1 WHERE Salary = (SELECT MIN(Salary) FROM Employees e2 WHERE e2.DepartmentID = e1.DepartmentID);

📍3. Write a SQL query to find all products that have never been sold. Assume you have a table Products (ProductID, ProductName) and a table Sales (SaleID, ProductID, Quantity).

SELECT p.ProductID, p.ProductName FROM Products p LEFT JOIN Sales s ON p.ProductID = s.ProductID WHERE s.ProductID IS NULL;

📍4. Given a table Orders with columns OrderID, CustomerID, OrderDate, and a table OrderItems with columns OrderID, ItemID, Quantity, write a query to find the customer with the highest total order quantity.

SELECT o.CustomerID, SUM(oi.Quantity) AS TotalQuantity FROM Orders o JOIN OrderItems oi ON o.OrderID = oi.OrderID GROUP BY o.CustomerID ORDER BY TotalQuantity DESC LIMIT 1

; 📍5. Write a SQL query to find the earliest order date for each customer from a table Orders (OrderID, CustomerID, OrderDate).

SELECT CustomerID, MIN(OrderDate) AS EarliestOrderDate FROM Orders GROUP BY CustomerID

Hope it helps :)