Scribd
Upload
1 views1 page

Java Assessment13

The document contains SQL commands for managing a database, including inserting a new employee, selecting products based on price, updating an employee's salary, deleting orders based on date, counting products with a certain quantity, and altering the Employees table to add a hire date column. It also notes that there is no Orders table present in the database. These commands demonstrate basic database operations such as CRUD (Create, Read, Update, Delete) and schema modification.

Uploaded by

buvanaa2502
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
1 views1 page

Java Assessment13

The document contains SQL commands for managing a database, including inserting a new employee, selecting products based on price, updating an employee's salary, deleting orders based on date, counting products with a certain quantity, and altering the Employees table to add a hire date column. It also notes that there is no Orders table present in the database. These commands demonstrate basic database operations such as CRUD (Create, Read, Update, Delete) and schema modification.

Uploaded by

buvanaa2502
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

1

INSERT INTO Employees (name, position, salary, hire_date)


VALUES ('Alice', 'Engineer', 75000.00, '2024-06-01');

2.
SELECT product_name, price
FROM Products
WHERE price > 200.00;

3.
UPDATE Employees
SET salary = 90000.00
WHERE id = 3;

4.
DELETE FROM Orders
WHERE order_date < '2024-01-01';
note:from the given data there is no order table

5.
SELECT COUNT(*)
FROM Products
WHERE quantity > 50;

6.
ALTER TABLE Employees
ADD hire_date DATE;

You might also like