SQL Interview Problem Asked in IBM Company | Data Science Interview Questions

[@shabareeshpasupula5306]

Great Share

[@p_anjali_codes]

This question is on Hackerrank.

[@CloudyML]

yes, companies ask from these platforms.

[@p_anjali_codes]

@@CloudyML Thank you for explaining the entire query. It is very helpful.

[@mezomezo8718]

I sent understand the part of the joining condition

[@CloudyML]

Hi, I did not get your point . Can you tell me more ?

[@mezomezo8718]

@@CloudyML I k ow when we do the joing in condition we have to use similar part but am confused when you put the where between clause

[@CloudyML]

@@mezomezo8718 where is used when you need to use a certain condition and it restricts the result and between is to use for a given range. Check sample examples on this on google.

[@kunalkumar-hl6gv]

this is hacker rank question

[@CloudyML]

Yes, it can be. Companies ask from such platform too.

[@avinash7003]

This query is not not working in Oracle

[@CloudyML]

Yeah this is for MySQL. You might need to change your query a bit to make it work.

[@intradaytrend8422]

please share dataset also so own our system

[@nikhilbarjatia]

You can create your own table bro

[@CloudyML]

Please type the insert query as from video to create table as it will help you in learning.

[@RitikKumar-hu4by]

POINT

[@CloudyML]

The INSTR function searches the string for substring and returns the numeric value of the specified character's first occurrence. So the answer should be 6.

[@manojpatilm943]

Point

[@CloudyML]

The INSTR function searches the string for substring and returns the numeric value of the specified character's first occurrence. So the answer should be 6.