Untitled

mail@pastecode.io avatar
unknown
plain_text
a year ago
625 B
1
Indexable
Never
-- 2 records with department_id = 2
INSERT INTO user_feedback
(feedback_id, user_id, department_id, rating, comments, feedback_time, feedback_status)
VALUES
    (1, 1, 2, 5, 'Great service', NOW(), 1),
    (2, 2, 2, 4, 'Staff was helpful', NOW(), 1);

-- 2 records with department_id = 1
INSERT INTO user_feedback
VALUES
    (3, 1, 1, 3, 'Equipment needs updating', NOW(), 1),
    (4, 2, 1, 2, 'Floor was dirty', NOW(), 1);

-- 2 records with department_id = 3
INSERT INTO user_feedback
VALUES
    (5, 1, 3, 5, 'Loved the environment', NOW(), 1),
    (6, 2, 3, 4, 'Instructors were knowledgeable', NOW(), 1);