CC#•Created by yummy_bee on 9/27/2024 in #help SQL code
ALTER TABLE Suppliers
ADD QualityID int;
CREATE TABLE Quality (QualityID int PRIMARY KEY, QualityLevel varchar(20) NOT NULL);
INSERT INTO Quality (QualityID, QualityLevel)
VALUES
(0, 'Acceptable'),
(1, 'Medium'),
(2, 'High');
UPDATE Suppliers
SET QualityID = 1;