DROP DATABASE IF EXISTS GShop; 10 CREATE DATABASE GShop; USE GShop; 12 13 14 Def

Question

DROP DATABASE IF EXISTS GShop; 10 CREATE DATABASE GShop; USE GShop; 12 13 14 Define tables 15 16 CREATE TABLE Employees( 17 18 19 20 21 empID CHAR(8), firstName varchar(20), lastName VARCHAR(20), ssn telNumber CHAR(13), salary DECIMAL (10,2), PRIMARY KEY (empID)); CHAR(11) 23 24 25 26 CREATE TABLE Items( 27 28 29 30 31 32 CHAR(5), VARCHAR(30), itemID name description VARCHAR(50), qtyInStock SMALLINT, PRIMARY KEY (itemID)); CREATE TABLE Suppliers( 34 35 36 supID CHAR(5), name VARCHAR (35), address VARCHAR(50), 37 38 PRIMARY KEY (supID)): 40

Explanation / Answer

Solution 1.

SELECT dept.name as Department, CONCAT(emp.firstName, " ", emp.lastName) as "Manager Name" FROM Departments dept, Employees emp where dept.manager = emp.empID

Solution 2.

SELECT emp.firstName, emp.lastName, dept.deptID

FROM Employees emp

INNER JOIN WorksIn work

ON emp.empID=work.empID

INNER JOIN Departments dept

ON work.did= dept.deptID

Solution 3.

Solution 4.

SELECT firstName, lastName, salary from Employees where salary > (SELECT avg(salary) from Employees)

Solution 5.

SELECT firstName, lastName, salary from Employees where salary = (SELECT max(salary) from Employees)

Related Questions

Navigate

• Browse (All)
• Browse D
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.