vishal aggarwal
- 3★v_i_sh_a_l
- India
- Other
- List of teams by vishal aggarwal
- https://discuss.codechef.com/u/v_i_sh_a_l
- No Active Plan. View Details
Activity Heat Map
NewRating Graph
Ratings System Update
(2024-05-01 22:00:02)Ratings System Update
(2022-12-20 00:00:00)CodeChef Rating Distribution
Submissions
Practice Problems (81):
Practice:
Enormous Input Test, The Lead Game, LCM Sum, Home Delivery, Packaging Cupcakes, Galactik Football, Number Mirror, Chef and Remissness, Lucky Four, Small Factorial, Minimum Maximum, Lazy Jem, Encoding Message, Chef and Semi-Primes, XOR Engine, That Is My Score!, Frog Sort, Bodybuilder, Cheating Time, Prime Tuples, Maximise Function, Even Differences, Even Sum, College Admissions, Total Score, Valid String, Total Correct Submissions, Matrix XOR, Chef and Dice, Racing, Chef On Island, The Last Problem, OR of ANDs, Sleep Cycle, Special Triplets, Tic Tac Toe, Modular Equation, From Rational to Binary, Bitwise Tuples, Chef and Subarrays, Chef vs Bharat, Binary String on Steroids, The Wave, Chef and Queries, Optimal Denomination, Tic Tac Toe, Chefs Homework Dilemma, Different String, Even tuples, Chef and Closure, Equal Difference, Ceiling Sum, Array Filling, Mod Equality, Three Points, Array Rotation Returns, Clear the Array, Odd GCD, Adjacency Hatred, MEX-OR, Odd Sum, Roller Coaster, Good Pairs, Black and White, Split AND Sum, The Lost Array, XOR Times 2 Is Sum, Xor and Multiply, Enough Space, Copy and Push Back, Maximum Median Matching, Largest Family, Accurate XOR, Confusing Concatenations, Water Mixing, Longest Subarray, GCD ON SUBARRAYS, Triangular Swaps, Updating A, MEX QUERIES , Prime Query
Contests (146):
March Lunchtime 2021 Division 3:
Turn It, Dinner by Candlelight, Motivation, Make the Sum Even, Lunchtime
August Challenge 2021 Division 2 (Unrated):
Chef and Bulb Invention, Problem Difficulties, Olympics Ranking
August Lunchtime 2021 Division 3:
K-th Maximum, Maximum Length Even Subarray, Programming Languages, Crossing Blocks
CodeChef Starters 9 Division 2 (Unrated):
Friend Groups In A Line, Black cells in a chessboard, Large Square, Bus full of passengers
CodeChef Starters 10 Division 3 (Rated):
Hardest Problem Bet, Odd Repeat, Maximise the Subsequence Sum, Remove One Element
September Challenge 2021 Division 2 (Unrated):
XOR Equal, Shuffling Parities, Airline Restrictions, Travel Pass
June Lunchtime 2022 Division 2 (Rated):
Zero Ones Equal One Zeros, The Lost Array, Max Shift After XOR, XOR Times 2 Is Sum, Equal by XORing
Learning Paths (183):
Learn SQL:
Introduction, Create table , Insert table , How to insert to a table, Debug this query, Alter table , update table, Practice Problem - Alter table, Practice Problem - Update table, Delete From, Constraints, Practice - Delete From, Debug this query, Project - Customer Database, Practice problem-1, Practice problem-2, Practice problem-3, Practice problem-4, Introduction to Queries, SELECT Query, DISTINCT, WHERE, BETWEEN, Practice problem, Debug this query, AND, OR, Like, Practice problem, Debug this query, Order by, LIMIT, NULL Values, Project - Food delivery, Project - Food delivery, Project - Food delivery, Project - Food delivery, Project - Food delivery, Project - Food delivery, Project - Food delivery, COUNT(), MAX() and MIN() , ROUND() , Problem - COUNT() MAX() and MIN() , Problem-ROUND(), Debug this query, SUM(), AVG(), Problem - SUM() and AVG() , Group By, Having, Problem-Group By & Having, Debug this code, Practice problem Introduction, Practice problem-1, Practice problem-2, Practice problem-3, Practice problem-4
SQL Intermediate:
Introduction - Combining tables manually, Combining tables with SQL, Combining tables with SQL, Inner Joins, Left Joins, Primary Key vs Foreign Key, Cross join, Union, WITH, Project- Supermarket, Practice problem-1, Practice problem-2, Practice problem-3, Practice problem-4, Practice problem-5, Practice problem-6, Data Transformation, Non-Correlated Subqueries, Problem - Non-Correlated Subqueries, Correlated Subqueries, Problem - Correlated Subqueries, Project - ABC ecommerce website, Practice Problem - 1, Practice Problem - 2, Practice Problem - 3, Union All, Intersect, Except, Project- XYZ Pvt Ltd, Practice Problem - 1, Practice Problem - 2, Practice Problem - 3, Conditional Aggregates Introduction, Null, Case - When, Count using Case, Sum using Case, Combining Aggregates, Project Cafe CodeChef , Practice Problem - 1, Practice Problem - 2, Practice Problem - 3, Practice Problem - 4
SQL at Work:
Different tools used in analytics at work, SQL, Manipulation - CREATE, Manipulation - INSERT, Manipulation - ALTER & UPDATE, Manipulation - CONSTRAINTS, Queries - SELECT, Queries - WHERE, Queries - WHERE, Aggregate functions, Intermediate SQL - Recap, Intermediate SQL - Recap, Primary Key vs Foreign Key, Cross join, Intermediate SQL - Recap, Intermediate SQL - Recap, Intermediate SQL - Recap, Intermediate SQL - Recap, Case study - Covid impact on ABC Retail, Case study - Covid impact on ABC Retail, Case study - Covid impact on ABC Retail, Case study - Covid impact on ABC Retail, Case study - Covid impact on ABC Retail, Case study - Covid impact on ABC Retail, Case study - Covid impact on ABC Retail, Intermediate SQL Project - ABC Retail, Intermediate SQL Project - ABC Retail, Intermediate SQL Project - ABC Retail, Intermediate SQL Project - ABC Retail, Intermediate SQL Project - ABC Retail, Intermediate SQL Project - ABC Retail, Case study - InstaPizza, Case study - InstaPizza, Case study - InstaPizza, Case study - InstaPizza, Case study - InstaPizza, Case study - InstaPizza, Case study - Logistics, Case study - Logistics, Case study - Logistics, Case study - Logistics, Case study - Logistics, Case study - Logistics, Case study - Product line research, Case study - Product line research, Case study - Product line research, Case study - Product line research, Case study - Product line research, Case study - Customer preference, Case study - Customer preference, Case study - Customer preference, Case study - Customer preference, Case study - Customer preference
Learn Advance Java:
Quiz, Quiz, Practice, Practice, Practice, Practice, Practice, Practice, Practice, Practice, Practice
UX for Web developers:
Good or Bad UX, Norman doors, User is the King, Flag usability issues, More on iterative cycles, Guess the team flow, Tracking patterns - II, Guess the pattern, What is usability, web UX, UX Process, Who is a UX designer, The Good Web developer, Guess the pattern, Spacing and Layout - The example, The ikea redesign, Ikea redesign again, How much Padding
Practice Paths (26):
SQL: Topic-wise practice:
Aggregates & Group By , Case Study - HappyHaven Home Rental App , Case Study - HappyHaven Home Rental App , Case Study - HappyHaven Home Rental App , Case Study - HappyHaven Home Rental App , Case Study - HappyHaven Home Rental App , Case Study - HappyHaven Home Rental App , Case Study - HappyHaven Home Rental App , Case Study - HappyHaven Home Rental App , Case Study - HappyHaven Home Rental App , Case Study - HappyHaven Home Rental App , Case Study - HappyHaven Home Rental App , Case Study - HappyHaven Home Rental App , Case Study - HappyHaven Home Rental App , Case Study - HappyHaven Home Rental App , Case Study - HappyHaven Home Rental App , Case Study - HappyHaven Home Rental App , Case Study - HappyHaven Home Rental App , Case Study - HappyHaven Home Rental App , Case Study - HappyHaven Home Rental App
Contributions
Problems Authored (0)
No Contribution
Problems Tested (0)
No Contribution
Editorials Contributed (0)
No Contribution