Perf Insights
Series

SQL Solutions

Articles in this series

Duplicate Emails

Nov 28, 20241 min read

Table: Person +-------------+---------+ | Column Name | Type | +-------------+---------+ | id | int | | email | varchar...

Duplicate Emails

Swap Salary

Aug 24, 20241 min read

Table: Salary +-------------+----------+ | Column Name | Type | +-------------+----------+ | id | int | | name | varchar | |...

Swap Salary

Combine Two Tables

Aug 4, 20242 min read

Table: Person +-------------+---------+ | Column Name | Type | +-------------+---------+ | personId | int | | lastName | varchar | |...

Combine Two Tables

Customer Placing the Largest Number of Orders

Jul 28, 20241 min read

Table: Orders +-----------------+----------+ | Column Name | Type | +-----------------+----------+ | order_number | int | |...

Customer Placing the Largest Number of Orders

Students and Examinations

Jul 28, 20242 min read

Table: Students +---------------+---------+ | Column Name | Type | +---------------+---------+ | student_id | int | | student_name |...

Students and Examinations

Employee Bonus

Jul 28, 20241 min read

Table: Employee +-------------+---------+ | Column Name | Type | +-------------+---------+ | empId | int | | name | varchar | |...

Employee Bonus