Thank you for your feedback and for sharing the information! The basic idea behind asking to solve the SQL queries and flowchart on the paper is to know how well you can write a code or a query without any help. This does not mean that there is no weightage to the theoretical knowledge, there is a weightage to every aspect or skill that is required for the position you are applying for. However, only theoretical knowledge is also not enough and hence various methods are adapted for the interview process.