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 »
SQL challenge
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 – 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
Extract URL and display name from string
How would you extract the display name and URL from a string in the format [display_name](url)? For example: Let’s say for string [abc](https://www.sqlskull.com), how would… Read More »Extract URL and display name from string