Tag LLVM
In this post, I will show how I write an...
Tag Hash Table
LeetCode 3. Given a string s, find the length of...
LeetCode 1748. You are given an integer array nums. The...
LeetCode 380. Implement a RandomizedSet class.
LeetCode 961. In a array A of size 2N, there...
LeetCode 349. Given two arrays, write a function to compute...
LeetCode 1213. Given three integer arrays arr1, arr2 and arr3...
LeetCode 771. You’re given strings jewels representing the types of...
LeetCode 1512. Given an array of integers nums. Return the...
LeetCode 1539. Given an array arr of positive integers sorted...
LeetCode 1224. Given an array nums of positive integers, return...
LeetCode 974. Given an array of integers nums and an...
LeetCode 454. Given four lists A, B, C, D of...
LeetCode 523. Given an array of non-negative integers nums and...
LeetCode 560. Given an array of integers nums and an...
LeetCode 1. Given an array of integers nums and an...
Tag Leetcode
LeetCode 1890. Write an SQL query to report the latest...
LeetCode 1843. Write an SQL query to report the IDs...
LeetCode 1892. Write an SQL query to find all the...
LeetCode 1867. Write an SQL query to find the order_id...
LeetCode 1831. Write an SQL query to report the IDs...
LeetCode 1841. Write an SQL query to report the statistics...
LeetCode 1875. Write an SQL query to report the IDs...
LeetCode 1821. Write an SQL query to report the customers...
LeetCode 1853. Write an SQL query to convert each date...
LeetCode 1873. Write an SQL query to calculate the bonus...
LeetCode 1795. Write an SQL query to rearrange the Products...
LeetCode 1811. Write an SQL query to report the name...
LeetCode 1812. You are given coordinates, a string that represents...
LeetCode 1809. Write an SQL query to report all the...
LeetCode 8. Implement the myAtoi(string s) function, which converts a...
LeetCode 1789. Write an SQL query to report all the...
LeetCode 1783. Write an SQL query to report the number...
LeetCode 1777. Write an SQL query to find the price...
LeetCode 3. Given a string s, find the length of...
LeetCode 1767. Write an SQL query to report the IDs...
LeetCode 2. You are given two non-empty linked lists representing...
LeetCode 1748. You are given an integer array nums. The...
LeetCode 1757. Write an SQL query to find the ids...
LeetCode 1747. Write an SQL query to find the account_id...
LeetCode 380. Implement a RandomizedSet class.
LeetCode 961. In a array A of size 2N, there...
LeetCode 349. Given two arrays, write a function to compute...
LeetCode 1213. Given three integer arrays arr1, arr2 and arr3...
LeetCode 1741. Write an SQL query to calculate the total...
LeetCode 771. You’re given strings jewels representing the types of...
LeetCode 1512. Given an array of integers nums. Return the...
LeetCode 1539. Given an array arr of positive integers sorted...
LeetCode 1731. Write an SQL query to report the ids...
LeetCode 1729. Write an SQL query that will, for each...
LeetCode 1715. Write an SQL query to count the number...
LeetCode 1709. Write an SQL query that will, for each...
LeetCode 1384. Write an SQL query to report the Total...
LeetCode 1479. Write an SQL query to report how many...
LeetCode 1651. Write an SQL query to compute the average_ride_distance...
LeetCode 1369. Write an SQL query to show the second...
LeetCode 1412. Write an SQL query to report the students...
LeetCode 1194. Write an SQL query to find the winner...
LeetCode 618. A U.S graduate school has students from Asia,...
LeetCode 1225. Write an SQL query to generate a report...
LeetCode 569. Write a SQL query to find the median...
LeetCode 1159. Write an SQL query to find for each...
LeetCode 1635. Write an SQL query to report the following...
LeetCode 1097. Write an SQL query that reports for each...
LeetCode 1127. Write an SQL query to find the total...
LeetCode 262. Write a SQL query to find the cancellation...
LeetCode 1336. Write an SQL query to find how many...
LeetCode 601. Write an SQL query to display the records...
LeetCode 1645. Write an SQL query to report the percentage...
LeetCode 571. Write a query to find the median of...
LeetCode 579. Write a SQL to get the cumulative sum...
LeetCode 185. Write a SQL query to find employees who...
LeetCode 615. Given two tables as below, write a query...
LeetCode 1098. Write an SQL query that reports the books...
LeetCode 614. Please write a sql query to get the...
LeetCode 1132. Write an SQL query to find the average...
LeetCode 1699. Write an SQL query to report the number...
LeetCode 177. Write a SQL query to get the nth...
LeetCode 1107. Write an SQL query that reports for every...
LeetCode 1205. Write an SQL query to find for each...
LeetCode 578. Write a sql query to identify the question...
LeetCode 184. Write a SQL query to find employees who...
LeetCode 1149. Write an SQL query to find all the...
LeetCode 1454. Write an SQL query to find the id...
LeetCode 574. Write a sql to find the name of...
LeetCode 1212. Write an SQL query that selects the team_id,...
LeetCode 178. Write a SQL query to rank scores. If...
LeetCode 1070. Write an SQL query that selects the product...
LeetCode 1341. Write the following SQL query to find the...
LeetCode 585. Write a query to print the sum of...
LeetCode 1174. Write an SQL query to find the percentage...
LeetCode 602. In social network like Facebook or Twitter, people...
LeetCode 1501. Write an SQL query to find the countries...
LeetCode 580. A university uses 2 data tables, student and...
LeetCode 1555. Our bank records all transactions in the table...
LeetCode 608. Given a table tree, id is identifier of...
LeetCode 1549. Write an SQL query to find the most...
LeetCode 612. Write a query to find the shortest distance...
LeetCode 1459. Write an SQL query to report of all...
LeetCode 1164. Write an SQL query to find the prices...
LeetCode 1264. Write an SQL query to recommend pages to...
LeetCode 1193. Write an SQL query to find for each...
LeetCode 1158. Write an SQL query to find for each...
LeetCode 570. Given the Employee table, write a SQL query...
LeetCode 1613. Write an SQL query to find the missing...
LeetCode 626. Mary is a teacher in a middle school...
LeetCode 1045. Write an SQL query for a report that...
LeetCode 1126. Write an SQL query to find all active...
LeetCode 1532. Write an SQL query to find the most...
LeetCode 1321. You are the restaurant owner and you want...
LeetCode 1077. Write an SQL query that reports the most...
LeetCode 1364. Write an SQL query to find the following...
LeetCode 1421. Write an SQL query to find the npv...
LeetCode 1204. Write an SQL query to find the person_name...
LeetCode 1112. Write a SQL query to find the highest...
LeetCode 1440. Write an SQL query to evaluate the boolean...
LeetCode 1468. Write an SQL query to find the salaries...
LeetCode 1355. Write an SQL query to find the names...
LeetCode 1142. Write an SQL query to find the average...
LeetCode 1596. Write an SQL query to find the most...
LeetCode 1308. Write an SQL query to find the total...
LeetCode 1495. Write an SQL query to report the distinct...
LeetCode 597. Write an SQL query to find the overall...
LeetCode 1285. Write an SQL query to find the start...
LeetCode 1398. Write an SQL query to report the customer_id...
LeetCode 596. Please list out all classes which have more...
LeetCode 1393. Write an SQL query to report the Capital...
LeetCode 619. Table my_numbers contains many numbers in column num...
LeetCode 1445. Write an SQL query to report the difference...
LeetCode 1270. Write an SQL query to find employee_id of...
LeetCode 1294. Write an SQL query to find the type...
LeetCode 1141. Write an SQL query to find the daily...
LeetCode 610. A pupil Tim gets homework to identify whether...
LeetCode 1280. Write an SQL query to find the number...
LeetCode 607. Given three tables, salesperson, company, orders.
LeetCode 1084. Write an SQL query that reports the products...
LeetCode 1083. Write an SQL query that reports the buyers...
LeetCode 1113. Write an SQL query that reports the number...
LeetCode 1211. Write an SQL query to find each query_name,...
LeetCode 1076. Write an SQL query that reports all the...
LeetCode 1075. Write an SQL query that reports the average...
LeetCode 1241. Write an SQL query to find number of...
LeetCode 620. X city opened a new cinema, many people...
LeetCode 1543. Write an SQL query to report product_name in...
LeetCode 603. Several friends at a cinema ticket office would...
LeetCode 1322. A company is running Ads and wants to...
LeetCode 1407. Write an SQL query to report the distance...
LeetCode 627. Given a table salary, such as the one...
LeetCode 613. Write a query to find the shortest distance...
LeetCode 1082. Write an SQL query that reports the best...
LeetCode 1179. Write an SQL query to reformat the table...
LeetCode 1069. Write an SQL query that reports the total...
LeetCode 1068. Write an SQL query that reports all product...
LeetCode 1327. Write an SQL query to get the names...
LeetCode 1173. Write an SQL query to find the percentage...
LeetCode 1517. Write an SQL query to find the users...
LeetCode 584. Given a table customer holding customers information and...
LeetCode 586. Query the customer_number from the orders table for...
LeetCode 1511. Write an SQL query to report the customer_id...
LeetCode 1435. You want to know how long a user...
LeetCode 595. Write a SQL solution to output big countries’...
LeetCode 1251. Write an SQL query to find the average...
LeetCode 1148. Write an SQL query to find all the...
LeetCode 1050. Write a SQL query for a report that...
LeetCode 1565. Write an SQL query to find the number...
LeetCode 1607. Write an SQL query to report the names...
LeetCode 197. Write an SQL query to find all dates’...
LeetCode 550. Write an SQL query that reports the fraction...
LeetCode 534. Write an SQL query that reports for each...
LeetCode 512. Write a SQL query that reports the device...
LeetCode 511. Write an SQL query that reports the first...
LeetCode 577. Select all employee’s name and bonus whose bonus...
LeetCode 196. Write a SQL query to delete all duplicate...
LeetCode 1693. Write an SQL query that will, for each...
LeetCode 1581. Write an SQL query to find the IDs...
LeetCode 1677. Write an SQL query that will, for all...
LeetCode 1633. Write an SQL query to find the percentage...
LeetCode 1667. Write an SQL query to fix the names...
LeetCode 182. Write a SQL query to find all duplicate...
LeetCode 183. Write a SQL query to find all customers...
LeetCode 180. Write an SQL query to find all numbers...
LeetCode 1661. There is a factory website that has several...
LeetCode 176. Given the Employee table, write a SQL query...
LeetCode 181. Given the Employee table, write a SQL query...
LeetCode 1587. Write an SQL query to report the name...
LeetCode 1484. Write an SQL query to find for each...
LeetCode 1623. Write an SQL query to find all the...
LeetCode 1571. Write an SQL query to report how much...
LeetCode 1350. Write an SQL query to find the id...
LeetCode 1378. Write an SQL query to show the unique...
LeetCode 1527. Write an SQL query to report the patient_id,...
LeetCode 1683. Write an SQL query to find the IDs...
LeetCode 1303. Write an SQL query to find the team...
LeetCode 175. Write a SQL query for a report that...
LeetCode 1224. Given an array nums of positive integers, return...
LeetCode 200. Given an m x n 2d grid map...
LeetCode 56. Given an array of intervals, merge all overlapping...
LeetCode 1438. Given an array of integers nums and an...
LeetCode 543. Given a binary tree, compute the diameter of...
LeetCode 206. Reverse a singly linked list.
LeetCode 92. Reverse a linked list from position m to...
LeetCode 234. Given a singly linked list, determine if it’s...
LeetCode 23. You are given an array of k linked-lists...
LeetCode 21. Merge two sorted linked lists and return a...
LeetCode 4. Given two sorted arrays nums1 and nums2 of...
LeetCode 367. Given a positive integer num, write a function...
LeetCode 69. Given a non-negative integer x, compute and return...
LeetCode 35. Given a sorted array of distinct integers and...
LeetCode 1032. Implement the StreamChecker class as follows. Constructor, initialize...
LeetCode 421. Given an integer array nums, return the maximum...
LeetCode 208. Implement a Trie with insert, search, and startsWith...
LeetCode 1023. A query word matches a given pattern if...
LeetCode 212. Given an m x n board of characters...
LeetCode 167. Given an array of integers nums sorted in...
LeetCode 974. Given an array of integers nums and an...
LeetCode 648. Given a dictionary consisting of many roots, and...
LeetCode 720. Given a list of strings words representing an...
LeetCode 454. Given four lists A, B, C, D of...
LeetCode 523. Given an array of non-negative integers nums and...
LeetCode 472. Given a list of words (without duplicates), return...
LeetCode 1099. Given an array of integers nums and an...
LeetCode 560. Given an array of integers nums and an...
LeetCode 713. Given an array of positive integers nums and...
LeetCode 15. Given an array of integers nums, return all...
LeetCode 18. Given an array of integers nums and an...
LeetCode 1. Given an array of integers nums and an...
Tag Two Pointer
LeetCode 234. Given a singly linked list, determine if it’s...
LeetCode 167. Given an array of integers nums sorted in...
LeetCode 1099. Given an array of integers nums and an...
LeetCode 713. Given an array of positive integers nums and...
LeetCode 15. Given an array of integers nums, return all...
LeetCode 18. Given an array of integers nums and an...
Tag Trie
LeetCode 1032. Implement the StreamChecker class as follows. Constructor, initialize...
LeetCode 421. Given an integer array nums, return the maximum...
LeetCode 208. Implement a Trie with insert, search, and startsWith...
LeetCode 1023. A query word matches a given pattern if...
LeetCode 212. Given an m x n board of characters...
LeetCode 648. Given a dictionary consisting of many roots, and...
LeetCode 720. Given a list of strings words representing an...
LeetCode 472. Given a list of words (without duplicates), return...
Tag Depth First Search
LeetCode 200. Given an m x n 2d grid map...
LeetCode 543. Given a binary tree, compute the diameter of...
LeetCode 720. Given a list of strings words representing an...
LeetCode 472. Given a list of words (without duplicates), return...
Tag Backtracking
LeetCode 212. Given an m x n board of characters...
Tag Greedy
LeetCode 421. Given an integer array nums, return the maximum...
Tag Queue
LeetCode 200. Given an m x n 2d grid map...
LeetCode 1438. Given an array of integers nums and an...
LeetCode 1032. Implement the StreamChecker class as follows. Constructor, initialize...
Tag Binary Search
LeetCode 4. Given two sorted arrays nums1 and nums2 of...
LeetCode 367. Given a positive integer num, write a function...
LeetCode 69. Given a non-negative integer x, compute and return...
LeetCode 35. Given a sorted array of distinct integers and...
Tag C++
Every C++ expression has a type and belongs to a...
Perfect forwarding reduces the need for overloaded functions and helps...
The rvalue references enable us to distinguish an lvalue from...
A reference is an alias of another object. It stores...
An lvalue reference is another name of an object. An...
A lambda expression is a convenient way of defining an...
A template specialization is a separate definition in which the...
C++ transforms the operands to a common type before performing...
An explicit conversion is also called as a cast. There...
The constructor that takes a single parameter that is a...
A function specified as inline is expanded everywhere it is...
A function pointer is a pointer that denotes a function...
Design the data structures for an online book reader system...
Design a parking lot using object-oriented principles. We will focus...
An object oriented design problem. Imagine you have a call...
The singleton design pattern is a type of creational pattern...
The factory design pattern is a type of creational pattern...
Sometimes an object must store a way to access the...
A friend class can access private and protected members of...
A unique_ptr does not share its pointer. It cannot be...
In modern C++ programming, the Standard Library includes smart pointers,...
The shared_ptr type is a smart pointer that is designed...
A template is a blueprint or formula for creating a...
Polymorphism means having more than one function with the same...
An interface describes the behavior or capabilities of a C++...
Tag Interface
An interface describes the behavior or capabilities of a C++...
Tag Abstract Class
An interface describes the behavior or capabilities of a C++...
Tag Pure Virtual Function
Polymorphism means having more than one function with the same...
An interface describes the behavior or capabilities of a C++...
Tag Concrete Class
An interface describes the behavior or capabilities of a C++...
Tag Polymorphism
Polymorphism means having more than one function with the same...
Tag Overload
Polymorphism means having more than one function with the same...
Tag Override
Polymorphism means having more than one function with the same...
Tag Virtual Function
Polymorphism means having more than one function with the same...
Tag Template
A template specialization is a separate definition in which the...
A template is a blueprint or formula for creating a...
Tag Function Template
A template is a blueprint or formula for creating a...
Tag Class Template
A template is a blueprint or formula for creating a...
Tag Smart Pointers
Sometimes an object must store a way to access the...
A unique_ptr does not share its pointer. It cannot be...
In modern C++ programming, the Standard Library includes smart pointers,...
The shared_ptr type is a smart pointer that is designed...
Tag RAII
Sometimes an object must store a way to access the...
A unique_ptr does not share its pointer. It cannot be...
In modern C++ programming, the Standard Library includes smart pointers,...
The shared_ptr type is a smart pointer that is designed...
Tag Shared_Ptr
In modern C++ programming, the Standard Library includes smart pointers,...
The shared_ptr type is a smart pointer that is designed...
Tag Raw Pointers
In modern C++ programming, the Standard Library includes smart pointers,...
Tag Unique_Ptr
A unique_ptr does not share its pointer. It cannot be...
In modern C++ programming, the Standard Library includes smart pointers,...
Tag Weak_Ptr
Sometimes an object must store a way to access the...
In modern C++ programming, the Standard Library includes smart pointers,...
Tag Friend Class
A friend class can access private and protected members of...
Tag Friend Function
A friend class can access private and protected members of...
Tag Cyclic Reference
Sometimes an object must store a way to access the...
Tag Weak Reference
Sometimes an object must store a way to access the...
Tag Factory Pattern
The factory design pattern is a type of creational pattern...
Tag Creational Pattern
The singleton design pattern is a type of creational pattern...
The factory design pattern is a type of creational pattern...
Tag Singleton Pattern
An object oriented design problem. Imagine you have a call...
The singleton design pattern is a type of creational pattern...
Tag OOD
Design the data structures for an online book reader system...
Design a parking lot using object-oriented principles. We will focus...
An object oriented design problem. Imagine you have a call...
Tag Linked List
LeetCode 2. You are given two non-empty linked lists representing...
LeetCode 206. Reverse a singly linked list.
LeetCode 92. Reverse a linked list from position m to...
LeetCode 234. Given a singly linked list, determine if it’s...
LeetCode 23. You are given an array of k linked-lists...
LeetCode 21. Merge two sorted linked lists and return a...
Tag Priority Queue
LeetCode 23. You are given an array of k linked-lists...
Tag Virtual Memory
How can the OS decide which page(s) to evict from...
How can the OS make use of a larger, slower...
How can we make page tables smaller.
How can we speed up address translation, and generally avoid...
How can we virtualize memory with pages, so as to...
How to support a large address space with (potentially) a...
How can we relocate the process in memory in a...
Virtual Memory is an abstraction that the Operating System provides...
Tag Function Pointers
A function pointer is a pointer that denotes a function...
Tag Pointers to Functions
A function pointer is a pointer that denotes a function...
Tag Inline Functions
A function specified as inline is expanded everywhere it is...
Tag Process
How can the OS provide the illusion of nearly-endless supply...
Tag Copy Constructors
The constructor that takes a single parameter that is a...
Tag Tree
LeetCode 543. Given a binary tree, compute the diameter of...
Tag Sliding Window
LeetCode 1438. Given an array of integers nums and an...
Tag Sort
LeetCode 56. Given an array of intervals, merge all overlapping...
Tag Breadth First Search
LeetCode 200. Given an m x n 2d grid map...
Tag Type Conversion
C++ transforms the operands to a common type before performing...
An explicit conversion is also called as a cast. There...
Tag Cast
An explicit conversion is also called as a cast. There...
Tag Template Specialization
A template specialization is a separate definition in which the...
Tag Partial Specialization
A template specialization is a separate definition in which the...
Tag Concurrency
Another important question is how threads interact when they access...
A thread is an abstraction for a single running process....
Tag Thread
Another important question is how threads interact when they access...
A thread is an abstraction for a single running process....
Tag C++ Concepts
A growing list of posts under the topic of C++...
Tag Object Oriented Design
A growing list of posts under the topic of Object...
Tag Operating System
A growing list of posts under the topic of Operating...
Tag Lambda Expression
A lambda expression is a convenient way of defining an...
Tag Reference
Every C++ expression has a type and belongs to a...
Perfect forwarding reduces the need for overloaded functions and helps...
The rvalue references enable us to distinguish an lvalue from...
A reference is an alias of another object. It stores...
An lvalue reference is another name of an object. An...
Tag Lvalue Reference
Every C++ expression has a type and belongs to a...
Perfect forwarding reduces the need for overloaded functions and helps...
The rvalue references enable us to distinguish an lvalue from...
A reference is an alias of another object. It stores...
An lvalue reference is another name of an object. An...
Tag Rvalue Reference
Every C++ expression has a type and belongs to a...
Perfect forwarding reduces the need for overloaded functions and helps...
The rvalue references enable us to distinguish an lvalue from...
A reference is an alias of another object. It stores...
An lvalue reference is another name of an object. An...
Tag LeetCode
A list of LeetCode database problems and solutions.
A growing list of LeetCode problems and solutions.
Tag MySQL
LeetCode 1890. Write an SQL query to report the latest...
LeetCode 1843. Write an SQL query to report the IDs...
LeetCode 1892. Write an SQL query to find all the...
LeetCode 1867. Write an SQL query to find the order_id...
LeetCode 1831. Write an SQL query to report the IDs...
LeetCode 1841. Write an SQL query to report the statistics...
LeetCode 1875. Write an SQL query to report the IDs...
LeetCode 1821. Write an SQL query to report the customers...
LeetCode 1853. Write an SQL query to convert each date...
LeetCode 1873. Write an SQL query to calculate the bonus...
LeetCode 1795. Write an SQL query to rearrange the Products...
LeetCode 1811. Write an SQL query to report the name...
LeetCode 1809. Write an SQL query to report all the...
LeetCode 1789. Write an SQL query to report all the...
LeetCode 1783. Write an SQL query to report the number...
LeetCode 1777. Write an SQL query to find the price...
LeetCode 1767. Write an SQL query to report the IDs...
LeetCode 1757. Write an SQL query to find the ids...
LeetCode 1747. Write an SQL query to find the account_id...
LeetCode 1741. Write an SQL query to calculate the total...
LeetCode 1731. Write an SQL query to report the ids...
LeetCode 1729. Write an SQL query that will, for each...
The INNER JOIN keyword selects records that have matching values...
Aliases are nicknames. They give us a shorthand way of...
LeetCode 1715. Write an SQL query to count the number...
The OR operator combines two Boolean expressions and returns true...
The LIMIT clause is used in the SELECT statement to...
The LIKE operator is used in a WHERE clause to...
To test whether a value is NULL or not, we...
The IN operator allows us to determine if a specified...
The BETWEEN operator selects values within a given range.
The AND operator is a logical operator that combines two...
The WHERE clause allows us to choose which rows are...
In order to remove duplicate rows, we use the DISTINCT...
LeetCode 1709. Write an SQL query that will, for each...
The ORDER BY clause is used to sort the result-set...
The SELECT statement allows us to read data from one...
A growing list of MySQL tutorials.
LeetCode 1384. Write an SQL query to report the Total...
LeetCode 1479. Write an SQL query to report how many...
LeetCode 1651. Write an SQL query to compute the average_ride_distance...
LeetCode 1369. Write an SQL query to show the second...
LeetCode 1412. Write an SQL query to report the students...
LeetCode 1194. Write an SQL query to find the winner...
LeetCode 618. A U.S graduate school has students from Asia,...
LeetCode 1225. Write an SQL query to generate a report...
LeetCode 569. Write a SQL query to find the median...
LeetCode 1159. Write an SQL query to find for each...
LeetCode 1635. Write an SQL query to report the following...
LeetCode 1097. Write an SQL query that reports for each...
LeetCode 1127. Write an SQL query to find the total...
LeetCode 262. Write a SQL query to find the cancellation...
LeetCode 1336. Write an SQL query to find how many...
LeetCode 601. Write an SQL query to display the records...
LeetCode 1645. Write an SQL query to report the percentage...
LeetCode 571. Write a query to find the median of...
LeetCode 579. Write a SQL to get the cumulative sum...
LeetCode 185. Write a SQL query to find employees who...
LeetCode 615. Given two tables as below, write a query...
LeetCode 1098. Write an SQL query that reports the books...
LeetCode 614. Please write a sql query to get the...
LeetCode 1132. Write an SQL query to find the average...
LeetCode 1699. Write an SQL query to report the number...
LeetCode 177. Write a SQL query to get the nth...
LeetCode 1107. Write an SQL query that reports for every...
LeetCode 1205. Write an SQL query to find for each...
LeetCode 578. Write a sql query to identify the question...
LeetCode 184. Write a SQL query to find employees who...
LeetCode 1149. Write an SQL query to find all the...
LeetCode 1454. Write an SQL query to find the id...
LeetCode 574. Write a sql to find the name of...
LeetCode 1212. Write an SQL query that selects the team_id,...
LeetCode 178. Write a SQL query to rank scores. If...
LeetCode 1070. Write an SQL query that selects the product...
LeetCode 1341. Write the following SQL query to find the...
LeetCode 585. Write a query to print the sum of...
LeetCode 1174. Write an SQL query to find the percentage...
LeetCode 602. In social network like Facebook or Twitter, people...
LeetCode 1501. Write an SQL query to find the countries...
LeetCode 580. A university uses 2 data tables, student and...
LeetCode 1555. Our bank records all transactions in the table...
LeetCode 608. Given a table tree, id is identifier of...
LeetCode 1549. Write an SQL query to find the most...
LeetCode 612. Write a query to find the shortest distance...
LeetCode 1459. Write an SQL query to report of all...
LeetCode 1164. Write an SQL query to find the prices...
LeetCode 1264. Write an SQL query to recommend pages to...
LeetCode 1193. Write an SQL query to find for each...
LeetCode 1158. Write an SQL query to find for each...
LeetCode 570. Given the Employee table, write a SQL query...
LeetCode 1613. Write an SQL query to find the missing...
LeetCode 626. Mary is a teacher in a middle school...
LeetCode 1045. Write an SQL query for a report that...
LeetCode 1126. Write an SQL query to find all active...
LeetCode 1532. Write an SQL query to find the most...
LeetCode 1321. You are the restaurant owner and you want...
LeetCode 1077. Write an SQL query that reports the most...
LeetCode 1364. Write an SQL query to find the following...
LeetCode 1421. Write an SQL query to find the npv...
LeetCode 1204. Write an SQL query to find the person_name...