Write a statement that will select the City column from the Customers table.

Project the CITY over the CUSTOMER relation.

Query all columns (attributes) for every row in the CITY table.The CITY table is described as follows:

Query a count of the number of cities in CITY having a Population larger than .Input FormatThe CITY table is described as follows:

Select all records where the City column has the value "Berlin".

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.