LeetCode 1445. Apples & Oranges
Description https://leetcode.com/problems/apples-oranges/ SQL Schema Table: Sales +—————+———+ | Column Name | Type | +—————+———+ | sale_date | date | | fruit…
Category: Database
LeetCode 1757. Recyclable and Low Fat Products
Description https://leetcode.com/problems/recyclable-and-low-fat-products/ SQL Schema Table: Products +————-+———+ | Column Name | Type | +————-+———+ | product_id | int | | low_fats…
LeetCode 1303. Find the Team Size
Description https://leetcode.com/problems/find-the-team-size/ SQL Schema Table: Employee +—————+———+ | Column Name | Type | +—————+———+ | employee_id | int | | team_id…
LeetCode 1587. Bank Account Summary II
Description https://leetcode.com/problems/bank-account-summary-ii/ SQL Schema Table: Users +————–+———+ | Column Name | Type | +————–+———+ | account | int | | name…
LeetCode 1378. Replace Employee ID With The Unique Identifier
Description https://leetcode.com/problems/replace-employee-id-with-the-unique-identifier/ SQL Schema Table: Employees +—————+———+ | Column Name | Type | +—————+———+ | id | int | | name…
LeetCode 1581. Customer Who Visited but Did Not Make Any Transactions
Description https://leetcode.com/problems/customer-who-visited-but-did-not-make-any-transactions/ SQL Schema Table: Visits +————-+———+ | Column Name | Type | +————-+———+ | visit_id | int | | customer_id…
LeetCode 1350. Students With Invalid Departments
Description https://leetcode.com/problems/students-with-invalid-departments/ SQL Schema Table: Departments +—————+———+ | Column Name | Type | +—————+———+ | id | int | | name…
LeetCode 1693. Daily Leads and Partners
Description https://leetcode.com/problems/daily-leads-and-partners/ SQL Schema Table: DailySales +————-+———+ | Column Name | Type | +————-+———+ | date_id | date | | make_name…
LeetCode 1741. Find Total Time Spent by Each Employee
Description https://leetcode.com/problems/find-total-time-spent-by-each-employee/ SQL Schema Table: Employees +————-+——+ | Column Name | Type | +————-+——+ | emp_id | int | | event_day…
LeetCode 1683. Invalid Tweets
Description https://leetcode.com/problems/invalid-tweets/ Table: Tweets +—————-+———+ | Column Name | Type | +—————-+———+ | tweet_id | int | | content | varchar…