The input tables are already prepopulated, as given in the problem statement.Output format :The output should display the customer names and the count of prod

Input format :The input tables are already prepopulated, as given in the problem statement.Output format :The output should display the customer names and the count of products each customer has ordered more than once as shown below.Name NumberofProductsPaul 2James 3

You 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.

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

The HR department needs to assess the distribution of skills among employees. Write a query to count the number of skills each employee possesses.Table details are given below:The table is created, and the records are already inserted at the backend. The sample records are given below.EMPLOYEE EMPLOYEE SKILLNote:Table names and Field Names are case-sensitive.Input format :The input records are already prepopulated, as given in the problem statement.Output format :The output displays the details of the employee id, employee Name and the number of skills as shown below.Employee_id Employee_Name Number_of_Skills1 John Doe 32 Jane Smith 13 Alice Johnson 04 Bob Miller 05 Eva Davis 16 Michael Clark 07 Sophie Wilson 18 David Lee 19 Megan White 010 Alex Turner 011 Olivia Harris 012 Daniel Brown 0

Step 3 (2 pts). Use a loop to process each element of the names array to count all customer names that begin with the specified letter. Ex: How many customer names begin with 'B' or 'L'? Output the number of customer names that start with the specified letter. Submit for grading to confirm four tests pass.Ex: If input is:1000 250 P TXthe output is:U.S. ReportCustomers: 1000Highest debt: SullivanCustomer names that start with 'P': 57