## SQL interview question | Write the query

Question
We have two columns(Revenue and Cost Price) in a table like below, get me the Profit column Revenue       Cost Price        Profit 100                  Null            ...
solved 0
4 months 35 Answers 747 views Master

## Statistics Basics

Question
The mean of a distribution is 20 and the standard deviation is 5. What is the value of the coefficient of variation?
in progress 1
4 months 34 Answers 631 views Member

## What is the use of OFFSET command?

Question
With coding example
solved 2
4 months 32 Answers 936 views Master

## Statistics Basics 3 | Interview Question

Question
According to the empirical rule, approximately what percent of the data should lie within μ±2σ?
in progress 0
4 months 29 Answers 531 views Member

## What is the order of execution of SQL commands?

Question
How does the SQL commands flow at the back end?
solved 5
4 months 27 Answers 917 views Master

## SQL interview Question | Second Highest Salary – Method 1

Question
Write a SQL query to get second highest query using sub query
in progress 0
4 months 27 Answers 557 views Master

## Statistics Basics 2 | Interview Question

Question
Which of the following describe the middle part of a group of numbers? a. Measure of Variability b. Measure of Central Tendency c. Measure of Association d. Measure of Shape
in progress 0
4 months 26 Answers 520 views Member

## Write a SQL query to find all the student names Nitin in a table

Question
Table is student column is name Make sure that you cover all the corner cases
solved 1
4 months 25 Answers 497 views Member

## SQL Interview question

Question
Write a query to get all the student with name length 10, starting with K and ending with z
solved 0
4 months 25 Answers 439 views Member

## SQL interview Question | Second Highest Salary – Ranking

Question
Write a SQL query to get second highest query using Ranking
in progress 0
4 months 23 Answers 478 views Master

## How would you explain the concept of p-value to a layman ?

Question
In simple terms
solved 2
4 months 22 Answers 739 views Master

## Can you use HAVING command without any aggregate function in SQL?

Question
A bit tricky, do give a try
solved 1
4 months 22 Answers 484 views Member

## What is the difference between xrange and range in Python?

Question
in progress 0
4 months 22 Answers 503 views Contributor

## Suppose you have 10 samples, where 8 are positive and 2 are negative, how to calculate Entropy (important to know)

Question
A bit mathematical
in progress 1
4 months 21 Answers 433 views Master

## What is the difference between forecasting and prediction?

Question
Both of these terms look similar
in progress 1
4 months 21 Answers 532 views Master

## How much is the annual income of a beggar in Bangalore?

Question
Guesstimate
solved 4
4 months 21 Answers 1335 views Master

## Ranking in SQL

Question
We have the following values 10000 10000 20000 30000 30000 30000 What would be the result of row number, rank, and dense rank ?
solved 1
4 months 21 Answers 421 views Member

## Find all the students who either are male or live in Mumbai ( have Mumbai as a part of their address).

Question
Write Query
in progress 0
4 months 18 Answers 316 views Master

## Extract all the distinct email id domain from all the employee

Question
Suppose there are two columns in employee table i.e. emp id and email get all the unique domains  like gmail.com, yahoo.com, outlook.com, etc.
solved 3
4 months 17 Answers 421 views Master

## Can you join two table without any common column?

Question
Join interview question
in progress 2
4 months 17 Answers 384 views Master

## SQL output question | The Moonfrog Lab interview question

Question
SELECT ‘NITIN’+1 SELECT ‘NITIN’+’1’ SELECT(SELECT ‘NITIN’) SELECT ‘1’+1 SELECT 1+’1’
solved 2
4 months 17 Answers 509 views Master

## SQL Interview Questions | Alternate Rows

