Arpan Sharma
- 2★arpan1294
- India
- Student
- Thapar Institute of Engineering and Technology Patiala, Punjab
- List of teams by Arpan Sharma
- https://discuss.codechef.com/u/arpan1294
- No Active Plan. View Details
Activity Heat Map
NewRating Graph
Ratings System Update
(2023-01-04 23:00:04)Ratings System Update
(2022-12-20 00:00:00)CodeChef Rating Distribution
Submissions
Practice Problems (96):
Practice:
Bytelandian gold coins, Sums in a Triangle, ATM, Paying up, Fit to Play, Arranging Cup-cakes, Racing Horses, Ciel and Receipt, Magic Rankings, Your Name is Mine, Chopsticks, Chef and Kingship, Chef-jumping, Shortest Path in Binary Trees, The Smallest Pair, Walk on the Axis, One Dimensional Kingdoms, Broken Telephone, Sum of Digits, Chef and Dolls, Count Subarrays, Strange operations, Chef and digits of a number, Alternating subarray prefix, Cats and Dogs, Coins And Triangle, Sticks, One more weird game, Lazy Jem, Euron Problem, Snake Procession, Rectangle, Jumping in the hills, Mix the Colors, Rinku likes Soup, Encoding Message, Chef and Eid, Qualifying to Pre-Elimination, Distinct Pairs, Average Number, Playing with Strings, Tennis Tournament, Weapon Value, That Is My Score!, Change It, Exam Cheating, School of Geometry, Hard Cash, Lavanya Loves DFA, Sell All the Cars, Chef in Fantasy League, Chef and String, Chef and Strings, Chef and Linear Chess, Sudhanva and Books, Chef and Work, Fair Elections, Distinct Pair Sums, Maximise Function, Turn It, Chocolate Monger, Chef and Spells, Maximum Length Even Subarray, Fake GCD, Alternating Work Days, Indivisible Permutation, Easy Permutation, Max Value of MST, Reduce to zero, It is My Serve, Determine the Score, Retrieve the Array, Positive array, To Divide or Not To Divide, Team of Two, Remove Bad elements, Good Turn, Reach Home, MIN To MAX, Candy Division, Chef Eren, Budget of Technex, Couple Game, Learning SQL, AP Free Sequences, Printing Binary Array, Favourite Numbers, Odd GCD Permutation, Chef Odd, Blobby Volley Scores, Bus Seat Numbering, Parking Charges, CodeChef Streak, Dotify Playlist, Water Filling, All New CodeChef
Contests (108):
February Long 2022 - II, Division 3 (Rated):
Avoid Fixed Points, World Chess Championship, Chef and NextGen, Xor Palindrome
March Long One 2022, Division 4 (Rated):
Akash and Function, Substring of a Substring, Akash and Missing Class, Exact Marks, Discus Throw, Bath in Winters, Wordle
April Long Two 2022 Division 4 (Rated):
Sasta Shark Tank, Six Friends, Best Coupon, Pseudo Sorted Array
Starters 42 Division 4 (Rated):
Minimum or Maximum, Divisible by 3, How Many Maximums, Age Limit, Equal Distribution, Minimum number of Flips
June Long One 2022 Division 4 (Rated):
Chairs Requirement, Subscriptions, Divisible by i , Possible GCD, Alternate Additions, Equal Strings
Starters 43 Division 4 (Rated):
The Optimal Pairs, Burgers, DNA Storage, Distinct Palindrome, Joining Date, Waiting Time
Starters 45 Division 4 (Rated):
Chef and his Apps, Best of Two, Adjacent Sum Parity, Change Row and Column Both
Starters 47 Division 4 (Rated):
Chef On Date, Similar Heights, Construct N, End Sorted, Minimum Coins, Chess Time
July Lunchtime 2022 Division 4 (Rated):
Interior Design, The Last Levels, Easy Pronunciation, True and False Paper
Multiple prints using single print statement:
MCQ - 4, MCQ - 5, Multiple outputs using a single line, Printing text and number together, Inserting space between numbers
Learning Paths (93):
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, 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, Rename columns using As, 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
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, Data Transformation, Non-Correlated Subqueries, Problem - Non-Correlated Subqueries, Correlated Subqueries, Problem - Correlated Subqueries, Union All, Intersect, Except, Conditional Aggregates Introduction, Null, Case - When, Count using Case, Sum using Case, Combining Aggregates
SQL at Work:
Different tools used in analytics at work, SQL, Case study - Covid impact on ABC Retail
Learn Java:
Introduction, Printing text, Arithmetic Operations, MCQ - 1, MCQ - 2, Multiple Outputs, Understanding the print command, Area & Perimeter of Rectangle, Rearrange Code, Division, Understanding the default code, MCQ, Rearrange, Variables in Java, Declaring a variable, Addition of Variables, Area of Rectangle, Double datatype, String Datatype, Bool Datatype, Cost of painting, Negative Numbers, MCQ - 10, MCQ - 11, MCQ - 12
Practice Paths (17):
Contributions
Problems Authored (0)
No Contribution
Problems Tested (0)
No Contribution
Editorials Contributed (0)
No Contribution