SELECT * 
FROM family_members;

SELECT name, species
FROM family_members;

SELECT *
FROM family_members
WHERE species = 'dog';

SELECT * 
FROM family_members
WHERE num_books_read > 190;

SELECT * 
FROM family_members
WHERE num_books_read >= 180;

SELECT *
FROM friends_of_pickles
WHERE species = 'dog' AND height_cm < 45;

SELECT *
FROM friends_of_pickles
WHERE species = 'dog' OR height_cm < 45;

SELECT *
FROM friends_of_pickles
WHERE species NOT IN('cat', 'dog');

SELECT DISTINCT SPECIES
FROM friends_of_pickles
WHERE height_cm > 50;

SELECT *
FROM friends_of_pickles
ORDER BY height_cm DESC;

SELECT *
FROM friends_of_pickles
ORDER BY height_cm DESC LIMIT 1;

SELECT COUNT(*)
FROM friends_of_pickles;

SELECT COUNT(*)
FROM friends_of_pickles
WHERE species = 'dog';

SELECT SUM(num_books_read)
FROM family_members;

SELECT AVG(num_books_read)
FROM family_members;

SELECT MAX(num_books_read)
FROM family_members;