Yatra 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

Routing in the USA involves understanding major travel hubs, direct flights, and regional connections for efficient travel planning.

• Major Hubs: Key airports like JFK (New York), LAX (Los Angeles), and ORD (Chicago) serve as primary gateways for domestic and international flights.

• Direct Flights: Many cities offer direct flights to popular destinations, such as Miami to San Francisco, reducing travel time.

• Regional Connec...read more