Register Now

By registering, you agree to the terms of service and Privacy Policy.

Login

Forget

Lost Password

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

x

Login

Forget

Register Now

It will take less than 1 minute to register for lifetime. Bonus Tip - We don't send OTP to your email id Make Sure to use your own email id for free books and giveaways

Create an account
x
  • Contact
  • Support
  • Login
Ask a Question
0
  • Home
  • Python
  • SQL
  • Case Study
  • Machine Learning
  • Add Question
  • Youtube Channel
  • About Us
    • Pricing
    • Contact Us
    • Terms and Conditions
    • Cancellation/Refund Policy
    • PRIVACY POLICY
  • Shop Now

Login

Forget

Register Now

It will take less than 1 minute to register for lifetime. Bonus Tip - We don't send OTP to your email id Make Sure to use your own email id for free books and giveaways

Create an account
  • Contact
  • Support
  • Login
0

The Data Monk

  • Home
  • Python
  • SQL
  • Case Study
  • Machine Learning
  • Add Question
  • Youtube Channel
  • About Us
    • Pricing
    • Contact Us
    • Terms and Conditions
    • Cancellation/Refund Policy
    • PRIVACY POLICY
  • Shop Now

Welcome to The Data Monk

The Data Monk is created to give you most of the “must-have” resources to make you believe that Analytics is easy and FUN. We have more than 30 ebooks on Amazon :)

About Us Join Now

Buy EBook on TheDataMonk
Subscribe us on YouTube

Top Categories

