|
|
-
This challenge aims to test your string parsing and summarizing skills using TSQL. The challenge is to count the number of mobile phones each person has and generate a summary row....
|
-
This challenge is to test the logical ability and does not have any resemblance with real time problem. The task is to generate the palindrome primes from 10 to 1000 and count the number of occurrences of each digit in them...
|
-
There are two tables involved in this challenge. The first table is MovieReleaseDates which will contain the names of movies along with their release dates....
|
-
This challenge refers to a real-world problem I came across recently. The requirement was to identify all 'direct' or 'indirect' parents of a given child node and all its siblings....
|
-
This challenge refers to sanitizing text data. Your task is to read an alphanumeric string and create two output columns one containing all the digits found in the input string and the other with all the letters of the English Alphabet. ...
|
-
This challenge involves reading information from XML columns. The table keeps track of the progressive builds of an application in a development environment and your task is to identify the most recent 3 builds of each application....
|
-
This challenge involves finding available registration dates based on event schedules and registration data....
|
-
The challenge involves validating the GUID values and perform horizontal and vertical count of the characters "1, 2, 3, 4, 5, A, B, C, D, E"....
|
-
This challenge is to find the palindromic words from sentence(s). While finding the palindromic words from the sentence(s), the noise words should be removed if any is present in the sentence.
...
|
-
This challenge is all about counting the number of occurrence of characters in a string using a SET based query. The task is to list all the characters and count of that character within the given string....
|