Trainee Scientist Interview Questions and Answers for Freshers

Python code for data frames in pandas library

• Import pandas library

• Create a data frame using pd.DataFrame()

• Access and manipulate data using various methods like loc, iloc, and groupby

SQL order of execution determines the sequence in which different clauses are processed in a query.

• SQL order of execution: FROM -> WHERE -> GROUP BY -> HAVING -> SELECT -> ORDER BY.

• Joins are processed before WHERE clause.

• Aggregate functions are processed after WHERE clause but before SELECT clause.

• Subqueries are processed from innermost to outermost.