Question d’entretien chez Infosys

Describe the execution order of sql - select,order, group by, having ,where. A problem on subarray it as a dp problem. Prime number optimised manner. reverse a string without using additional space.