[1873_EASY] Calculate Special Bonus
·
SQL/LeetCode
Table: Employees +-------------+---------+ | Column Name | Type | +-------------+---------+ | employee_id | int | | name | varchar | | salary | int | +-------------+---------+ employee_id is the primary key for this table. Each row of this table indicates the employee ID, employee name, and salary. Write an SQL query to calculate the bonus of each employee. The bonus of an employee is 100% of th..
[1853#_EASY] Convert Date Format
·
SQL/LeetCode
보호되어 있는 글입니다.
[1308#_MEDIUM] Running Total for Different Genders
·
SQL/LeetCode
보호되어 있는 글입니다.
[1285#_MEDIUM] Find the Start and End Number of Continuous Ranges
·
SQL/LeetCode
보호되어 있는 글입니다.
[1821#_EASY] Find Customers With Positive Revenue this Year
·
SQL/LeetCode
보호되어 있는 글입니다.
[1809#_EASY] Ad-Free Sessions
·
SQL/LeetCode
보호되어 있는 글입니다.
[1795_EASY] Rearrange Products Table
·
SQL/LeetCode
Table: Products +-------------+---------+ | Column Name | Type | +-------------+---------+ | product_id | int | | store1 | int | | store2 | int | | store3 | int | +-------------+---------+ product_id is the primary key for this table. Each row in this table indicates the product's price in 3 different stores: store1, store2, and store3. If the product is not available in a store, the price will ..
[1789#_EASY] Primary Department for Each Employee
·
SQL/LeetCode
보호되어 있는 글입니다.