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
You can use WP menu builder to build menus
Ask a Question
0
  • Buy Your e-book
  • Contact Us
  • About Us
    • Pricing
    • Terms and Conditions
    • Cancellation/Refund Policy
    • PRIVACY POLICY

The Data Monk

  • Buy Your e-book
  • Contact Us
  • About Us
    • Pricing
    • Terms and Conditions
    • Cancellation/Refund Policy
    • PRIVACY POLICY

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

  • Recent Posts
  • Recent Questions
  • Most Responses
  • Recently Answered
  • No answers
  1. Find all the students who either are male or live in Mumbai ( have Mumbai as a part of their address).

    vignesh222022
    vignesh222022
    0
    June 15, 2023 at 5:50 am
    SELECT * FROM STUDENTS WHERE GENDER = 'M' OR LOWER(ADDRESS)
  2. Flipkart Case Study | Restaurant optimization

    vignesh222022
    vignesh222022
    0
    May 19, 2023 at 7:13 am
    My approach would be: I will check historical data to find o
  3. sum of nos

    ravi.rs.shekhawat
    ravi.rs.shekhawat
    0
    May 8, 2023 at 2:34 am
    sum=0 for i in range(1,13): sum+=i print(sum)
  4. Case Study | Zomato Interview Question

    chirag.dhingra3038
    chirag.dhingra3038
    0
    May 2, 2023 at 11:55 am
    ROI: Amidst of the opening it upon existing tourism places i
  5. Flipkart Interview Question | What are the basic checks you do for cleaning the data?

    Pratik221b
    Pratik221b Member
    0
    April 19, 2023 at 7:02 pm
    1) missing values per column 2) outliers 3) standardisation
  6. OLA interview Question | Data Cleaning

    Pratik221b
    Pratik221b Member
    0
    April 19, 2023 at 6:59 pm
    some parts of your answer come under data preprocessing not
  7. OLA interview Question | Data Cleaning

    Pratik221b
    Pratik221b Member
    0
    April 19, 2023 at 6:58 pm
    Importance of Data cleaning- ML models can understand data o
  8. What will be the output of Following SQL Query

    Vignesh Subramaniam
    Vignesh Subramaniam
    0
    April 15, 2023 at 6:30 pm
    It will return only those salaries which are greater than th
  9. SQL interview question | Write the query

    prince.gagan2016
    prince.gagan2016
    0
    April 15, 2023 at 6:17 pm
    this query is not working in postgresql
  10. SQL interview Question | Second Highest Salary – Method 1

    vignesh222022
    vignesh222022
    0
    April 13, 2023 at 4:48 pm
    SELECT MAX(SALARY) FROM TABLE WHERE SALARY < ( SELECT MAX
  11. SQL Interview Questions | Separate DOB Data of Employess

    Nitesh210
    Nitesh210 Newbie
    0
    April 13, 2023 at 6:33 am
    Select sex , count(1) as No_of_emp from employee where DOB B
  12. SQL interview question | Write the query

    Nitesh210
    Nitesh210 Newbie
    0
    April 11, 2023 at 12:47 pm
    select * ,( ifnull(revenue ,0) -ifnull(cost_price,0)) as Pro
  13. SQL interview Question | Second Highest Salary – Method 1

    Nitesh210
    Nitesh210 Newbie
    0
    April 10, 2023 at 8:49 pm
    select salary from table_name as t1 where 1 = (select count(
  14. SQL interview question | Write the query

    Nitesh210
    Nitesh210 Newbie
    0
    April 10, 2023 at 8:45 pm
    select (ifnull(revenue,0) - ifnull(cost_price ,0)) as Profit
  15. SQL output interview question

    Nitesh210
    Nitesh210 Newbie
    0
    April 10, 2023 at 8:39 pm
    - right join : 15 – left join : 15 – cross join: 15 – inner
  16. Write a SQL query to find all the student names Nitin in a table

    PAVANSAI TADEPALLI
    PAVANSAI TADEPALLI
    0
    April 5, 2023 at 8:13 am
    select name from student where lower(name) like ‘%nitin%’
  17. 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
  18. 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(‘
  19. 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('
  20. 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,
  21. 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
  22. 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
  23. 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
  24. 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
  25. 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
  26. 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
  27. 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
  28. 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
  29. 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
  30. SQL Interview Questions | Alternate Rows

    kethireddimohit3643
    kethireddimohit3643
    0
    March 6, 2022 at 6:06 am
    SELECT * FROM ( SELECT *, Row _Number() OVER(ORDER BY ticket
  31. 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
  32. 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
  33. 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
  34. 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
  35. 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
  36. 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 *,
  37. 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
  38. 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
  39. 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)
  40. 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
  41. 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
  42. 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
  43. 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
  44. 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 (
  45. 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
  46. 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
  47. 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
  48. 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
  49. 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 -------
  50. 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
1 2 3 … 55

Products

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

Stats

  • Questions ( 1784 )
  • Answers ( 2722 )
  • Best Answers ( 92 )
  • Users ( 24638 )
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.
body::-webkit-scrollbar { width: 7px; } body::-webkit-scrollbar-track { border-radius: 10px; background: #f0f0f0; } body::-webkit-scrollbar-thumb { border-radius: 50px; background: #dfdbdb }