문제Rising Temperature - LeetCode  Write a solution to find all dates' id with higher temperatures compared to its previous dates (yesterday).Return the result table in any order.The result format is in the following example. Example 1:Input: Weather table:+----+------------+-------------+| id | recordDate | temperature |+----+------------+-------------+| 1 | 2015-01-01 | 10 || 2 | 2015..

문제Customer Who Visited but Did Not Make Any Transactions - LeetCode  Write a solution to find the IDs of the users who visited without making any transactionsand the number of times they made these types of visits.Return the result table sorted in any order.The result format is in the following example. Example 1:Input: Visits+----------+-------------+| visit_id | customer_id |+----------+------..

문제Product Sales Analysis I - LeetCode  Write a solution to report the product_name, year, and price for each sale_id in the Sales table.Return the resulting table in any order.The result format is in the following example. Example 1:Input: Sales table:+---------+------------+------+----------+-------+| sale_id | product_id | year | quantity | price |+---------+------------+------+----------+----..

문제Replace Employee ID With The Unique Identifier - LeetCode Write a solution to show the unique ID of each user,If a user does not have a unique ID replace just show null.Return the result table in any order.The result format is in the following example. Example 1:Input: Employees table:+----+----------+| id | name |+----+----------+| 1 | Alice || 7 | Bob || 11 | Meir || 90 | W..

문제Invalid Tweets - LeetCode  Write a solution to find the IDs of the invalid tweets.The tweet is invalid if the number of characters used in the content of the tweet is strictly greater than 15.Return the result table in any order.The result format is in the following example. Example 1:Input: Tweets table:+----------+-----------------------------------+| tweet_id | content ..

문제Article Views I - LeetCode  Write a solution to find all the authors that viewed at least one of their own articles.Return the result table sorted by id in ascending order.The result format is in the following example. Example 1:Input: Views table:+------------+-----------+-----------+------------+| article_id | author_id | viewer_id | view_date |+------------+-----------+-----------+--------..