Data Analyst
Data Scientist
Business Analyst
Business Intelligence Engineer
Data Engineer
Analytics Manager
Service Based Companies
Product Based Companies
Python
Statistics
SQL
Career Guide, Job, Salary
Case Study
Machine Learning
Most Asked Concepts
TDM Books & Products
  • Recent Posts
  • Recent Questions
  • Most Responses
  • Recently Answered
  • No answers
  1. SQL interview Question | Second Highest Salary – Ranking

    Prerana
    Prerana
    0
    January 21, 2023 at 11:03 am
    SELECT EMP_ID, NAME, SALARY FROM (SELECT SALARY, EMP_ID,NAME
  2. Find all the students who either are male or live in Mumbai ( have Mumbai as a part of their address).

    Prerana
    Prerana
    0
    January 17, 2023 at 4:27 pm
    SELECT STUDENT_NAME FROM STUDENT_TB WHERE UPPER(GENDER) IN(‘
  3. Find all the students who either are male or live in Mumbai ( have Mumbai as a part of their address).

    Prerana
    Prerana
    0
    January 17, 2023 at 4:27 pm
    SELECT STUDENT_NAME FROM STUDENT_TB WHERE UPPER(GENDER) IN('
  4. How to write a query to get cumulative spending?

    judged
    judged
    0
    September 30, 2022 at 2:43 pm
    Ꮋello i am kavin, its my first time to commenting anyplace,
  5. JP Morgan Interview Questions | Payout

    saurabh
    saurabh
    0
    August 1, 2022 at 5:10 am
    E[x]=1/9(10+E[x]) -5*8/9 => E[x] = -15/4
  6. Give the output of the following function | Amazon Interview Question

    s.narayan.aashish
    s.narayan.aashish
    0
    March 31, 2022 at 7:28 am
    27 + 3a answere will depend on value of a passed as paramete
  7. D Cube Analytics Interview Question | Duplicate Rows

    Prerana
    Prerana
    0
    March 22, 2022 at 9:56 am
    By using distinct() window function on column that has uniqu
  8. Find the 4th Highest employee salary from the following table

    Prerana
    Prerana
    0
    March 22, 2022 at 9:47 am
    SELECT salary FROM (SELECT *, DENSE_RANK() OVER (ORDER BY SA
  9. Tiger Analytics Interview Question | Duplicate Entries

    Prerana
    Prerana
    0
    March 22, 2022 at 9:43 am
    You can using DISTINCT(), this will return only the unique v
  10. Cisco Interview Question | Query I

    Prerana
    Prerana
    0
    March 10, 2022 at 2:01 pm
    CREATE table emp_new as ( SELECT emp_id,joining_date, salary
  11. SAP interview Questions | Grouping Users

    Prerana
    Prerana
    0
    March 10, 2022 at 1:38 pm
    We can use this data for Customer Segmentation 1. Based on t
  12. Q1 | Guess the question

    kethireddimohit3643
    kethireddimohit3643
    0
    March 7, 2022 at 8:32 am
    Write a query to return the id and player for the Germany te
  13. Q1 | Guess the question

    kethireddimohit3643
    kethireddimohit3643
    0
    March 7, 2022 at 6:19 am
    Write a query to return the id and player for the Germany te
  14. SQL Interview Questions | Alternate Rows

    kethireddimohit3643
    kethireddimohit3643
    0
    March 6, 2022 at 6:06 am
    SELECT * FROM ( SELECT *, Row _Number() OVER(ORDER BY ticket
  15. pattern printing

    s.narayan.aashish
    s.narayan.aashish
    0
    March 5, 2022 at 11:07 am
    for i in range(25,51): s=0 for j in range(2,i): if i%j==0: s
  16. return string length

    s.narayan.aashish
    s.narayan.aashish
    0
    March 2, 2022 at 6:51 am
    s=["Spain"," Mykonos", "Nice", "New York "] list(map(lambda
  17. upper case tuple without loop

    s.narayan.aashish
    s.narayan.aashish
    1
    March 2, 2022 at 6:47 am
    s=["mi", "kkr", ""rcb", "pbks", "dd"] print(list(map(lambda
  18. SQL Interview Questions | Employee Details

    s.narayan.aashish
    s.narayan.aashish
    0
    February 26, 2022 at 4:34 pm
    Is this in SQL server> soesnt seem to work in mySQL
  19. SQL Interview Questions | Alternative of TOP Clause

    Prerana
    Prerana
    0
    February 24, 2022 at 5:27 am
    We can use ORDER BY followed by LIMIT IF YOU WANT TOP N USE
  20. SQL Interview Questions | Nth Highest Salary

    Prerana
    Prerana
    0
    February 23, 2022 at 3:28 pm
    THIS WILL GIVE DUPLICATE VALUES TOO SELECT * FROM (SELECT *,
  21. SQL Interview Questions | Solving Database Problem

    Prerana
    Prerana
    0
    February 23, 2022 at 2:35 pm
    It could be normalization problem , We can try looking for h
  22. Barclays Interview Questions | R Square

    Prerana
    Prerana
    0
    February 22, 2022 at 12:58 pm
    R^2 tends to increase every time we add more variables, it c
  23. Walmart Labs Interview Question | Lottery Ticket

    Prerana
    Prerana
    0
    February 21, 2022 at 4:33 pm
    SELECT name FROM (SELECT rownum as RN , name FROM tablename)
  24. Walmart Labs Interview Question | Predictors

    Prerana
    Prerana
    0
    February 21, 2022 at 4:24 pm
    The equation for logit is (1/1+e^-Z)value where Z=a+B1*x1+B2
  25. EXL Interview Questions| Salary

    s.narayan.aashish
    s.narayan.aashish
    1
    February 19, 2022 at 3:08 pm
    with a as ( select *,rank() over (order by salary) as rs, ra
  26. EXL Interview Questions| Salary

    s.narayan.aashish
    s.narayan.aashish
    0
    February 19, 2022 at 3:06 pm
    with a as ( select *,rank() over (order by salary) as rs, ra
  27. Lowe’s Interview Questions | Over-weight

    Prerana
    Prerana
    0
    February 18, 2022 at 5:30 am
    SELECT * FROM table_name WHERE (lower(gender)='female' and C
  28. Lowe’s Interview Questions | Over-weight

    Prerana
    Prerana
    0
    February 18, 2022 at 5:29 am
    SELECT * FROM table WHERE (lower(gender)='female' and Cast (
  29. SQL Interview Questions | Common Data

    Prerana
    Prerana
    0
    February 18, 2022 at 4:48 am
    SELECT c.name FROM table1 as c, table2as a where c.address=a
  30. BCG Interview Question | AB Test

    Prerana
    Prerana
    0
    February 16, 2022 at 1:37 pm
    At an initial level we must have set ALPHA FOR THE TEST IF p
  31. American Express Interview Question | Fair Coin

    Prerana
    Prerana
    0
    February 14, 2022 at 4:27 pm
    We use Hypothesis testing to solve this problem: HO: coin is
  32. American Express Interview Question | Overfitting

    Prerana
    Prerana
    0
    February 14, 2022 at 4:03 pm
    If the performance of test test is very low compared to trai
  33. American Express Interview Question | Casino

    sahuprerana301
    sahuprerana301
    0
    February 14, 2022 at 3:48 pm
    The probability that we will have 1 in 1st roll=1/6 -------
  34. American Express Interview Question | GDM

    sahuprerana301
    sahuprerana301
    0
    February 14, 2022 at 3:37 pm
    NO, it depends on how we initialize it. if the alpha is too
  35. Moonfrog Interview Questions | Queries

    s.narayan.aashish
    s.narayan.aashish
    0
    February 13, 2022 at 3:07 pm
    For 3rd and 4th I think we need metrics at item level 3)sele
  36. Statistics Basics 3 | Interview Question

    Pratik Hagawane
    Pratik Hagawane Newbie
    0
    February 12, 2022 at 5:14 pm
    As per Bell curve, empirical rule says, 68% of data lie in μ
  37. Adobe Interview Question | Customers

    rahulbeakta93
    rahulbeakta93
    0
    January 5, 2022 at 1:56 pm
    In Oracle:- SELECT cust_id,total_spend FROM (SELECT cust_id,
  38. Adobe Interview Question | Customers

    rahulbeakta93
    rahulbeakta93
    0
    January 5, 2022 at 1:55 pm
    In Oracle:- SELECT cust_id,total_spend FROM (SELECT cust_id,
  39. Amazon Interview Questions | Mutable data type in Python

    sharma7797kajal
    sharma7797kajal Newbie
    0
    October 31, 2021 at 3:08 pm
    List, dictionary and set
  40. Amazon Interview Question | How to sort a dictionary by key?

    sharma7797kajal
    sharma7797kajal Newbie
    0
    October 31, 2021 at 2:05 pm
    dict_1 = { "name": "Kajal", "age": 27} sorted(dict_1)
  41. Machine Learning

    Priyabrata
    Priyabrata Master
    0
    October 31, 2021 at 12:47 pm
    Backpropagation is a technique to find the weights of the mo
  42. Myntra Interview Question | Simple Loop problem

    sharma7797kajal
    sharma7797kajal Newbie
    0
    October 30, 2021 at 4:05 pm
    i = 0 while i<50: i = i + 1 if i in (5,10,15): continue p
  43. Sort a List

    sharma7797kajal
    sharma7797kajal Newbie
    1
    October 30, 2021 at 3:00 pm
    D = [2,5,1,7,8] D.sort()
  44. Python|Excluding columns|Jupyter Notebook

    sharma7797kajal
    sharma7797kajal Newbie
    0
    October 30, 2021 at 2:46 pm
    import pandas as pd df = pd.read_csv("nr_bankloans.csv") df.
  45. making lists

    sharma7797kajal
    sharma7797kajal Newbie
    0
    October 30, 2021 at 2:39 pm
    data = [ "Andromeda – Shrub", "Bellflower – Flower", "China
  46. USING LOOPS IN PYTHON

    sharma7797kajal
    sharma7797kajal Newbie
    0
    October 30, 2021 at 2:22 pm
    for i in range(0,21): if i%3==0 or i%5==0 : continue print(i
  47. Does Python support switch or case statement in Python? Why?

    sharma7797kajal
    sharma7797kajal Newbie
    0
    October 30, 2021 at 2:10 pm
    Python does not support swith or case statement like other l
  48. How to create a tuple with a single element?

    sharma7797kajal
    sharma7797kajal Newbie
    0
    October 29, 2021 at 5:34 pm
    u = (7,)
  49. Finding element from tuple

    sharma7797kajal
    sharma7797kajal Newbie
    0
    October 29, 2021 at 5:32 pm
    my_tuple[2:6]
  50. Deletion from dictionary

    sharma7797kajal
    sharma7797kajal Newbie
    0
    October 29, 2021 at 5:18 pm
    del Cars["Honda"]
1 2 3 … 55
Subscribe us on YouTube
  • Questions ( 1759 )
  • Answers ( 2706 )
  • Best Answers ( 92 )
  • Users ( 7602 )

Highest points

  • Shloka Reddy Lakka
    Shloka Reddy Lakka
    Great Grand Master 6781 Points
  • Dhruv2301
    Dhruv2301
    Great Grand Master 4885 Points
  • TheDataMonk
    TheDataMonk
    Grand Master 2842 Points
  • swap007
    swap007
    Grand Master 2643 Points
  • Ognish
    Ognish
    Master 1458 Points
  • Priyabrata
    Priyabrata
    Master 1432 Points
  • YashikaKhurana
    YashikaKhurana
    Master 1066 Points
  • Sai
    Sai
    Master 1054 Points
  • Shubham Bhatt
    Shubham Bhatt
    Contributor 824 Points
  • Smk
    Smk
    Contributor 660 Points
  • shankar
    shankar
    Contributor 607 Points
  • ravi_joe
    ravi_joe
    Contributor 583 Points
  • diksha.aggarwal0394
    diksha.aggarwal0394
    Contributor 554 Points
  • Pragya Rani
    Pragya Rani
    Contributor 542 Points
  • NaveenaParasa
    NaveenaParasa
    Contributor 524 Points
  • Ansh
    Ansh
    Contributor 524 Points
  • Harshit Goyal
    Harshit Goyal
    Contributor 447 Points
  • Xtramous
    Xtramous
    Contributor 415 Points
  • ninja89
    ninja89
    Contributor 400 Points
  • Pranshi_20
    Pranshi_20
    Member 356 Points
  • Shreya
    Shreya
    Member 313 Points
  • Yash Bagaria
    Yash Bagaria
    Member 278 Points
  • Avneet Singh
    Avneet Singh
    Member 251 Points
  • Puja
    Puja
    Member 245 Points
  • razack_ar
    razack_ar
    Member 244 Points
  • anmol
    anmol
    Member 233 Points
  • Ritesh Jain
    Ritesh Jain
    Member 220 Points
  • Sriparna
    Sriparna
    Member 217 Points
  • Ramya Mamidipaka
    Ramya Mamidipaka
    Member 215 Points
  • Pranavb13
    Pranavb13
    Member 205 Points
  • Himanshu Sharma
    Himanshu Sharma
    Member 205 Points
  • sakshi31
    sakshi31
    Member 179 Points
  • Shivam Singh
    Shivam Singh
    Member 173 Points
  • Medha
    Medha
    Member 168 Points
  • Manish Gautam
    Manish Gautam
    Member 157 Points
  • Suraj Pandita
    Suraj Pandita
    Member 151 Points
  • Satya Vardhan
    Satya Vardhan
    Member 149 Points
  • Kratika
    Kratika
    Member 146 Points
  • tanya327
    tanya327
    Member 146 Points
  • Sudhanshu Singh
    Sudhanshu Singh
    Member 144 Points
  • sawansaxena
    sawansaxena
    Member 144 Points
  • Payal Chuhan
    Payal Chuhan
    Member 143 Points
  • shuv13111
    shuv13111
    Member 143 Points
  • vinod.k
    vinod.k
    Member 142 Points
  • shivani_1908
    shivani_1908
    Member 130 Points
  • Raahul
    Raahul
    Member 130 Points
  • Sree Harsha
    Sree Harsha
    Member 129 Points
  • juhi sharma
    juhi sharma
    Member 128 Points
  • Ritika Sohal
    Ritika Sohal
    Member 127 Points
  • Krati Khandelwal
    Krati Khandelwal
    Member 123 Points

SOCIAL COUNTER

  • 5,884
    Fans

Recent Posts

  • Data Analyst Internship – 2023 February 3, 2023
  • 10 Machine Learning Interview Questions 1/5 January 22, 2023
  • SQL Query Optimization Techniques January 19, 2023
  • 10 Frequently asked SQL Interview Questions – 5/5 January 12, 2023
  • 10 Tricky SQL interview Questions – 4/5 January 11, 2023
  • 10 Frequently asked SQL interview questions – 3/5 January 10, 2023
  • 10 SQL Important Interview Questions – 2/5 January 9, 2023
  • 10 Most asked SQL Interview Questions – 1/5 December 23, 2022
  • Apple Senior Data Analyst Interview Questions | Day 9 November 3, 2022
  • EXL Senior Consultant Interview Questions | Day 8 October 27, 2022

Recent Comments

  • Prerana on SQL interview Question | Second Highest Salary – Ranking
  • Prerana on Find all the students who either are male or live in Mumbai ( have Mumbai as a part of their address).
  • Prerana on Find all the students who either are male or live in Mumbai ( have Mumbai as a part of their address).

Archives

Copyright 2020 Ask me | By 2code
  • Login
  • Sign Up
Forgot Password?
Lost your password? Please enter your username or email address. You will receive a link to create a new password via email.