Interesting Complex Scenario | Oracle SQL Database Tricky Interview Questions
@trickyinterviewquestions
There are 4 friends living in an apartment and each day one friend is taking care of households. You should write a SQL query so that each day one friend is assigned to do the work. Remember, every time query is executed, it should assign the days on random basis.
Also, there should be a fair balance in assigning the days. Means every person should work for almost 7-8 days in a month only.
Watch video Interesting Complex Scenario | Oracle SQL Database Tricky Interview Questions online without registration, duration hours minute second in high quality. This video was added by user Oracle SQL and PLSQL Tricky Interview Questions 01 August 2021, don't forget to share it with your friends and acquaintances, it has been viewed on our site 932 once and liked it 28 people.