LeetCode

LeetCode Algorithm

#	Title	Solution	Difficulty
1	Two Sum	Java, C++	Easy
9	Palindrome Number	Java	Easy
13	Roman to Integer	Java	Easy
14	Longest Common Prefix	Java	Easy
20	Valid Parentheses	Java	Easy
21	Merge Two Sorted Lists	Java	Easy
26	Remove Duplicates from Sorted Array	Java, C++	Easy
27	Remove Element	Java, C++	Easy
28	Find the Index of the First Occurrence in a String	Java	Easy
35	Search Insert Position	Java	Easy
53	Maximum Subarray	Java	Medium
58	Length of Last Word	Java	Easy
66	Plus One	Java	Easy
67	Add Binary	Java	Easy
69	Sqrt(x)	Java	Easy
70	Climbing Stairs	Java	Easy
88	Merge Sorted Array	Java	Easy
118	Pascal's Triangle	Java	Easy
119	Pascal's Triangle II	Java	Easy

LeetCode Database

#	Title	Solution	Difficulty
175	Combine Two Tables	MySQL	Easy
176	Second Highest Salary	MySQL	Medium
177	Nth Highest Salary	MySQL	Medium
178	Rank Scores	MySQL	Medium
180	Consecutive Numbers	MySQL	Medium
181	Employees Earning More Than Their Managers	MySQL	Easy
182	Duplicate Emails	MySQL	Easy
183	Customers Who Never Order	MySQL	Easy
184	Department Highest Salary	MySQL	Medium
185	Department Top Three Salaries	MySQL	Hard
196	Delete Duplicate Emails	MySQL	Easy
197	Rising Temperature	MySQL	Easy
262	Trips and Users	MySQL	Hard
511	Game Play Analysis I	MySQL	Easy
550	Game Play Analysis IV	MySQL	Medium
577	Employee Bonus	MySQL	Easy
584	Find Customer Referee	MySQL	Easy
586	Customer Placing the Largest Number of Orders	MySQL	Easy
595	Big Countries	MySQL	Easy
596	Classes More Than 5 Students	MySQL	Easy
607	Sales Person	MySQL	Easy
610	Triangle Judgement	MySQL	Easy
619	Biggest Single Number	MySQL	Easy
620	Not Boring Movies	MySQL	Easy
627	Swap Salary	MySQL	Easy
1050	Actors and Directors Who Cooperated At Least Three Times	MySQL	Easy
1068	Product Sales Analysis I	MySQL	Easy
1075	Project Employees I	MySQL	Easy
1084	Sales Analysis III	MySQL	Easy
1141	User Activity for the Past 30 Days I	MySQL	Easy
1148	Article Views I	MySQL	Easy
1179	Reformat Department Table	MySQL	Easy
1211	Queries Quality and Percentage	MySQL	Easy
1251	Average Selling Price	MySQL	Easy
1280	Students and Examinations	MySQL	Easy
1327	List the Products Ordered in a Period	MySQL	Easy
1378	Replace Employee ID With The Unique Identifier	MySQL	Easy
1393	Capital Gain/Loss	MySQL	Medium
1407	Top Travellers	MySQL	Easy
1484	Group Sold Products By The Date	MySQL	Easy
1517	Find Users With Valid E-Mails	MySQL	Easy
1517	Find Users With Valid E-Mails	MySQL	Easy
1581	Customer Who Visited but Did Not Make Any Transactions	MySQL	Easy
1587	Bank Account Summary II	MySQL	Easy
1633	Percentage of Users Attended a Contest	MySQL	Easy
1661	Average Time of Process per Machine	MySQL	Easy
1667	Fix Names in a Table	MySQL	Easy
1683	Invalid Tweets	MySQL	Easy
1693	Daily Leads and Partners	MySQL	Easy
1729	Find Followers Count	MySQL	Easy
1731	The Number of Employees Which Report to Each Employee	MySQL	Easy
1741	Find Total Time Spent by Each Employee	MySQL	Easy
1757	Recyclable and Low Fat Products	MySQL	Easy
1789	Primary Department for Each Employee	MySQL	Easy
1795	Rearrange Products Table	MySQL	Easy
1873	Calculate Special Bonus	MySQL	Easy
1890	The Latest Login in 2020	MySQL	Easy
1907	Count Salary Categories	MySQL	Easy
1934	Confirmation Rate	MySQL	Medium
1965	Employees With Missing Information	MySQL	Easy
1978	Employees Whose Manager Left the Company	MySQL	Easy
2356	Number of Unique Subjects Taught by Each Teacher	MySQL	Easy

LeetCode Shell

#	Title	Solution	Difficulty
192	Word Frequency	Bash	Medium
193	Valid Phone Numbers	Bash	Easy
194	Transpose File	Bash	Medium
195	Tenth Line	Bash	Easy