What is a query processing??

Question

I preferably need to know the algorithms behind it

Answer 1

If you want to learn about the inner working of SQL database engines, this is an excellent resource:
https://use-the-index-luke.com/