Hello, please write the SQL code in text not image so it can be copy-pasted. Use the table attached to the question if n
Posted: Thu May 05, 2022 1:37 pm
Hello, please write the SQL code in text not image so it can be
copy-pasted. Use the table attached to the question if necessary to
write appropriate code.
Ch11p1: The Animal Shelter needs a report that lists the breed ID's, the animal's age and gender, and a notation of whether the animal is in the shelter or on the wishlist. Write a compound query to produce this report-label columns and format age and gender as shown below. (There are 40 records) Breed ID Age Gender Stu 2 In shelter In shelter In shelter In shelter In shelter In shelter In shelter. In shelter In shelter In shelter In shelter In shelter In shelter In shelter In shelter. In shelter. In shelter. In shelter In shelter In shelter In shelter In shelter In shelter Wishlist Wishlist Wishlist Wishlist 6 6.0F 14 6.0 M 67 5.0 F 2 4.0M S 38 4.0 M 6 10 3.0 F 7 10 3.0M 14 3.0M 9 15 3.0M 10 18 3.0 F 11 44 3.0 F 12 2 2.0 F 5 2.0 F 5 2.0M 12 2.0 F 15 2.0M 83 2.0M 31.0M 4 1.0M 8 1.0 F 10 1.0M 29 1.0 F 57 1.0M 57 5.0 M 38 4.0 M 23.0M 10 3.0 F 3 4 14 15 16 17 18 19 20 21 24
copy-pasted. Use the table attached to the question if necessary to
write appropriate code.
Ch11p1: The Animal Shelter needs a report that lists the breed ID's, the animal's age and gender, and a notation of whether the animal is in the shelter or on the wishlist. Write a compound query to produce this report-label columns and format age and gender as shown below. (There are 40 records) Breed ID Age Gender Stu 2 In shelter In shelter In shelter In shelter In shelter In shelter In shelter. In shelter In shelter In shelter In shelter In shelter In shelter In shelter In shelter. In shelter. In shelter. In shelter In shelter In shelter In shelter In shelter In shelter Wishlist Wishlist Wishlist Wishlist 6 6.0F 14 6.0 M 67 5.0 F 2 4.0M S 38 4.0 M 6 10 3.0 F 7 10 3.0M 14 3.0M 9 15 3.0M 10 18 3.0 F 11 44 3.0 F 12 2 2.0 F 5 2.0 F 5 2.0M 12 2.0 F 15 2.0M 83 2.0M 31.0M 4 1.0M 8 1.0 F 10 1.0M 29 1.0 F 57 1.0M 57 5.0 M 38 4.0 M 23.0M 10 3.0 F 3 4 14 15 16 17 18 19 20 21 24