Identify the SQL that answers each of the following questions: What are the name
ID: 3744871 • Letter: I
Question
Identify the SQL that answers each of the following questions:
What are the names of all of the different pets in the database?
What are the distinct names of the pets in the database?
What are the species of all of the different pets in the database?
What are the distinct species of the pets in the database?
What are the genders of all of the different pets in the database?
What are the distinct genders of the pets in the database?
What are the genders and altered status of all of the different pets in the database?
What are the distinct genders and altered status of the pets in the database?
Explanation / Answer
1. SELECT PETSNAME FROM PETS ;
2. SELECT DISTINCT PETSNAME FROM PETS;
3. SELECT SPECIES FROM PETS;
4. SELECT DISTINCT SPECIES FROM PETS;
5. SELECT GENDER FROM PETS;
6 SELECT DISTINCT GENDER FROM PETS;
7 SELECT GENDER, ALTERED_STATUS FROM PETS;
8 SELECT DISTINCT GENDER,ALTERED_STATUS FROM PETS;