Answer the given question based on the information given below:A data manipulation language (DML) statements are used for managing data in database. Syntax for few DML statements explained below.
A. SELECTi. Usage: SELECT is used to retrieve information from one or more tables for tuples (records) satisfyingcriteria specified in where clause.ii. Syntax: SELECT table1.COLUMN1, table2.COLUMN2, … FROM table1, table2 WHERE condition;e.g. SELECT city.NAME FROM city WHERE city.COUNTRY = ’INDIA’;B. INSERTi. Usage: INSERT statement is used to place a new tuple into database. Note: Primary Key column valueshould be unique for that record.ii. Syntax: INSERT INTO table-name (column1, column2, ...) VALUES (column1_value, column2_value,column3_value, ….);C. UPDATEi. Usage: UPDATE is used to modify value of one or more attributes (columns) for existing tuple(s) of a tablesatisfying the where condition criteriaii. UPDATE table-name SET column-name = value WHERE condition;An SQL JOIN clause is used to combine rows from two or more tables, based on a relationship field betweenthem.• INNER JOIN: Return rows when there is at least one match in BOTH tables.• LEFT JOIN: Return rows from left table, also the matched rows from right table if any.• RIGHT JOIN: Return rows from right table, also the matched rows from left table if any.• FULL JOIN: Return rows from left / right tables.
Select the appropriate JOIN for the below SQL, given that only those Customers records should come for whom Order(s) is there.SELECT Orders.OrderID, Customers.CustomerName, Orders.OrderDate FROM Customers____________ JOIN Orders ON Orders.CustomerID=Customers.CustomerID;
