LeetCode 1517. Find Users With Valid E-Mails
Description https://leetcode.com/problems/find-users-with-valid-e-mails/ SQL Schema Table: Users +—————+———+ | Column Name | Type | +—————+———+ | user_id | int | | name…
Category: Database
LeetCode 1327. List the Products Ordered in a Period
Description https://leetcode.com/problems/list-the-products-ordered-in-a-period/ SQL Schema Table: Products +——————+———+ | Column Name | Type | +——————+———+ | product_id | int | | product_name…
LeetCode 1777. Product’s Price for Each Store
Description https://leetcode.com/problems/products-price-for-each-store/ SQL Schema Table: Products +————-+———+ | Column Name | Type | +————-+———+ | product_id | int | | store…
LeetCode 1853. Convert Date Format
Description https://leetcode.com/problems/convert-date-format/ SQL Schema Table: Days +————-+——+ | Column Name | Type | +————-+——+ | day | date | +————-+——+ day…
LeetCode 1179. Reformat Department Table
Description https://leetcode.com/problems/reformat-department-table/ SQL Schema Table: Department +—————+———+ | Column Name | Type | +—————+———+ | id | int | | revenue…
LeetCode 1148. Article Views I
Description https://leetcode.com/problems/article-views-i/ SQL Schema Table: Views +—————+———+ | Column Name | Type | +—————+———+ | article_id | int | | author_id…
LeetCode 610. Triangle Judgement
Description https://leetcode.com/problems/triangle-judgement/ SQL Schema A pupil Tim gets homework to identify whether three line segments could possibly form a triangle.However,…
LeetCode 596. Classes More Than 5 Students
Description https://leetcode.com/problems/classes-more-than-5-students/ SQL Schema There is a table courses with columns: student and class Please list out all classes which have more than or equal…
LeetCode 1667. Fix Names in a Table
Description https://leetcode.com/problems/fix-names-in-a-table/ SQL Schema Table: Users +—————-+———+ | Column Name | Type | +—————-+———+ | user_id | int | | name…
LeetCode 1821. Find Customers With Positive Revenue this Year
Description https://leetcode.com/problems/find-customers-with-positive-revenue-this-year/ SQL Schema Table: Customers +————–+——+ | Column Name | Type | +————–+——+ | customer_id | int | | year…