Khosiyat/LeetCode-DataBase-Pandas-SQL

LeetCode DataBase Pandas SQL

Pandas & SQL

EASY | SOLVED & EXPPLAINED

• Combine Two Tables

• Employees Earning More Than Their Managers

• Duplicate Emails

• Customers Who Never Order

• Delete Duplicate Emails

• Rising Temperature

• Game Play Analysis I

• Find Customer Referee

• Classes More Than 5 Students

• Employee Bonus

• Sales Person

• Biggest Single Number

• Not Boring Movies

• Swap Salary

• Actors & Directors Cooperated min Three Times

• Product Sales Analysis I

• Project Employees I

• Sales Analysis III

• Reformat Department Table

• Top Travellers

• Replace Employee ID With The Unique Identifier

• Group Sold Products By The Date

• Customer Placing the Largest Number of Orders

• Article Views I

• User Activity for the Past 30 Days I

• Find Users With Valid E-Mails

• Patients With a Condition

• Customer Who Visited but Did Not Make Any Transactions

• Bank Account Summary II

• Invalid Tweets

• Daily Leads and Partners

• Recyclable and Low Fat Products

• Rearrange Products Table

• Calculate Special Bonus

• Count Unique Subjects

• Count Unique Subjects

• Fix Names in a Table

• Primary Department for Each Employee

• The Latest Login in 2020

• Find Total Time Spent by Each Employee

• Find Followers Count

• Percentage of Users Attended a Contest

• Employees With Missing Information

• Average Time of Process per Machine

  MEDIUM | SOLVED & EXPPLAINED

• Market Analysis I

• Product Price at a Given Date

• Immediate Food Delivery II

• Monthly Transactions I

• Last Person to Fit in the Bus

• Movie Rating

• Capital Gain/Loss

• Product Sales Analysis III

• Customers Who Bought All Products

• Exchange Seats

• Tree Node

• Friend Requests II: Who Has the Most Friends

• Investments in 2016

• Managers with at Least 5 Direct Reports

• Game Play Analysis IV

• Department Highest Salary

• Consecutive Numbers

• Rank Scores

• Nth Highest Salary

• Second Highest Salary

• Confirmation Rate

HARD | SOLVED & EXPPLAINED

• Human Traffic of Stadium

• Trips and Users

• Department Top Three Salaries