Intro DB : Syntax SQL

Perintah SQL INSERT yang benar untuk menambahkan data baru ke tabel "Customers" adalah

• INSERT INTO Customers (customer_id, customer_name, customer_address) VALUES (1, 'John Doe', '123 Main St')
• INSERT INTO Customers (customer_name, customer_address) VALUES ('Jane Smith', '456 Oak Ave')
• INSERT INTO Customers (customer_id, customer_name) VALUES (2, 'Jane Smith')
• INSERT INTO Customers VALUES (3, 'Michael Johnson', '789 Elm Rd')

Perintah SQL INSERT yang benar untuk menambahkan data baru ke tabel "Products" adalah:

• INSERT INTO Products (product_id, product_name, product_price) VALUES (1, 'Product A', 10.99)
• INSERT INTO Products (product_name, product_price) VALUES ('Product B', 24.95)
• INSERT INTO Products (product_id, product_name) VALUES (2, 'Product B')
• INSERT INTO Products VALUES (3, 'Product C', 8.49)

Perintah SQL INSERT yang benar untuk menambahkan data baru ke tabel "Orders" adalah

• INSERT INTO Orders (order_id, customer_id, order_date) VALUES (1, 1, '2023-07-01')
• INSERT INTO Orders (customer_id, order_date) VALUES (2, '2023-07-02')
• INSERT INTO Orders (order_id, order_date) VALUES (3, '2023-07-03')
• INSERT INTO Orders VALUES (4, 3, '2023-07-04')

Perintah SQL INSERT yang benar untuk menambahkan data baru ke tabel "Order_Items" adalah

• INSERT INTO Order_Items (order_id, product_id, quantity, product_price) VALUES (2, 2, 3, 7.49)
• INSERT INTO Order_Items (item_id, order_id, product_id, quantity, product_price) VALUES (1, 1, 1, 2, 15.99)
• INSERT INTO Order_Items (item_id, quantity, product_price) VALUES (3, 3, 8.49)
• INSERT INTO Order_Items VALUES (4, 4, 5, 1, 9.95, 0)

Perintah SQL INSERT yang benar untuk menambahkan data baru ke tabel "Employees" adalah

• INSERT INTO Employees (employee_id, employee_name, employee_position, department_id) VALUES (1, 'John Smith', 'Manager', 2)
• INSERT INTO Employees (employee_name, employee_position) VALUES ('Jane Doe', 'Supervisor')
• INSERT INTO Employees (employee_id, employee_name) VALUES (2, 'Jane Doe')
• INSERT INTO Employees VALUES (3, 'Michael Johnson', 'Salesperson', 3)

Perintah SQL INSERT yang benar untuk menambahkan data baru ke tabel "Departments" adalah

• INSERT INTO Departments (department_name) VALUES ('Marketing')
• INSERT INTO Departments (department_id, department_name) VALUES (1, 'Sales')
• INSERT INTO Departments (department_id) VALUES (2)
• INSERT INTO Departments VALUES (3, 'Finance')

Perintah SQL INSERT yang benar untuk menambahkan data baru ke tabel "Sales" adalah

• INSERT INTO Sales (sale_id, employee_id, order_id, sale_date) VALUES (1, 1, 1, '2023-07-05')
• INSERT INTO Sales (employee_id, order_id, sale_date) VALUES (2, 2, '2023-07-06')
• INSERT INTO Sales (sale_id, sale_date) VALUES (3, '2023-07-07')
• INSERT INTO Sales VALUES (4, 3, 3, '2023-07-08')

Perintah SQL INSERT yang benar untuk menambahkan data baru ke tabel "Suppliers" adalah

• INSERT INTO Suppliers (supplier_id, supplier_name) VALUES (2, 'DEF Suppliers')
• INSERT INTO Suppliers (supplier_name, supplier_address) VALUES ('XYZ Company', '456 Supplier Ave')
• INSERT INTO Suppliers (supplier_id, supplier_name, supplier_address) VALUES (1, 'ABC Suppliers', '123 Supplier St')
• INSERT INTO Suppliers VALUES (3, 'GHI Corporation', '789 Supplier Rd')

Perintah SQL INSERT yang benar untuk menambahkan data baru ke tabel "Stocks" adalah

• INSERT INTO Stocks (stock_id, product_id, quantity) VALUES (1, 1, 100)
• INSERT INTO Stocks (product_id, quantity) VALUES (2, 75)
• INSERT INTO Stocks (stock_id, quantity) VALUES (3, 50)
• INSERT INTO Stocks VALUES (4, 3, 200)

Perintah SQL INSERT yang benar untuk menambahkan data baru ke tabel "Promotions" adalah

• INSERT INTO Promotions (promotion_id, product_id, start_date, end_date, Disc) VALUES (1, 1, '2023-07-10', '2023-07-20', 0.1)
• INSERT INTO Promotions (product_id, start_date, end_date, Disc) VALUES (2, '2023-07-15', '2023-07-25', 0.15)
• INSERT INTO Promotions (promotion_id, start_date, end_date) VALUES (3, '2023-07-18', '2023-07-28')
• INSERT INTO Promotions VALUES (4, 3, '2023-07-20', '2023-07-30', 0.05)