SQL Interview Questions – Data Science Quiz – Day 2

SQL interview questions – Day 2 of the quiz will have most of the questions from SQL

SQL is one of the most useful language for a Data Scientists. These SQL interview questions will help you in understanding the types of questions asked in a Data Science interviews. All the Data Science/Analyst/Business Analyst recruitment has at least one round on SQL interview question where candidates are asked about tricky interview

The questions for Day 1 can be found here –

Day 2 will be mostly about SQL coupled with one or two cases studies.
We will not be providing solution to these questions but will be evaluating the submitted solutions 🙂

A good answer will get a thumbs up with 10 point
Best answer will receive 17 points.

Following are the list of questions :-

Order of execution of SQL query – https://thedatamonk.com/question/what-is-the-order-of-execution-of-sql-commands/
Add two columns with null values in SQL – https://thedatamonk.com/question/sql-interview-question-write-the-query/
Get second highest salary with sub query – https://thedatamonk.com/question/sql-interview-question-second-highest-salary-method-1/
Get second highest salary using rank – https://thedatamonk.com/question/sql-interview-question-second-highest-salary-ranking/
HAVING in SQL – https://thedatamonk.com/question/can-you-use-having-command-without-any-aggregate-function-in-sql/
Ranking in SQL- https://thedatamonk.com/question/ranking-in-sql/
Regular Expression in SQL – https://thedatamonk.com/question/write-a-sql-query-to-find-all-the-student-names-nitin-in-a-table/
Regular Expression in SQL 2 – https://thedatamonk.com/question/sql-interview-question/

The next two questions are case studies:-
We would really like you to go through these case studies. You will get to know how random things/case study can be 😛

In one of my interviews I was asked which mobile game do I play and then we had a half an hour discussion on Clash of Clans.

So, check out diverse topics and most importantly form an opinion of your own. We will evaluate and give feedback on each of the following case studies

TVF Case Study (Affine Analytics) – https://thedatamonk.com/question/affine-analytics-interview-question-how-does-tvf-makes-money/

Punjabi By Nature Case Study(Flipkart) – https://thedatamonk.com/question/flipkart-case-study-restaurant-optimization/

Do participate, answer and check out answers of other participants.

The Data Monk Interview Books – Don’t Miss

Now we are also available on our website where you can directly download the PDF of the topic you are interested in. At Amazon, each book costs ~299, on our website we have put it at a 60-80% discount. There are ~4000 solved interview questions prepared for you.

10 e-book bundle with 1400 interview questions spread across SQL, Python, Statistics, Case Studies, and Machine Learning Algorithms – Ideal for 0-3 years experienced candidates

23 E-book with ~2000 interview questions spread across AWS, SQL, Python, 10+ ML algorithms, MS Excel, and Case Studies – Complete Package for someone between 0 to 8 years of experience (The above 10 e-book bundle has a completely different set of e-books)

12 E-books for 12 Machine Learning algorithms with 1000+ interview questions – For those candidates who want to include any Machine Learning Algorithm in their resume and to learn/revise the important concepts. These 12 e-books are a part of the 23 e-book package

Individual 50+ e-books on separate topics

Important Resources to crack interviews (Mostly Free)

There are a few things which might be very useful for your preparation

The Data Monk Youtube channel – Here you will get only those videos that are asked in interviews for Data Analysts, Data Scientists, Machine Learning Engineers, Business Intelligence Engineers, Analytics managers, etc.
Go through the watchlist which makes you uncomfortable:-

All the list of 200 videos
Complete Python Playlist for Data Science
Company-wise Data Science Interview Questions – Must Watch
All important Machine Learning Algorithm with code in Python
Complete Python Numpy Playlist
Complete Python Pandas Playlist
SQL Complete Playlist
Case Study and Guesstimates Complete Playlist
Complete Playlist of Statistics