Vishad Patelvishad.hashnode.dev·Jul 16, 2024Find Average SalaryProblem Statement: Write a query to find the average salary of the employees for each department. Save the new average salary as 'Average_salary'. Return the columns 'department_id', 'department_name', and 'Average_salary'. Return the result order...DiscussSQL Problems & Solution with Different ApproachSQL
Vishad Patelvishad.hashnode.dev·Jul 15, 2024Find Managers with 4+ Direct ReportsProblem Statement: Write a query to display the "full_name" of a manager who manages 4 or more employees. Note: Return the result ordered by full_name in ascending order. The column manager_id in the employees table represents the employee_id of th...DiscussSQL
Vishad Patelvishad.hashnode.dev·Jul 14, 2024Find employees who earn less than the average department salaryTechieBytes Solutions, a prominent technology firm specializing in software development and IT services, emphasizes innovation and fair employee compensation. As a data analyst at TechieBytes Solutions, you're tasked with identifying disparities in s...DiscussSQL Problems & Solution with Different Approachdatalemur sql
Vishad Patelvishad.hashnode.dev·Jul 14, 2024Find 3rd highest employee salaryProblem Statement Create an SQL query to retrieve all details of employees who receive the third-highest salary. Ensure the query returns all columns from the employees table. Additional Requirement: Do not use the LIMIT keyword in your query. Sample...DiscussSQL Problems & Solution with Different Approachdatalemur sql
Sindhu Intisindhuinti.hashnode.dev·Jul 7, 2024My Internship Experience at HackerRankI interned at HackerRank as an SDE this winter and being there I realized that this has been something very special and I will always hold onto this experience as a cherishable memory. Hence, I am writing this blog to take you all through my journey ...Discuss·46 readsinterview
aisha javedcyberurdu.hashnode.dev·Jun 25, 2024Kali Linux For BeginnerWhy do ethical hackers use Kali Linux? Is Kali Linux legal in Pakistan? If you want to know more about Kali Linux. This article is useful for you. اخلاقی ہیکرز کالی لینکس کیوں استعمال کرتے ہیں؟ کیا کالی لینکس پاکستان میں قانونی ہے؟ اگر آپ کالی لینکس ...DiscussKali Linux
Infraboyinfraboy.hashnode.dev·Jun 24, 2024Footprinting and ReconnaissanceA Comprehensive Guide to Footprinting in Cybersecurity Footprinting is a crucial initial phase in the field of cybersecurity, essential for both offensive and defensive strategies. This comprehensive overview will explore what footprinting is, why it...DiscussCertified Ethical Hacker ( CEH )CEH Exam Online
Bhuwan Sharmabhuwan.hashnode.dev·Jun 22, 2024Just solved all HackerRank Python challenges on Closures and Decorators!def wrapper(f): def fun(l): f(["+91 "+ c[-10:-5]+" " + c[-5:] for c in l]) return fun @wrapper def sort_phone(l): print(*sorted(l), sep='\n') if __name__ == '__main__': l = [input() for _ in range(int(input()))] sort_pho...Discussdecorators in python
Bhuwan Sharmabhuwan.hashnode.dev·Jun 21, 2024Just solved all Python challenges for Python Functionals on HackerRank!from fractions import Fraction from functools import reduce def product(fracs): t = (reduce(lambda x, y: x*y, fracs)) return t.numerator, t.denominator if __name__ == '__main__': fracs = [] for _ in range(int(input())): frac...DiscussPython Functionals
Bhuwan Sharmabhuwan.hashnode.dev·Jun 20, 2024Just solved all Python challenges for Built-ins on HackerRank!Just solved all Built-Ins challenges in Python on @HackerRank . Try it out! https://hr.gs/1vo8 #programming N = int(input()) integers = list(map(int, input().split())) print(all(x>0 for x in integers ) and any(str(x) == str(x)[::-1] for x in intege...Discussbuilt-ins