Question: CREATE TABLE Staff ( staffNo VARCHAR ( 5 ) PRIMARY KEY, lName VARCHAR ( 1 5 ) , branchNo VARCHAR ( 5 ) , salary

CREATE TABLE Staff (staffNo VARCHAR (5) PRIMARY KEY, lName VARCHAR (15), branchNo VARCHAR (5), salary DECIMAL(7,2));
INSERT INTO Staff VALUES ('SC13', 'Smith', 'B003',17300);
INSERT INTO Staff VALUES ('SC16', 'Brown', 'B003',8300);
INSERT INTO Staff VALUES ('SC17', 'Doe', 'B005',20500);
INSERT INTO Staff VALUES ('SC11', 'Jones', 'B005',15500);
SELECT staffNo, lName, branchNo, salary
FROM Staff
WHERE salary >10000
GROUP BY branchNo
ORDER BY branchNo, salary;
Given the SQL code above, which piece of data below will be treated as a primary key?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!