This might be good interview question and real time question. In the SQL query many times we get errors, of course, if you have good command on it, you can avoid those errors.
How checking syntax errors? this due to Validate(Bind)/Validate(Run) options.
All the SQL errors except those mentioned in the WHERE clause and INTO , validated during precompilation time.
Bind time validation:
The syntax errors in WHERE clause and INTO will be validated in BIND time. This is also called BIND time errors.
See the sample query:
From Table_1 a