pls do the sql command

Build the following tables and create the index and view as given in questions 2,3,4. Show the screenshot of the your Query and index \& view pages. 1. Create the following table " salesman". (1 points) 2. Creates an index named "idx_id" on the "salesman_id"column in the "salesman" table using SQL. Query. (1 points) 3. Creates an index named "idx_name" on the "name" and "city" columns in the "salesman" table using squ Query. (1 points) 4. Create a view 'Parisstaff' for those salespersons belong to the city "Paris" using SQL query. (1 points) 5. Delete the indexes. (0.5 point ) 6. Delete the views. (0.5 point)