365 Days of Daily Coding: Day 32

I tried a difficult question on the SQLpad but it proved to be challenging hence I was unable to solve it. I had to categorise the records, count the number in each categories and display the categories with their counts in columns. I tried to use the PIVOT() function but the function is not available to be used. I don’t understand why.

I also may have some copyright issues if I continue to post the questions from the site and also post my solutions in the blog. If I continue to use them, I may need to ask permission which I don’t think would be favored by the owner. Hence forth, I will only be sharing the challenges that I have solved that particular day and any new topics that I have learnt.

Below are the two links to the challenges that I solved today.

Challenge 1 Solved

Challenge 2 Solved

• Facebook
• Instagram
• LinkedIn
• GitHub