Question: CREATE TABLE Staff ( staffNo VARCHAR ( 5 ) PRIMARY KEY, lName VARCHAR ( 1 5 ) , branchNo VARCHAR ( 5 ) , salary
CREATE TABLE Staff staffNo VARCHAR PRIMARY KEY, lName VARCHAR branchNo VARCHAR salary DECIMAL;
INSERT INTO Staff VALUES SC 'Smith', B;
INSERT INTO Staff VALUES SC 'Brown', B;
INSERT INTO Staff VALUES SC 'Doe', B;
INSERT INTO Staff VALUES SC 'Jones', B;
SELECT staffNo, lName, branchNo, salary
FROM Staff
WHERE salary
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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
