Posts

Showing posts from December 9, 2024

SQL Queries Code Interviews QA 50 plus

Image
Here are SQL-focused interview questions with only the relevant SQL code: 1. Find the second highest salary from an Employee table. SELECT MAX(Salary) AS SecondHighestSalary FROM Employees WHERE Salary < (SELECT MAX(Salary) FROM Employees); Using ROW_NUMBER(): WITH RankedSalaries AS (   SELECT Salary, ROW_NUMBER() OVER (ORDER BY Salary DESC) AS Rank   FROM Employees ) SELECT Salary AS SecondHighestSalary FROM RankedSalaries WHERE Rank = 2; --- 2. Write a query to calculate a running total of sales. SELECT   OrderID,   OrderDate,   Amount,   SUM(Amount) OVER (ORDER BY OrderDate) AS RunningTotal FROM Orders; --- 3. Retrieve customers who placed no orders using a LEFT JOIN. SELECT c.CustomerID, c.CustomerName FROM Customers c LEFT JOIN Orders o ON c.CustomerID = o.CustomerID WHERE o.OrderID IS NULL; --- 4. Write a query to find the top 3 highest salaries. SELECT DISTINCT Salary FROM Employees ORDER BY Salary DESC LIMIT 3; Using DENSE_RANK(): WIT...

SpaceTech Insurance Dataset Creation and Agile Workflow Planning

Image
  Source Code here in kaggle:  SpaceTech_Insurance_Agile_Strories_Dataset V1.0   When we have private agile user stories, we can able to refine the COT / TOT framework related prompt responses more and lot refined and easier eye catching solutions. Concept Overview: SpaceTech Insurance Dataset Creation and Agile Workflow Planning Business Context SpaceTech insurance is an emerging field addressing risks associated with space exploration, satellite launches, and orbital operations. Insurance companies require robust datasets and workflows to assess risks, underwrite policies, manage claims, and ensure regulatory compliance. By creating an agile dataset and workflow planning approach, insurers can streamline operations, improve decision-making, and adapt to the dynamic nature of the SpaceTech industry. Business Research Market Demand: Increased reliance on satellites for communication, GPS, and Earth observation. Growing investments in private space exploration companies li...