Yatra Production Analyst Interview Questions and Answers

My name is John Smith.

• My first name is John.

• My last name is Smith.

• I go by the name John Smith.

I majored in Business Administration with a focus on Operations Management.

• Studied courses like Supply Chain Management, Production Planning, and Inventory Control

• Participated in case competitions related to optimizing production processes

• Completed internships at manufacturing companies to gain hands-on experience

My father's name is John Smith.

• His first name is John.

• His last name is Smith.

• He goes by the name John Smith.

• He is known as Mr. Smith in his workplace.

SQL code for having clause

• Use the HAVING clause to filter groups based on aggregate functions

• It is used with the GROUP BY clause

• Example: SELECT department, AVG(salary) FROM employees GROUP BY department HAVING AVG(salary) > 50000;

WHERE is used to filter rows before grouping or aggregating, while HAVING is used to filter groups after grouping or aggregating.

• WHERE is used with SELECT, UPDATE, DELETE statements to filter rows based on a condition

• HAVING is used with GROUP BY clause to filter groups based on a condition

• WHERE is applied before the grouping operation, while HAVING is applied after the grouping operation