HSBC Interview Question

What is static and dynamic SQL with examples?