M3 Interview Question

What is difference between Retesting and Regression testing? Provide an example of a simple SQL query. Why is regression testing important? What determines the criteria for the steps and expected results of a test case?