Using the om database:Write a statement that displays these fields:customer’s first namecustomer's last nameorder idorder date of orders placedUse the default JOIN type, use table aliases of C for customers and O for orders, and use the ON keyword when joining. The fields should be displayed in the order listed above. Notes:This statement requires joining tables together so I recommend you review the document provided titled 'Notes on database om'.Copy/Paste your answer from your Workbench into the textbox belowRemove any "extra" spaces between each keyword ### SQL Query Examples and Database Schema#### Database Schema OverviewIn the Navigator panel, the schema "ap" contains the following tables:- **customers** - Columns: `customer_id`, `customer_first_name`, `customer_last_name`, `customer_address`, `customer_city`, `customer_state`, `customer_zip`, `customer_phone`, `customer_fax` - Indexes, Foreign Keys, Triggers- **order_details** - Columns: `order_id`, `item_id`, `order_qty` - Indexes, Foreign Keys, Triggers- **items** _(No visible columns)_#### SQL Queries1. **Select All Records from Customers Table** ```sql USE om; SELECT * FROM customers; ```2. **Select Specific Columns** ```sql SELECT customer_first_name, customer_last_name FROM customers; ```3. **Concatenate First and Last Names** ```sql SELECT CONCAT(customer_first_name, ' ', customer_last_name) AS 'FULL NAME' FROM customers; ``` - **Output:** Returns full names of customers.4. **Order by Last Name** ```sql SELECT customer_last_name, customer_last_name, order_date FROM customers C, orders O JOIN Orders O ON C.customer_id = O.customer_id ORDER BY customer_last_name, customer_last_name; ``` - **Note:** There is a syntax error in this query. The error message indicates an unknown column and duplicate alias issue.#### Action Output Panel- **Query Results and Errors:** - **Successful Query Execution:** - Example: The concatenation query returned 25 rows. - **Error Messages:** - Error Code 1054: Unknown column in the field list. - Error Code 1066: Not unique table alias. This section demonstrates common SQL operations such as selecting, concatenating, and ordering data, while also highlighting errors that may arise from syntax issues. ## Using the om Database:Write a SQL statement that displays the following fields:- Customer’s first name- Customer’s last name- Order ID- Order date of orders placed### Instructions:- Use the default `JOIN` type.- Assign table aliases as follows: use `C` for customers and `O` for orders.- Utilize the `ON` keyword for joining tables.- Ensure the fields are displayed in the specified order (as listed above).### Notes:- This task requires joining tables, so it's advisable to review the document titled "Notes on database om."- Copy and paste your answer from your Workbench into the textbox below.- Remove any "extra" spaces between each keyword.### Enter your query:`type your answer…`

Let's first understand JOIN :- JOIN IN SQL:- Join combines the records from two tables It compares the rows of table one and table two to check whether any record matches based on the condition provided in the on clause. If the condition is met, it returns the matched rows of both tables. Syntax:- select col_name1,col_name2,..... From table1 JOIN table 2 on table1.col_name=table2.col_name; Join Two tables of customers and orders by using JOIN and using the On keyword and specify the condition of joining. It will return those records which have the same customer id in both tables. It compares the rows of the customers table and orders table to check whether any record matches based on the condition provided in the on clause. If the condition is met, it returns the matched rows of both tables. And returns the specified columns in select statements. #Below Query will return the desired Output as requested select C.customer_first_name,C.customer_last_name,O.order_id,O.order_datefrom customers CJOIN orders O ON C.customer_id=O.customer_id;