HSBC interview question

What is static and dynamic SQL with examples?