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) satisfying criteriaspecified 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 between them.• 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
In SQL, which of the following JOIN type should be used to get list of students enrolled in at least one course?
