Gephels Interview Questions and Answers

Swiggy is an Indian food delivery company that operates through a website and mobile app.

• Swiggy was founded in 2014 and is headquartered in Bangalore, India.

• It partners with local restaurants to provide food delivery services to customers.

• Swiggy's business model is based on charging a commission fee from the restaurants for every order placed through their platform.

• It has expanded to over 500 cities in India and has over 200,000 restaurant partners.

• SQL queries are used to ret...read more

Query to find students with over 80 marks in English subject

• Use SELECT statement to retrieve data

• Filter the results using WHERE clause for marks greater than 80

• Include condition for English subject using AND operator

Use a SQL query with JOIN to retrieve employees between specified dates.

• Use the JOIN keyword to combine data from two tables

• Specify the date range using the WHERE clause

• Example: SELECT * FROM employees e JOIN dates d ON e.date = d.date WHERE d.date BETWEEN '2022-01-01' AND '2022-12-31'

Rank function in Google Sheets is used to assign a rank to a value in a list based on its order.

• Rank function is used to determine the rank of a value in a list.

• It can be used to rank values in ascending or descending order.

• The syntax for the rank function is RANK(value, range, [is_ascending]).

HAVING clause is used in SQL to filter groups based on specified conditions after GROUP BY clause.

• HAVING clause is used with GROUP BY clause to filter groups based on specified conditions.

• It is used to filter the results of aggregate functions like COUNT, SUM, AVG, etc.

• It is used to apply conditions to groups, similar to WHERE clause which applies conditions to individual rows.

• Example: SELECT department, AVG(salary) FROM employees GROUP BY department HAVING AVG(salary) > 5000...read more

The order of query execution in SQL is: FROM, WHERE, GROUP BY, HAVING, SELECT, ORDER BY.

• FROM: Specifies the tables from which data will be retrieved.

• WHERE: Filters the rows based on specified conditions.

• GROUP BY: Groups the rows based on specified columns.

• HAVING: Filters the groups based on specified conditions.

• SELECT: Retrieves the columns specified in the query.

• ORDER BY: Sorts the result set based on specified columns.

Aggregate functions are used to perform calculations on groups of rows in a table.

• Aggregate functions include SUM, AVG, COUNT, MIN, and MAX.

• They are commonly used in SQL queries to summarize data.

• For example, you can use SUM to calculate the total sales for a specific product.

• Another example is using AVG to find the average salary of employees in a department.