ITEC 3220 Quiz: Assignment2 3220

101 views5 pages
Ambassador badge icon
13 Dec 2021
Course
Professor

Document Summary

Fields terminated by optionally enclosed by " trailing. List operations of services implemented in 3-bedroom cottages. 2: [8] list cottages (cnum and category) where more than one service was implemented. [8] list cottages (cnum and rent) where service "babysitting" was not implemented. Where service2. sid = implements2. sid and: [10] display all employees (eid and name) and the total number of different services implemented by each employee. If no service was implemented by an employee, display 0. Where b. eid = employee2. eid: [8] find the names of employees (including managers) whose salary is higher than the salary of any manager. From employee2: [8] find employees (id and names) who implemented both cooking and babysitting services. 6 display the names of managers of the employees who implemented cooking service. Q5 find the employees (id and names) who implemented the highest number of different services.

Get access

Grade+20% off
$8 USD/m$10 USD/m
Billed $96 USD annually
Grade+
Homework Help
Study Guides
Textbook Solutions
Class Notes
Textbook Notes
Booster Class
40 Verified Answers

Related Questions