Click me to see the solution. 25. From the following tables, write a SQL query to count the number of unavailable rooms for each block in each floor. Sort the result-set on block floor, block code. Return the floor ID as "Floor", block ID as "Block", and number of unavailable as "Number of unavailable rooms". 78. Content management system: Based on WordPress or on likes of the same. A database will allow easier management, deletion, addition, and removal of content. A lot of people are going to pursue this, as it is one of the best database project ideas for final-year students. 79.