Animals ID Animal Region Type Owned by Zoo ID 1 African Elephant Africa Mammal 1
ID: 3908996 • Letter: A
Question
Animals ID Animal Region Type Owned by Zoo ID 1 African Elephant Africa Mammal 1 2 African Sriped Weasel Africa Mammal 1 3 American Bison North America Mammal 2 4 Amur (Siberian) Tiger Europe & Asia Mammal 1 5 Amur Leopard Europe & Asia Mammal 2 6 Angora Goat Europe & Asia Mammal 3 7 Arabian Wildcat Africa Mammal 4 8 Bactrian Camel Europe & Asia Mammal 5 9 Bat-eared Fox Africa Mammal 6 10 Black Howler Monkey South America Mammal 7 11 Black-and-White Ruffed Lemur Africa Mammal 8 12 Black-footed Cat Africa Mammal 9 13 Black-footed Ferret North America Mammal 9 14 Bobcat North America Mammal 9 15 Bolivian Gray Titi Monkey South America Mammal 9 16 Bornean Orangutan Australasia Mammal 8 17 Brown Tufted Capuchin Monkey South America Mammal 7 18 Brown-nosed Coati South America Mammal 6 19 Cacomistle South America Mammal 7 20 Chacoan Peccary South America Mammal 8 21 Common Squirrel Monkey South America Mammal 5 22 Cotton-top Tamarin South America Mammal 4 23 Cougar North America Mammal 3 24 Cuvier's Gazelle Africa Mammal 2 25 Degu South America Mammal 7 26 Desert Bighorn Sheep North America Mammal 8 27 Desert Cottontail North America Mammal 9 28 Eastern Black and White Colobus Monkey Africa Mammal 10 29 Giraffe Africa Mammal 10 30 Golden Lion Tamarin South America Mammal 10 31 Grey Wolf North America Mammal 4 32 Hanuman Langur Europe & Asia Mammal 3 33 Hoffman's Sloth South America Mammal 2 34 King Island or Bennet's Wallaby Australasia Mammal 2 35 Kinkajou South America Mammal 2 36 Lesser Hedgehog Tenrec Africa Mammal 1 37 Llama South America Mammal 1 38 Long-tailed Chinchilla South America Mammal 1 39 Mandrill Africa Mammal 1 40 Mara (Patagonian Cavy) South America Mammal 1 41 Navajo Sheep North America Mammal 8 42 Nine-banded Armadillo North America Mammal 9 43 North American Opossum North America Mammal 9 44 Northern Tree Shrew Europe & Asia Mammal 9 45 Norway Rat Worldwide Mammal 8 46 Ocelot South America Mammal 7 47 Pallas' Cat Europe & Asia Mammal 6 48 Prehensile-tailed Porcupine South America Mammal 7 49 Prevost's Squirrel Europe & Asia Mammal 8 50 Red Kangaroo Australasia Mammal 3 51 Red-rumped Agouti South America Mammal 4 52 Ring-tailed Lemur Africa Mammal 5 53 Rock Cavy South America Mammal 6 54 Rock Hyrax Africa Mammal 3 55 Schmidt's Guenon Africa Mammal 2 56 Short-tailed Bat South America Mammal 3 57 Siberian Lynx Europe & Asia Mammal 5 58 Slender-tailed Meerkat Africa Mammal 4 59 Snow Leopard Europe & Asia Mammal 6 60 Southern Flying Squirrel North America Mammal 7 61 Southern Three-banded Armadillo South America Mammal 2 62 Spider Monkey South America Mammal 1 63 Straw-Colored Fruit Bat Africa Mammal 7 64 Thomson's Gazelle Africa Mammal 8 65 Western Lowland Gorilla Africa Mammal 7 66 Western Spotted Skunk North America Mammal 6 67 White Rhinoceros Africa Mammal 5 68 White-fronted Brown Lemur Africa Mammal 4 69 White-handed Gibbon Europe & Asia Mammal 3 70 Wied's Marmoset South America Mammal 3 71 Yellow-bellied Marmot North America Mammal 2 72 Query 5 Create a query called Length of Loans. Display headings for the zoo name, animal, and the number of days on loan. The last field is a calculated field that counts the number of days on loan from the original loan date until today. Sort the output to show the longest loans at the top of the list. Your data will differ, but the output should resemble that in Fi?ure 5-7; only a portion of the data appears in the figureExplanation / Answer
If you have any doubts, please give me comment...
SELECT Z.[Zoo Name], A.[Animal], DateDiff("d", Date(), L.[Date Borrowed]) AS [Days on Loan]
FROM (Animals A INNER JOIN Loans L ON A.ID = L.[Animal ID]) INNER JOIN Zoos Z ON Z.[Zoo ID] = L.[Zoo ID];