ishwar kokkiliishwarkoki.hashnode.dev·Nov 19, 2023SQL Problem of the day #6Problem statement: Find the maximum number of items that customers can purchase within their budget. Table creation and data insertion scripts: --Table : Product CREATE TABLE product( id int, name varchar(30), cost decimal(10,2) ); INSERT INTO p...DiscussSQL Server
ishwar kokkiliishwarkoki.hashnode.dev·Nov 18, 2023SQL Problem of the day #5Problem statement: Find the candidates who are eligible for interviews Eligibility criteria : has not given 2 or more interviews should not have given an interview in the last 180 days You are trying to filter the data as on Date: '2023-08-21' ta...Discuss·8 likesData Science
ishwar kokkiliishwarkoki.hashnode.dev·Nov 17, 2023SQL Problem of the day #3Problem statement: Find the Topper of Each Class (Student who scored rank 1) Table creation and data insertion script: CREATE TABLE student( enroll_no int PRIMARY KEY IDENTITY(1,1), name varchar(100), class varchar(100), total_marks int ); INS...Discusssoftware development
ishwar kokkiliishwarkoki.hashnode.dev·Nov 16, 2023SQL Problem of the day #2Problem Statement: Find the total duration each device was turned on. Table creation and data insertion script: CREATE TABLE electric_items( id int, type varchar(20), status varchar(20), time_res int ); INSERT INTO electric_items VALUES(1,'light','o...Discuss·1 likeSQL
ishwar kokkiliishwarkoki.hashnode.dev·Nov 15, 2023SQL Problem of the day #1Problem statement: Find the location where the users were last spotted on each day. Table creation and data insertion script: CREATE TABLE visit_log( user_id int, user_name varchar(20), user_visit_location varchar(20), user_visit_time datetime DEFAUL...DiscussSQL
Deepak SinghforDeepak Singhdeepaksingh1301.hashnode.dev·Oct 7, 2023React Meta Interview Question- Transfer ListTransfer lists are an essential component in many web applications, providing users with a user-friendly way to move items between two lists. Whether you're building a to-do list manager, an e-commerce platform, or any application that requires item ...DiscussReact
Soumya Ranjan Dassmy637.hashnode.dev·Sep 3, 2023Two pointers technique simplifiedWhile solving DSA problems time complexity plays an important role. The interviewer always wants for better optimal approach. Two pointers technique is mostly used for solving DSA problems with better optimized time complexity. As the name suggests ...Discuss·4 likesDSA
DevDoc'sdevdoc.hashnode.dev·Aug 30, 2023"Mastering DSA 💻: Your Ultimate Roadmap to Becoming a Coding Wizard🚀""From Novice to Expert: A Step-by-Step Guide to Conquer Data Structures and Algorithms for Internships, Placements, and Beyond🎉" Welcome to the thrilling world of Data Structures and Algorithms (DSA), where coding becomes an art of problem-solving! ...Discuss·8 likesInternship & PlacementDSA
Shashank Kulkarnifullfillcrab.hashnode.dev·Aug 23, 2023"Cracking the Code of Maximum Subarray Sum: Kadane's Algorithm"Introduction Picture yourself in a tech interview, where your coding abilities are under a magnifying glass. One puzzle that frequently appears is the "Maximum Subarray Sum." Don't let the name intimidate you – it's a challenge that's important for i...Discuss·20 likes·26 readsalgorithms
Onyewuchi Emeka Manuelemekamanuel.hashnode.dev·Aug 20, 2023Leetcode 1: Two sumIntroduction Hello there fellow developers, CS majors and curious minds interested in learning data structures and algorithms. This blog article is specially written to help you solve the Leetcode problem: Two Sum, using a well-curated beginner-frien...Akisanya Bolaji and 9 others are discussing this10 people are discussing thisDiscuss·61 likes·322 readsData StructuresleetcodeVery insightful article, as one who wants to really understand data structures, I'll keep an eye on this page for more articles, I recommend for anyone else in the comments too 13