SQL Exercise – 9
SQL Exercise: You are given a table containing a list of departments and employees. Write a query to concatenate all employee names for each department… Read More »SQL Exercise – 9
Home » Archives for Pradeep Raturi »
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.
SQL Exercise – 8
SQL Exercise: Create a SQL function that takes a string as input and removes all special characters (keeping only alphanumeric characters and spaces). The following… Read More »SQL Exercise – 8
SQL Exercise – 11
SQL Exercise: Given a table Sales that records sales data for various products across multiple months, write a query to dynamically pivot the data such… Read More »SQL Exercise – 11
SQL Exercise -10
SQL Exercise: You are provided with a table Sales that records monthly sales data for various products. Write a query to transform the data such… Read More »SQL Exercise -10
SQL Exercise – 7
SQL Exercise: You are given two tables: Employees and Departments. Write a query to find the highest-paid employee in each department. If a department does… Read More »SQL Exercise – 7
SQL Exercise – 6
SQL Exercise: Suppose you have a Sales table that tracks product sales data, including the sale amount, product category, and sale date. You want to… Read More »SQL Exercise – 6
SQL Exercise – 5
SQL Exercise: You have a Sales table that tracks product sales in different cities for various dates. Now, you have to get the following information.… Read More »SQL Exercise – 5
SQL Exercise – 4
SQL Exercise: Write Query to: Find all customers with the last name “Singh”. Retrieve customers whose email address contains the word “kumar”. Retrieve customers living… Read More »SQL Exercise – 4
SQL Exercise – 3
SQL Exercise: Write a query to find the top 3 cities by total sales revenue, including: The total revenue for each city. The number of… Read More »SQL Exercise – 3
SQL Exercise – 2
SQL Exercise: Write a query to find the following details for each department: The total hours worked by employees on all projects. The number of… Read More »SQL Exercise – 2
SQL Exercise – 1
Query: Write a query to find the name of each employee, their department name, their manager’s name, and the total budget of the projects their… Read More »SQL Exercise – 1
EOMonth function in Power Apps
The EOMonth function in Power Apps returns the last day of the month for a given date, with an option to shift the result by… Read More »EOMonth function in Power Apps
EDate function in Power Apps
The EDate function in Power Apps is used to calculate a date that is a specific number of months before or after a given date.… Read More »EDate function in Power Apps
GroupBy function in Power Apps
The GroupBy function in Power Apps is used to group records from a table based on one or more columns. It returns a table where… Read More »GroupBy function in Power Apps
Index function in Power Apps
The Index function in Power Apps returns a record of a table based on its ordered position in the table. Index returns an error if the requested… Read More »Index function in Power Apps
FirstN function in Power Apps
The FirstN function in Power Apps is used to retrieve the first n records from a table or collection. This function is useful when you… Read More »FirstN function in Power Apps
LastN function in Power Apps
The LastN function in Power Apps is used to return the last n records from a table or collection. It helps you retrieve a specific… Read More »LastN function in Power Apps
IfError function in Power Apps
The IfError function in Power Apps is used to handle errors in expressions and return a specified result if an error occurs. If the function… Read More »IfError function in Power Apps
Make a round shape profile image in Power Apps
To make a round-shaped profile image in Power Apps, you can follow these steps by adjusting the Height, Width, and BorderRadius properties of the image… Read More »Make a round shape profile image in Power Apps
Substitute function in Power Apps
The Substitute function in Power Apps is used to replace occurrences of specific text within a string with provided value. It’s useful when you want… Read More »Substitute function in Power Apps