SQL Cricket Team Ranking Based on Points
Problem Statement A cricket tournament is played between multiple teams. Winning team gets +1 point Losing team gets –1 point We need to calculate total… Read More »SQL Cricket Team Ranking Based on Points
Home »
Pradeep Raturi
I have 11+ years of working experience in Business Intelligence Data Modelling, Power BI, SQL Server, SSRS, SSIS, Azure Data Factory, Power Apps.
LeetCode – Consecutive Numbers
Question Write a SQL query to find all numbers that appear at least three times consecutively in the Logs table.Return the result in any order.… Read More »LeetCode – Consecutive Numbers
LeetCode – Combine two tables
Question Write a SQL query to report the first name, last name, city, and state of each person in the Person table. If a person’s… Read More »LeetCode – Combine two tables
Power Query Remove Duplicates but Keep Latest Record
Scenario: In the OrdersData table, some OrderIDs appear multiple times with different dates. We need to create a new table that keeps only the most… Read More »Power Query Remove Duplicates but Keep Latest Record
Power Apps Functions Cheat Sheet
1. Text Functions Function Description Syntax Len() Returns the number of characters in a string. Len(“Power Apps”) → 10 Left() Extracts characters from the start… Read More »Power Apps Functions Cheat Sheet
Power Apps Interview Questions Answer with examples
1. What is Power Apps? Answer:Power Apps is Microsoft’s low-code/no-code platform that allows users to quickly build custom business applications, connect to multiple data sources… Read More »Power Apps Interview Questions Answer with examples
Finds the top two highest-paid employees in each department
Write a SQL query to: Find the top 2 highest-paid employees in each department. Show their ranking based on salary within the department. Also calculate… Read More »Finds the top two highest-paid employees in each department
Copy function in Power Apps
The Copy() function in Power Apps is used to copy text values to the clipboard, allowing users to easily paste them elsewhere. Regardless of the… Read More »Copy function in Power Apps
Value function in Power Apps
TheValue() function in Power Apps is used to convert text strings into numeric values. This is particularly useful when dealing with inputs from text controls,… Read More »Value function in Power Apps
SQL Exercise – 22
SQL Exercise – Create a function that accepts a start date, an end date, and a day of the week (e.g., “Monday”). The function should return a table listing all dates within the specified range that match the given day of the week.
SQL Exercise – 20
SQL Exercise: Retrieve a list of all tables along with the number of rows in each table in SQL Server. Soluton: To retrieve a list… Read More »SQL Exercise – 20
SQL Exercise – 19
SQL Exercise: Retrieve the Top and Bottom 2 Sales Scenario: You have a SalesData table with the following columns: SalesID (unique identifier for sales records)… Read More »SQL Exercise – 19
SQL Exercise -18
SQL Exercise: You are given a table Numbers that contains a sequence of numbers starting from 1 to 10. But some numbers are missing. Your… Read More »SQL Exercise -18
SQL Exercise – 17
SQL Exercise: You are given an Employee table containing details about employees, their departments, and their salaries. Your task is to write an SQL query… Read More »SQL Exercise – 17
SQL Exercise -16
SQL Exercise: Write an SQL query to calculate the percentage contribution to sales by each manager for a company. The data is stored in a… Read More »SQL Exercise -16
SQL Exercise – 15
SQL Exercise: A company tracks sales data on a monthly basis and wants to calculate the percentage growth or decline in sales for each product… Read More »SQL Exercise – 15
SQL Exercise -14
SQL Exercise: Write a SQL query to classify invoices based on aging buckets: Due within the last 30 days: Due date is within the last… Read More »SQL Exercise -14
SQL Exercise – 13
SQL Exercise: You are given a table of ticket data that includes the TicketID, OpenDate, and CloseDate. The task is to generate a new row… Read More »SQL Exercise – 13
SQL Exercise – 12
SQL Exercise: You are provided with a table of employees containing their names, departments, and salaries. Write a query to determine the applicable tax rate… Read More »SQL Exercise – 12