Question
You have data of people having applied for a lottery ticket. The data consists of their name and ticket number. You have to choose winners by selecting the people present in the alternate rows (first winner starting from row number ...
in progress 1
3 months 16 Answers 882 views Great Grand Master

## Explain Missing Value Treatment by mean,mode, median, and KNN Imputation

Question
What is missing value treatment
in progress 1
4 months 16 Answers 408 views Master

## SQL Query Output | EXL interview question

Question
select case when null=null then ‘Amit’ else ‘Rahul’ end from dual
in progress 1
4 months 14 Answers 288 views Master

## What is the difference between COUNT(*) and COUNT(ColName)?

Question
Explain with any example code
solved 0
4 months 14 Answers 305 views Master

## Explain type 1 error in simplest terms

Question
confusion matrix
solved 0
4 months 14 Answers 302 views Master

## SQL Interview Questions | Common Data

Question
Write a query for collecting the names of children who pursuing their graduation in their residential city. NAME AGE ADDRESS COLLEGE ……. …… ….. ….. (Hint- Look for the common city name in the columns of ADDRESS and COLLEGE) Example Nitin 26 Patna Patna Ankit 27 Bangalore Pune Result - Nitin
in progress 2
3 months 13 Answers 1061 views Great Grand Master

## Help me create a table with all the employee Names and Manager Names. SQL OYO interview Questions

Question
Employee_Name Employee_Id Manager_Id A                                1                           2 B              ...
in progress 2
4 months 13 Answers 317 views Master

## What do you mean when I say “The model has high accuracy in Training dataset but low in testing dataset

Question
Can you give an example?
solved 0
4 months 13 Answers 236 views Master

## Explain type 2 error in simple terms

Question
Confusion matrix
in progress 0
4 months 13 Answers 210 views Master

## Define Loss function in the simplest way possible

Question
Where is it used ?
in progress 0
4 months 12 Answers 242 views Master

## What is indexing in SQL? Meredith India interview question

Question
Explain with proper example
in progress 1
4 months 12 Answers 300 views Master

## Define R squared error in simple terms

Question
Try not to use a lot of mathematics
in progress 0
4 months 12 Answers 310 views Master

## What are the metrics to measure the performance of your Linear Regression model? Most asked question

Question
Almost all the interviewer asks this question
solved 0
4 months 12 Answers 447 views Master

## Lowe’s Interview Questions | Query I

Question
Name Designation Joining_Date Salary Ashutosh Singla HR 2019-12-15 80,000 Chandan Garg Admin 2019-10-09 60,000 Himanshi Kaur HR 2019-03-13 75,000 Mohit Dharm HR 2019-05-27 85,000 Meena Batra Accountant 2019-07-11 50,000 Omkar Singh Accountant 2019-01-05 45,000 Pratham Garg Admin 2019-05-27 65,000 Rakesh Sharma HR 2018-06-30 75,000 Sharadha Gupta Accountant 2019-09-18 50,000 Demonstrate how to write a query to show details of an HR whose name starts with M.
in progress 0
3 months 12 Answers 389 views Great Grand Master

## How do you measure distribution?

Question
Explain or give name of the methods used to measure distribution
in progress 0
4 months 11 Answers 249 views Master

## What is the need to remove multicolinearity ?

Question
What would happen if we don’t remove it?
solved 0
4 months 11 Answers 288 views Master

## What is worse, type 1 error or type 2 error?

Question
Errors in machine learning
in progress 0
4 months 11 Answers 294 views Master

## Which test to use when you have less than 30 sampling units? Amazon online interview question

Question
Explain the reason
solved 0
4 months 10 Answers 251 views Master

## Define ROC in layman terms

Question
Also explain where is it used
in progress 0
4 months 10 Answers 266 views Master

## What is the use of FETCH command? OLA interview question

Question
With code snippet
in progress 1
4 months 10 Answers 279 views Master

## What is the best fit line in Linear Regression?

Question
Explain best fit line to define the problem
solved 0
4 months 10 Answers 264 views Master

## Get the number of duplicate names and their frequency

Question
Table - Employee Name Nitin Amit Gaurav Nitin Amit Output Nitin - 2 Amit - 2 Gaurav - 1
in progress 0
4 months 10 Answers 226 views Master

## Flipkart Case Study | Restaurant optimization

Question
Punjabi By Nature is going through a rough phase and is wasting 30-40 Kgs of biryani on some days of the week. Management is thinking to find a method to sell the left over biryani or reduce the amount of biryani ...
solved 0
4 months 10 Answers 375 views Member

## split() and join() function in Python

Question
Explain split() and join() functions in Python?
in progress 1
4 months 9 Answers 288 views Contributor

## Get alternate record from table

Question
How to fetch alternate records(even rows) from a table?
in progress 0
4 months 9 Answers 227 views Master

## Difference in formula between sample and population variance?

Question
Explain the difference with example
solved 1
4 months 9 Answers 268 views Master

## You always have a big data i.e. millions of rows in your tables, how would you partition it for optimum performance?

Question
Give a couple of partitioning examples
in progress 1
4 months 9 Answers 323 views Master

## Lowe’s Interview Questions | Over-weight

Question
Suppose in class, you have 3n boys and 2n girls with their names tabulated along with their weight and gender. Write a SQL query to separate students alphabetically who are over-weight (55kg for girls, 75kg for boys)
in progress 0
3 months 9 Answers 265 views Great Grand Master

## Affine Analytics Interview Question | How does TVF makes money ?

Question
TVF recently went to app/website only mode. How do you think it makes money to survive and pay the actors ?
in progress 0
4 months 8 Answers 421 views Member