The challenge is to compare the data of the rows and group the input data. The data needs to be grouped based on the Product ID, Date, TotalLines, LinesOutOfService.   Read more...

The challenge is to find the Tax Code based on Price. Each sales amount is uniquely made up by the sum of one or more prices. Based on this you should assign the tax code to each price.   Read more...

This challenge is to generate a game scheduler based on the Teams given in a table.   Read more...

The challenge is to find the minimal set of intervals without creating gaps.  Read more...

The challenge is to find the Islands(gaps) in sequential dates. You need to write a query to identify continuous intervals from the start date and end date.   Read more...

The database field contains long string with data for Quantity and Parts. The challenge is to parse the data into separate (Quantity and Parts) fields for displaying in a report.   Read more...

The challenge is to transform monthly resource efforts into weekly actuals.  Read more...

The challenge is to identify the sequence of accounting transactions.   Read more...

The challenge is to find the Episode and Sequence based on interval.   Read more...

The challenge is to create a query for a report that show expiring material  Read more...

The challenge is to wrap the text by specified position.   Read more...

This challenge invites you to solve a payroll challenge which requires to calculate the number of hours employee worked in a week.  Read more...

Your task is to process the input table that contains several mangled words and try to 'un-mangle' them and validate them against a 'dictionary' table.  Read more...

This challenge invites you to identify the longest sequence of alphabets from a string.  Read more...

Your job is to write a TSQL query that returns the advertisements most relevant to each web page given in the source table.  Read more...

This challenge invites you to Generate kaprekar kernel or series from numbers.  Read more...

This challenge invites you to identify the largest sequence of alphabets from a string.  Read more...

A website wants to display most relevant ads on each of its web pages based on the keywords associated with each page.   Read more...

This challenge invites you to solve one of the most common calculation challenges seen in applications that deal with financial -transactions.  Read more...

This challenge invites you to solve a payroll challenge which requires special calculation of holidays and absences that are adjacent to holidays  Read more...