Скачать или смотреть Access Banned Accounts | Advanced SQL Interview Questions | Data Engineer Interview Question | FAANG

Video 357: This is the 35th video of the SQL Interview Question series.

00:00 - Introduction to dataset and Question
04:20 - Code walk thru
07:50 - Conclusion

We are given LogInfo table which stores the user accounts and the login / logoff time from different IP address

We are asked to find the accounts that should be banned from a platform. An account should be banned if it was logged in at same moment from two different IP addresses.

In this video, we explore a SQL solution to identify accounts on a plstform that should be banned due to suspicious login activity from multiple IP addresses simultaneously.

Account and IP Address Matching: This solution involves self-joining the LogInfo table to detect instances where an account is logged in from two different IP addresses at the same time. By comparing login and logout times, we can identify overlapping sessions that suggest unauthorized or suspicious access.

For a comprehensive understanding of these SQL methodologies and their application, please refer to this explanatory video.

code: https://github.com/jeganpillai/adv_sq...

Follow me on,
Website : https://growwithdata.co/
YouTube :    / @growwithdata  
TikTok :   / growwithdata  
LinkedIn :   / growwithdata  
Facebook :   / growwithdata.co  
FB Group : facebook.com/groups/datainterviewpreparation
twitter :   / growwithdata_co  
Instagram :   / growwithdata.co  
WhatsApp : https://whatsapp.com/channel/0029VaF8...
TheWide : https://thewide.com/profile/891

#sql #dataengineers #tablejoins #ceil #floor #bucket #meta #google #facebook #apple #paypal #netflix #amazon #deinterview #sqlinterview #interviewquestions #leetcode #faang #maanga #mysql #oracle #dbms #query #sqlserver #mysql #coderpad #aggregates #aggregation #nonaggregation #database #placementpreparation #lead #lag #windowsfunction #nullcheck #coalesce #sqlperformance #ifnull #case #lead #lag #windowsfunction #tamil #tamilpython #tamilinterview #tamilinterviewlatest #tamilinterviewquestions #sqlintamil