SQL Queries in different approaches

Whenever I attend Interviews the interviewer asking me few sql queries without using "this" particular function, first we should understand what is his/her expectation? For each query we can give different ways to get the result. In this article I'm going to explain how to write queries in different, different approaches.

SQL Queries:

Description:

Whenever I attend Interviews the interviewer asking me few sql queries without using "this" particular function, first we should understand what is his/her expectation? For each query we can give different ways to get the result. In this article I'm going to explain how to write queries in different, different approaches.