Sql vector created by pikisuperstar — www.freepik.com

Answering one of the common Interview Questions

There are some keywords/clauses in SQL that look like doing same work but are entirely different in their functioning and are often asked in interviews.

WHERE:

WHERE clause is essentially used when the records in the table have to filtered with some specific conditions and cannot be used with Aggregate Functions such as COUNT,SUM,MAX,MIN etc.…. because WHERE clause is used before grouping of data.

COMPANY: AMAZON

DIFFICULTY: EASY

QUESTION: Find all companies with more than 10 employees. Output all columns.

--

--

KS Haarish Dharan

KS Haarish Dharan

Final Year Undergraduate from NIT Trichy writes about Data Science, SQL, Python and about stuffs i read.