But now for the advanced and important stuff: How can we modify it to also pull the same from the table “girls” in a single query? I like SQL efficiency and inclusivity, and I’m sure half of all dogs agree. (Well, according to my research, all dogs like inclusivity, but only 50% likes SQL efficiency)
I haven’t postgres’d in ages, but I’ll give it a shot anyway:
SELECT name FROM boys WHERE good = true;I think you could also do:
SELECT name FROM boys WHERE good;But now for the advanced and important stuff: How can we modify it to also pull the same from the table “girls” in a single query? I like SQL efficiency and inclusivity, and I’m sure half of all dogs agree. (Well, according to my research, all dogs like inclusivity, but only 50% likes SQL efficiency)
A better database design would have been to name the table
dogsand add a column to indicate whether the dog is aboyor agirl, maybe with enums