LeetCode 175. Combine Two Tables
Description https://leetcode.com/problems/combine-two-tables/ SQL Schema Table: Person +————-+———+ | Column Name | Type | +————-+———+ | PersonId | int | | FirstName…
Category: Database
LeetCode 182. Duplicate Emails
Description https://leetcode.com/problems/duplicate-emails/ SQL Schema Write a SQL query to find all duplicate emails in a table named Person. +—-+———+ | Id…
LeetCode 1729. Find Followers Count
Description https://leetcode.com/problems/find-followers-count/ SQL Schema Table: Followers +————-+——+ | Column Name | Type | +————-+——+ | user_id | int | | follower_id…
LeetCode 627. Swap Salary
Description https://leetcode.com/problems/swap-salary/ SQL Schema Table: Salary +————-+———-+ | Column Name | Type | +————-+———-+ | id | int | | name…
LeetCode 595. Big Countries
Description https://leetcode.com/problems/big-countries/ SQL Schema There is a table World +—————–+————+————+————–+—————+ | name | continent | area | population | gdp |…
LeetCode 1173. Immediate Food Delivery I
Description https://leetcode.com/problems/immediate-food-delivery-i/ SQL Schema Table: Delivery +—————————–+———+ | Column Name | Type | +—————————–+———+ | delivery_id | int | | customer_id…
LeetCode 1068. Product Sales Analysis I
Description https://leetcode.com/problems/product-sales-analysis-i/ SQL Schema Table: Sales +————-+——-+ | Column Name | Type | +————-+——-+ | sale_id | int | | product_id…
LeetCode 1069. Product Sales Analysis II
Description https://leetcode.com/problems/product-sales-analysis-ii/ SQL Schema Table: Sales +————-+——-+ | Column Name | Type | +————-+——-+ | sale_id | int | | product_id…
LeetCode 1407. Top Travellers
Description https://leetcode.com/problems/top-travellers/ SQL Schema Table: Users +—————+———+ | Column Name | Type | +—————+———+ | id | int | | name…
LeetCode 1484. Group Sold Products By The Date
Description https://leetcode.com/problems/group-sold-products-by-the-date/ SQL Schema Table Activities: +————-+———+ | Column Name | Type | +————-+———+ | sell_date | date | | product…