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 value shouldbe 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.
What will below SQL query do?SELECT * FROM ORDERS where ORDERDATE BETWEEN ‘07/04/2015’ and ‘07/09/2016’;
