Question 1 Sort the data on the basis of the length of the name (descending order). Nime City Product James Carn London Coconut Hazelnut Ricky Martin Samuel Sean Andreaw Mils Paris Tokyo Bangkok Patna Newyork Paris Coconut Mango Banana Kelly Lewis Jordan Sngh Sona Tyagi Tiger wood Maria Dean Darny Duu Schera Chuu Mango Date Being New Delhi Orange Hazelnut Apple Mango Mango Carberra Bangalore Ontario Sudhi Arora Suit Kumar ha London Banana Use right and left function to remove the 1st and last letter from the city name. So if we have Boston - we want the result to be Question 2 'osto Name City Product London Paris James carn Mango Ricky Martin Hazelnut Pire Apple Apple Apple Banana Samuel Sean Tokyo Andreaw Mils Bangkck Patna Kelly Lewis Jordan singh Sorka Tyag Tiger wood Maria Dean Darny Duu Schera Chuu Newyork Paris Banana Being New Delhi Carberra Apple Coconut Hazelnut Banglore Kolkata Сесс Mango Sudhir Arora Create a new column using PostCode and it shoud be of length 5 (Add d's at the front if the length of the postcode is less t Question 3 City PostCode London 251866 Paris 10068 Tokyo Bargkok Patna 1002 25 8512 125896 Newyork Paris 325 Being New Delhi 8541 Carberra 23 Question 4 Please put the first name and last name in their respective columns Nme Arkit Sngh Sachn Gupta Rajev ha James Carn Frst Nime Last name Ricky Martn Samul Sean Kelly Lewis Tiger wood Maria Dean Darny Duu Sumit Tyag

Q: please use store procedures to answer the following question Create a procedure to update Job Title…

A: CREATE TABLE job(p_job_id varchar(2) primary key,p_new_job_title varchar(20)); /* Create few records…

Q: You need to return the USER_ID, and the TRAVEL_TIME column which is calculated using the TIMEDIFF…

A: TRAVEL_TIME is calculated as the difference between TRAVEL_END_TIME and TRAVEL_START_TIME TIMEDIFF…

Q: List the components that are automatically created when you place a DataGridView control on a form.

A: Components which are created automatically when the user places a “DataGridView” control on a form:…

Q: Excel Project How do create a formula to calculate daily totals in dollars. Multipy the value in the…

A: Excel is a software program developed by Microsoft. Excel has an electronic spreadsheet to organize…

Q: Display the final price in the following format:  The final price is $_____. Please include the…

A: i have used the go code for the following requirement

Q: Project/folder name is LastName Web application consists of a single page titled "Your Name Wk 3"…

A: answer

Q: The InstantRide User Satisfaction team is a core team for InstantRide, and they focus on increasing…

A: sql command for the question is given in step 2

Q: Exercise: Create a statement that will make a copy of the vendors table. The name of the copy should…

A: Statement to copy content of one table into another table in SQL Statement which delete a table in…

Q: Beginning in cell F4, enter a formula using the IFS function to calculate the commission rate based…

A:

Q: In EXCEL: Assuming you are working with a table named SalesData, which of the following formulas…

A: Assuming you are working with a table named SalesData, which of the following formulas will display…