Database Fundamentals

Refer to the exhibit.

```
INSERT INTO Products (ProductID, ProductName, Price) VALUES (1, 'Widget', 10);
INSERT INTO Products (ProductID, ProductName, Price) VALUES (2, 'Gadget', 20);
INSERT INTO Products (ProductID, ProductName, Price) VALUES (3, 'Widget', 15);
SELECT ProductName, COUNT(*) FROM Products GROUP BY ProductName HAVING COUNT(*) > 1;
```

Refer to the exhibit.

CREATE TABLE employees (
    employee_id INT PRIMARY KEY,
    first_name VARCHAR(50),
    last_name VARCHAR(50),
    department_id INT,
    hire_date DATE
);

INSERT INTO employees VALUES (1, 'John', 'Doe', 10, '2021-01-15');
INSERT INTO employees VALUES (2, 'Jane', 'Smith', 20, '2020-06-01');
INSERT INTO employees VALUES (3, 'Bob', 'Johnson', 10, '2022-03-22');