CA-22 : Select Queries from DVD Rental database

Given task : Selecting queries from the dvd rental database using the postgre and pgadmin 4 on the macOS I started with basic data retrieval by selecting film titles along with their rental rates. To make the output more readable, I used column aliases to rename fields like title to Movie Title and rental_rate to Rate. This small step made a big difference in how clean the results looked. there were numerous task assigned to this specific topic which is 25 subtopics . ^ Moving forward, I worked on sorting data. For example, I retrieved a list of films sorted by rental rate in descending order. In cases where multiple films had the same rental rate, I applied a secondary sort based on the title in alphabetical order. This introduced me to multi-level sorting using the ORDER BY clause. I also practiced sorting actor names by last name and then by first name, which reinforced my understanding of ordering data across multiple columns. Similarly, I retrieved unique values such as replacemen