SQL - The Data Monk

Register Now

Lost Password

Lost your password? Please enter your email address. You will receive a link and will create a new password via email.

Category : SQL

SQL related questions

Finding overlap between different customers || EBay Question

Question

Q1: An overlap means that the date range of customer overlaps (partial or complete overlap) with the date range of all the other customers. Write a query to reach the required output Table Name: Subscription USER ID START DT END DT

SQL 55 years 0 Answers 618 views Newbie

Count month wise active pros

Question

(Active Pros are Providers with atleast one delivery)

SQL Anonymous 55 years 0 Answers 788 views

How to write a query to get cumulative spending?

Question

Assume you are given a table for spending activity by product type which has column names as order_id, user_id, product_id, spend, date . How to write a query to calculate the cumulative spend for each product over time in chronological ...

in progress 1

SQL Anonymous 55 years 2 Answers 1090 views

What is LATERAL VIEW EXPLODE in SQL?

Question

Explain with example

SQL 55 years 0 Answers 929 views Grand Master

What is CROSS JOIN UNNEST?

Question

Define in a simple language and code

SQL 55 years 0 Answers 637 views Grand Master

Sorry it's a private question.

Find number of rows in output

Question

Table A ColX 1 1 Table B ColY 1 1 1 1 1 What will be the count of rows when: (for Table A and Table B) left join right join inner join cross join full outer join

in progress 0

SQL 55 years 0 Answers 991 views Newbie

How do you check if a table is in 2NF form or not?

Question

Specify the checks with example

in progress 0

SQL 55 years 1 Answer 1381 views Grand Master

How do you get the fifth highest salary using self join?

Question

5th highest salary

in progress 1

SQL 55 years 3 Answers 2071 views Grand Master

Define RDBMS and give example, also define the difference between Data Ware house and Database

Question

These types of subjective questions are generally asked to understand your database knowledge at an uber level. Try to give real life example

in progress 0

SQL 55 years 2 Answers 856 views Grand Master

1 2 3 … 20

Products

1 Month Analytics Mentorship Program Original price was: ₹11500.Current price is: ₹9999.
The Data Monk 23 e-book bundle Original price was: ₹6900.Current price is: ₹1999.
2200 Most Asked Analytics Interview Questions Original price was: ₹7999.Current price is: ₹1999.
10 Books to crack Analytics interview Original price was: ₹2999.Current price is: ₹999.
Machine Learning 1200 Interview Questions Original price was: ₹3600.Current price is: ₹999.
30 Days Analytics Course Original price was: ₹1999.Current price is: ₹999.
1250+ Business Analyst Most Interview Questions Original price was: ₹1299.Current price is: ₹899.
Crack Any Data Analyst Interview with 1100 Questions Original price was: ₹1999.Current price is: ₹799.
550 SQL Interview Questions to crack Any Analytics interview Original price was: ₹999.Current price is: ₹499.
Crack your next Data Science interview with 300+ Questions Original price was: ₹499.Current price is: ₹299.