SQL

SQL interview questions - Day 2 of the quiz will have most of the questions from SQL Bread and Butter of a Data Scientist/Analyst

SQL is the bread and butter of an analyst. You can't survive in the Data Science industry with a grip on this 'easy-looking' query language. I have been interviewed for more than 30 companies in the past 3-4 ...

We have already covered queries on joins, aggregate functions, sub-queries, running sum, etc.This article will concentrate on the theoretical part of SQL which are less asked but are important to know about1.What are the different types of statements ...

Advance concepts mostly involves knowledge of window functions, cleaning the data format, working with different date formats, etc. Before proceeding, you should actually go through different ways of casting data types and other widows functions.1.Create the cumulative revenue ...

Let's get started with some intermediate level SQL queries. Try to frame an approach before hoping to the solution because once you see the answer you will find it easy to understand.I think there will be around 15 ...

I hope you have already read the introduction part where we discussed about the execution flow of all the clauses in SQL.Today we will discuss around 15 questions which shall give you a good launching pad to ...