Problem StatementFrom the following tables, create a view named mcustomer to display details of salesmen who are associated with more than one customer. Return all the fields of the salesperson.Sample Table: salesmanSample Table: customerNote: Table names and column names are case-sensitive.Input format :The input tables are already prepopulated, as given in the problem statement.Output format :The output is a view named mcustomer that provides details of salesmen who are associated with more than one customer, including their ID, name, city, and commission as shown below.salesman_id name city commision5001 James Hoog New York 0.155002 Nail Knite Paris 0.13

From the following tables, create a view named mcustomer to display details of salesmen who are associated with more than one customer. Return all the fields of the salesperson.Sample Table: salesmanSample Table: customerNote: Table names and column names are case-sensitive.

Problem StatementFrom the following tables, create a view to display pairs of cities where customers and salesmen are located.Sample Table: salesmanSample Table: customerNote:Write View query alone. Selecting from the view query will be done in the back end.Table names and column names are case-sensitive.Input format :The input tables are already prepopulated, as given in the problem statement.Output format :The output should display the pairs of cities where customers and salesmen are located as shown below.custcity salescityLondon LondonNew York New YorkMoscow RomeParis ParisCalifornia ParisLondon ParisBerlin San JoseRefer to the sample output for the column headers.Note :The program will be evaluated only after the “Submit Code” is clicked.Extra spaces and new line characters in the program output will result in the failure of the test case.

From the following table, create a view named salesown to display the details of salesmen, including their ID, name, and city.Sample table: salesmanNote: Table name and column names are case sensitive.Input format :The input records are already prepopulated as per the given requirement.Output format :The output is a view named salesown that provides the details of salesmen, including their ID (salesman_id), name (name), and city (city) as shown below.

Problem StatementYou are tasked with managing sales data for a company. The data includes information about salesmen, customers, and orders. Write a query to find the name and numbers of all salesmen who had more than one customer.The following table is already created, and the records are inserted into the table.The Sample records are given below Input format :The input records are already prepopulated, as given in the problem statement.Output format :The output should include the Salesman_id, Salesman_Name, and Customer_Count for all salesmen who had more than one customer as shown below.Salesman_id Salesman_Name Customer_Count5 Chris Wilson 2Refer to the sample output for the column headers.

From the provided tables, a view named "citymatch" has been created to show all matches of customers with salespersons. The matches are based on the condition that at least one customer in the city is served by a salesperson in the same city.Your task is to modify the existing view to display customer IDs and salesman IDs.Alter the view to be named "citymatch(customer_id, salesman_id)".Sample Table: salesmanSample Table: customerNote:Alter the View query alone. Selecting from the view query will be done in the back end.Table names and column names are case-sensitive.Input format :The input records are already prepopulated, as given in the problem statement.Output format :The output should display the customer IDs and corresponding salesman IDs from the modified "citymatch" view as shown below.customer_id salesman_id3002 50013007 50013005 50023008 50023004 50063009 50033003 50073001 5005