개발일기 개발일기

DataBase/LeetCode

• [Leet Code] - 183. Customers Who Never Order

  DataBase/LeetCode 2024. 10. 28. 21:59

  Table: Customers+-------------+---------+| Column Name | Type |+-------------+---------+| id | int || name | varchar |+-------------+---------+id is the primary key (column with unique values) for this table.Each row of this table indicates the ID and name of a customer. Table: Orders+-------------+------+| Column Name | Type |+-------------+------+| id | int || ..

  Read More
• LeetCode - 1179. Reformat Department Table

  DataBase/LeetCode 2024. 10. 1. 23:26

  Table: Department+-------------+---------+| Column Name | Type |+-------------+---------+| id | int || revenue | int || month | varchar |+-------------+---------+In SQL,(id, month) is the primary key of this table.The table has information about the revenue of each department per month.The month has values in ["Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","O..

  Read More