Skip to content

Prepare For Coder Interview – Denny

  • Basic
  • Medium
  • Hard
  • Architect
  • Life

Review: SQL Problems

Posted on January 15, 2018July 26, 2020 by braindenny

Review: SQL Problems



  • CheatSheet: SQL & MySql
  • CheatSheet: Leetcode For Code Interview
  • CheatSheet: Common Code Problems & Follow-ups

See all sql problems: #sql.

  • Review: SQL Problems
  • LeetCode: Winning Candidate
  • LeetCode: Weather Type in Each Country
  • LeetCode: Unpopular Books
  • LeetCode: Trips and Users
  • LeetCode: Triangle Judgement
  • LeetCode: Tree Node
  • LeetCode: Total Sales Amount by Year
  • LeetCode: Top Travellers
  • LeetCode: Team Scores in Football Tournament
  • LeetCode: Swap Salary
  • LeetCode: Students With Invalid Departments
  • LeetCode: Students Report By Geography
  • LeetCode: Students and Examinations
  • LeetCode: Shortest Distance in a Plane
  • LeetCode: Shortest Distance in a Line
  • LeetCode: Second Highest Salary
  • LeetCode: Second Degree Follower
  • LeetCode: Sales Person
  • LeetCode: Sales Analysis II
  • LeetCode: Sales Analysis I
  • LeetCode: Running Total for Different Genders
  • LeetCode: Rising Temperature
  • LeetCode: Restaurant Growth
  • LeetCode: Reported Posts
  • LeetCode: Report Contiguous Dates
  • LeetCode: Replace Employee ID With The Unique Identifier
  • LeetCode: Rectangles Area
  • LeetCode: Rank Scores
  • LeetCode: Queries Quality and Percentage
  • LeetCode: Project Employees III
  • LeetCode: Project Employees II
  • LeetCode: Project Employees I
  • LeetCode: Product Sales Analysis III
  • LeetCode: Product Sales Analysis II
  • LeetCode: Product Sales Analysis I
  • LeetCode: Product Price at a Given Date
  • LeetCode: Page Recommendations
  • LeetCode: Number of Trusted Contacts of a Customer
  • LeetCode: Number of Transactions per Visit
  • LeetCode: Nth Highest Salary
  • LeetCode: NPV Queries
  • LeetCode: Not Boring Movies
  • LeetCode: New Users Daily Count
  • LeetCode: Movie Rating
  • LeetCode: Monthly Transactions II
  • LeetCode: Median Employee Salary
  • LeetCode: Market Analysis II
  • LeetCode: Managers with at Least 5 Direct Reports
  • LeetCode: List the Products Ordered in a Period
  • LeetCode: Investments in 2016
  • LeetCode: Immediate Food Delivery II
  • LeetCode: Immediate Food Delivery I
  • LeetCode: Human Traffic of Stadium
  • LeetCode: Highest Grade For Each Student
  • LeetCode: Get the Second Most Recent Activity
  • LeetCode: Get Highest Answer Rate Question
  • LeetCode: Game Play Analysis IV
  • LeetCode: Game Play Analysis III
  • LeetCode: Game Play Analysis II
  • LeetCode: Game Play Analysis I
  • LeetCode: Friend Requests II: Who Has the Most Friends
  • LeetCode: Friend Requests I: Overall Acceptance Rate
  • LeetCode: Find the Team Size
  • LeetCode: Find the Start and End Number of Continuous Ranges
  • LeetCode: Find the Quiet Students in All Exams
  • LeetCode: Find Median Given Frequency of Numbers
  • LeetCode: Find Customer Referee
  • LeetCode: Find Cumulative Salary of an Employee
  • LeetCode: Exchange Seats
  • LeetCode: Evaluate Boolean Expression
  • LeetCode: Employees Earning More Than Their Managers
  • LeetCode: Employee Bonus
  • LeetCode: Department Top Three Salaries
  • LeetCode: Department Highest Salary
  • LeetCode: Delete Duplicate Emails
  • LeetCode: Customers Who Never Order
  • LeetCode: Customers Who Bought Products A and B but Not C
  • LeetCode: Customers Who Bought All Products
  • LeetCode: Customer Placing the Largest Number of Orders
  • LeetCode: Create a Session Bar Chart
  • LeetCode: Count Student Number in Departments
  • LeetCode: Consecutive Numbers
  • LeetCode: Consecutive Available Seats
  • LeetCode: Combine Two Tables
  • LeetCode: Classes More Than 5 Students
  • LeetCode: Capital Gain/Loss
  • LeetCode: Calculate Salaries
  • LeetCode: Biggest Single Number
  • LeetCode: Big Countries
  • LeetCode: Average Selling Price
  • LeetCode: Average Salary: Departments VS Company
  • LeetCode: Article Views II
  • LeetCode: Article Views I
  • LeetCode: Apples & Oranges
  • LeetCode: All People Report to the Given Manager
  • LeetCode: Ads Performance
  • LeetCode: Actors and Directors Who Cooperated At Least Three Times
  • LeetCode: Activity Participants
  • LeetCode: Active Users
  • LeetCode: Active Businesses

See more blog posts.

linkedin
github
slack

Post Views: 5
Posted in ReviewTagged review, sql

Post navigation

LeetCode: Swap Nodes in Pairs
LeetCode: Partition List

Leave a Reply Cancel reply

Your email address will not be published.

Tags

#array #backtracking #bfs #binarytree #bitmanipulation #blog #classic #codetemplate #combination #dfs #dynamicprogramming #game #graph #greedy #heap #inspiring #interval #linkedlist #manydetails #math #palindrome #recursive #slidingwindow #stack #string #subarray #trie #twopointer #twosum binarysearch editdistance hashmap intervaldp knapsack monotone oodesign presum rectangle redo review rotatelist series sql treetraversal unionfind

Recent Posts

  • a
  • a
  • a
  • a
  • a

Recent Comments

    Archives

    Categories

    • Amusing
    • Basic
    • Easy
    • Hard
    • Life
    • Medium
    • Resource
    • Review
    • Series
    • Uncategorized
    Proudly powered by WordPress | Theme: petals by Aurorum.