Cats SQL: Query a Cat Shelter Database to Find Breeds, Adoption Rates, and Longest Residents

Problem You have a shelter database with the following tables: Query 1: List each breed and the number of cats adopted, ordered by adoptions descending. Query 2: Find the cat that stayed in the shelter the longest before being adopted. Follow-ups Rewrite Query 2 to also return cats that are still in the shelter, computing days from intake_date to today. Find breeds where more than 50% of intakes have been adopted. Write a query to detect duplicate cat names within the same breed. How would you i…