SQL Puzzle: SQL Advance Query – Find the distinct combination from cross Columns

Check the below input data and require output data to find a distinct combination of the cross columns. Create a table with sample data:

Input data:

Expected Output:

Solution 1:

Solution […]

SQL Puzzle: Advance SQL Query – Convert single cell of table into multiple Rows

Check the below input and require output, and convert single cell of a table into multiple Rows. Input:

Output:

Solution 1:

Solution 2:

Please try the different solution for this puzzle […]