SophiaPretty

(5)

$14/per page/Negotiable

About SophiaPretty

Levels Tought:
Elementary,Middle School,High School,College,University,PHD

Expertise:
Accounting,Algebra See all
Accounting,Algebra,Applied Sciences,Architecture and Design,Art & Design,Biology,Business & Finance,Calculus,Chemistry,Communications,Computer Science,Economics,Engineering,English,Environmental science,Essay writing Hide all
Teaching Since: Jul 2017
Last Sign in: 305 Weeks Ago, 1 Day Ago
Questions Answered: 15833
Tutorials Posted: 15827

Education

  • MBA,PHD, Juris Doctor
    Strayer,Devery,Harvard University
    Mar-1995 - Mar-2002

Experience

  • Manager Planning
    WalMart
    Mar-2001 - Feb-2009

Category > Computer Science Posted 12 Jan 2018 My Price 10.00

view called VAnimal1 which will have a count

--Lab Week 10 sql

Using the Animals 2 database undertake the following

1) Create a view called VAnimal1 which will have a count for each zoo of the employees that are experts and their average salary

2) Create a view called VAnimal2 that will contain a count of zoo held animals by species

3) Create a view called VAnimal3 that will have for each animal that is a father, a count of the fathered offspring. Then using these views write the following queries

4) List the details for the animal that has fathered the most offspring

5) List the details for the species with the highest number of zoo held animals

6) List the details for the employees that earn more than the average for employees working at the same zoo

7) List the details for animals held in the zoo with highest number of employees

Need queries for the questions above. Will only accept answer if it works and outputs the correct answer. Thank you. I have attached the database. 

 

Attachments:

Answers

SophiaPretty
(5)
Status NEW Posted 12 Jan 2018 02:01 PM My Price 10.00

-----------  ----------- H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly

Not Rated(0)