Itm 500 Midterm

Front 1

Q1. List the id , zoo name and species for all animals

Back 1

SELECT Animalid, ZooName, Species From Animal;

Front 2

-Q2. List the id, name and species for all animals in the Tiger species

Back 2

SELECT AnimalID, ZooName, Species FROM Animal WHERE Species = 'Tiger';

Front 3

-Q3. List the employee no., name and salary for all employees whose salary is at least $40000 but is no more than $75000

Back 3

SELECT EmpNo, EmpName, Salary FROM EmployeeWHERE Salary >= 40000 AND Salary <=75000;

Front 4

Q4 List the details for all male employees who are Tiger experts

Back 4

SELECT EmpName, Gender, Species FROM EmployeeWHERE Gender = 'M' AND Species = 'Tiger';

Front 5

-Q5. List the details for all animals who are either of the Tiger species or who are held in the Bowmanville zoo

Back 5

SELECT * FROM AnimalWHERE Species = 'Tiger' OR ZooName = 'Bowmanville zoo';

Front 6

--Q6. List the details for all male employees whose experties is either in the Tiger or Lion species

Back 6

SELECT * FROM EmployeeWHERE Species = 'Tiger' OR Species = 'Lion';

Front 7

-Q7. List details for all animals whose species is neither Tiger nor Lion

Back 7

SELECT * FROM AnimalWHERE Species <> 'Tiger' OR Species <> 'Lion';

Front 8

-Q8. List the details for all employees. Sequence the output by name within species expertise

Back 8

SELECT * FROM EmployeeORDER BY Species, EmpName;

Front 9

-Q9. List the details for all employees with a salary under $45000. Sequence the output from the highest to lowest salary amount

Back 9

SELECT * FROM EmployeeWHERE Salary < 45000ORDER BY Salary DESC;

Front 10

-Q10. List the details for all employes whose species expertise is either Lion or Tiger, and who also have a salary under $100,000 but over $50,000 -- Sequence the output by employee name within zoo name

Back 10

SELECT * FROM EmployeeWHERE (Species = 'Tiger' or Species = 'Lion') AND Salary <= 100000 AND Salary >= 50000ORDER BY ZooName, EmpName;