Search⌘ K
AI Features
Home
Courses
Learn SQL

Solution: Help a Pet Lover

Explore how to construct an SQL query that extracts names and ages of pets younger than four years old, excludes specific types like fish, and sorts the results alphabetically. This lesson helps you understand filtering with WHERE clauses, combining conditions, and ordering query results for clearer data retrieval.

We'll cover the following...

Query

SELECT name, age
FROM pets
WHERE age < 4
  AND type != 'fish'
ORDER BY name ASC;

Explanation

This SQL query retrieves the names and ages of pets that are younger than 4 ...