# Title Solutions Video Difficulty Tag 3198 Find Cities in Each State Solution Easy 3172 Second Day Verification Solution Easy 3150 Invalid Tweets II Solution Easy 3059 Find All Unique Email Domains Solution Easy 3051 Find Candidates for Data Scientist Position Solution Easy 2990 Loan Types Solution Easy 2879 Display the First Three Rows Python3 Easy 2205 The Number of Users That Are Eligible for Discount Solution Easy 2082 The Number of Rich Customers Solution Easy 2072 The Winner University Solution Easy 2026 Low-Quality Problems Solution Easy 1978 Employees Whose Manager Left the Company Solution Easy 1873 Calculate Special Bonus Solution Easy 1853 Convert Date Format Solution Easy 1821 Find Customers With Positive Revenue this Year Solution Easy 1809 Ad-Free Sessions Solution Easy 1795 Rearrange Products Table Solution Easy 1789 Primary Department for Each Employee Solution Easy 1757 Recyclable and Low Fat Products Solution Easy 1741 Find Total Time Spent by Each Employee Solution Easy 1729 Find Followers Count Solution Easy 1709 Biggest Window Between Visits Solution Medium 1693 Daily Leads and Partners Solution Easy 1683 Invalid Tweets Solution Easy 1677 Product's Worth Over Invoices Solution Easy 1667 Fix Names in a Table Solution Easy 1661 Average Time of Process per Machine Solution Easy 1633 Percentage of Users Attended a Contest Solution Easy 1623 All Valid Triplets That Can Represent a Country Solution Easy 1607 Sellers With No Sales Solution Easy 1596 The Most Frequently Ordered Products for Each Customer Solution Medium 1571 Warehouse Manager Solution Easy 1587 Bank Account Summary II Solution Easy 1581 Customer Who Visited but Did Not Make Any Transactions Solution Easy 1565 Unique Orders and Customers Per Month Solution Easy 1543 Fix Product Name Format Solution Easy 1527 Patients With a Condition Solution Easy 1517 Find Users With Valid E-Mails Solution Easy 1511 Customer Order Frequency Solution Easy 1495 Friendly Movies Streamed Last Month Solution Easy 1435 Create a Session Bar Chart Solution Easy 1484 Group Sold Products By The Date Solution Easy 1445 Apples & Oranges Solution Medium 1407 Top Travellers Solution Easy 1393 Capital Gain/Loss Solution Easy 1384 Total Sales Amount by Year Solution Hard 1378 Replace Employee ID With The Unique Identifier Solution Easy 1371 The Number of Employees Which Report to Each Employee Solution Easy 1369 Get the Second Most Recent Activity Solution Hard 1364 Number of Trusted Contacts of a Customer Solution Medium 1355 Activity Participants Solution Medium 1350 Students With Invalid Departments Solution Easy 1341 Movie Rating Solution Medium 1327 List the Products Ordered in a Period Solution Easy 1322 Ads Performance Solution Easy 1308 Running Total for Different Genders Solution Medium 1303 Find the Team Size Solution Easy 1294 Weather Type in Each Country Solution Easy 1285 Find the Start and End Number of Continuous Ranges Solution Medium 1280 Students and Examinations Solution 📺 Easy 1270 All People Report to the Given Manager Solution Medium 1251 Average Selling Price Solution Easy 1241 Number of Comments per Post Solution Easy 1211 Queries Quality and Percentage Solution Easy 1179 Reformat Department Table Solution Easy 1173 Immediate Food Delivery I Solution Easy 1148 Article Views I Solution Easy 1142 User Activity for the Past 30 Days II Solution Easy 1141 User Activity for the Past 30 Days I Solution Easy 1113 Reported Posts Solution Easy 1084 Sales Analysis III Solution Easy 1083 Sales Analysis II Solution Easy 1082 Sales Analysis I Solution Easy 1076 Project Employees II Solution Easy 1075 Project Employees I Solution Easy 1069 Product Sales Analysis II Solution Easy 1068 Product Sales Analysis I Solution Easy 1050 Actors and Directors Who Cooperated At Least Three Times Solution Easy 627 Swap Salary Solution Easy 626 Exchange Seats Solution Medium 620 Not Boring Movies Solution Easy 619 Biggest Single Number Solution Easy 618 Students Report By Geography Solution Hard Session Variables 615 Average Salary: Departments VS Company Solution Hard 614 Second Degree Follower Solution Medium Inner Join 613 Shortest Distance in a Line Solution Easy 612 Shortest Distance in a Plane Solution Medium 610 Triangle Judgement Solution Easy 608 Tree Node Solution Medium Union 607 Sales Person Solution Easy 603 Consecutive Available Seats Solution Easy 602 Friend Requests II: Who Has the Most Friends Solution Medium 601 Human Traffic of Stadium Solution Hard 597 Friend Requests I: Overall Acceptance Rate Solution Easy 596 Classes More Than 5 Students Solution Easy 595 Big Countries Solution Easy 586 Customer Placing the Largest Number of Orders Solution Easy 585 Investments in 2016 Solution Medium 584 Find Customer Referee Solution Easy 580 Count Student Number in Departments Solution Medium Left Join 578 Get Highest Answer Rate Question Solution Medium 577 Employee Bonus Solution Easy 574 Winning Candidate Solution Medium 571 Find Median Given Frequency of Numbers Solution Hard 570 Managers with at Least 5 Direct Reports Solution Medium 569 Median Employee Salary Solution Hard 534 Game Play Analysis III Solution Easy 512 Game Play Analysis II Solution Easy 511 Game Play Analysis I Solution Easy 262 Trips and Users Solution Hard Inner Join 197 Rising Temperature Solution Easy 196 Delete Duplicate Emails Solution Easy 185 Department Top Three Salaries Solution Hard 184 Department Highest Salary Solution Medium 183 Customers Who Never Order Solution Easy 182 Duplicate Emails Solution Easy 181 Employees Earning More Than Their Managers Solution Easy 180 Consecutive Numbers Solution Medium 178 Rank Scores Solution Medium 177 Nth Highest Salary Solution Medium 176 Second Highest Salary Solution Easy 175 Combine Two Tables Solution Easy