The relational schema of the database for IT equipment of the branches of the st

Question

The relational schema of the database for IT equipment of the branches of the stat employees cooperative of is: Branch (branchCode, name, numberOfEmployees) Equipment (equipmentCode. type) List (branchCode. equipmentCode. dateOfAcquisition. numberOfEquIpmen, unitPrice) the list of branches having equipments of type 'computer' for each branch, the proportion of the number of ail equipment over the number employees the proportion of the number of all equipment over the number of employees for a:l branch combined the names of the branches that do not have any equipment of 'porter' type the names of the branches having 'printer' and 'scanners' the name of the branch having the highest total price for equipment The branches having equipment of all types.

Explanation / Answer

Q3.4

SELECT list_name, aggregate_function(list_name)
FROM table_name
WHERE list_name operator value
GROUP BY list_name
HAVING aggregate_function(list_name) operator value;

Q3.8

SELECT branch_name
FROM table_name
HAVING Printer and Scanner(branch_name) ;

Q3.9.

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---