Easy

This Leetcode problem Customer Placing the Largest Number of Orders LeetCode Solution is done in SQL. List of all LeetCode Solution Customer Placing the Largest Number of Orders LeetCode Solution Problem Statement Column Name Type order_number int customer_number int Table: Orders order_number is the primary key (column with unique values) for this table. This table contains […]

This Leetcode problem User Activity for the Past 30 Days I LeetCode Solution is done in SQL. List of all LeetCode Solution User Activity for the Past 30 Days I LeetCode Solution Problem Statement Column Name Type user_id int session_id int activity_date date activity_type enum Table: Activity This table may have duplicate rows. The activity_type column

This Leetcode problem Find Customer Referee LeetCode Solution is done in SQL. List of all LeetCode Solution Find Customer Referee LeetCode Solution Problem Statement Column Name Type id int name varchar referee_id int Table: Customer In SQL, id is the primary key column for this table. Each row of this table indicates the id of a

This Leetcode problem Sales Analysis III LeetCode Solution is done in SQL. List of all LeetCode Solution Sales Analysis III LeetCode Solution Problem Statement Column Name Type product_id int product_name varchar unit_price int Table: Product product_id is the primary key (column with unique values) of this table. Each row of this table indicates the name

This Leetcode problem Employee Bonus LeetCode Solution is done in SQL. List of all LeetCode Solution Employee Bonus LeetCode Solution Problem Statement Column Name Type empId int name varchar supervisor int salary int Table: Employee empId is the column with unique values for this table. Each row of this table indicates the name and the ID

This Leetcode problem Sales Analysis II LeetCode Solution is done in SQL. List of all LeetCode Solution Sales Analysis II LeetCode Solution Problem Statement Column Name Type product_id int product_name varchar unit_price int Table: Product product_id is the primary key (column with unique values) of this table. Each row of this table indicates the name

This Leetcode problem Sales Analysis I LeetCode Solution is done in SQL. List of all LeetCode Solution Sales Analysis I LeetCode Solution Problem Statement Column Name Type product_id int product_name varchar unit_price int Table: Product product_id is the primary key (column with unique values) of this table. Each row of this table indicates the name

This Leetcode problem Project Employees II LeetCode Solution is done in SQL. List of all LeetCode Solution Project Employees II LeetCode Solution Problem Statement Column Name Type project_id int employee_id int Table: Project (project_id, employee_id) is the primary key of this table. employee_id is a foreign key to Employee table. Each row of this table indicates

This Leetcode problem Swap Salary LeetCode Solution is done in SQL. List of all LeetCode Solution Swap Salary LeetCode Solution Problem Statement Column Name Type id int name varchar sex ENUM salary int Table: Salary id is the primary key (column with unique values) for this table. The sex column is ENUM (category) value of type

This Leetcode problem Employees Earning More Than Their Managers LeetCode Solution is done in SQL. List of all LeetCode Solution Employees Earning More Than Their Managers LeetCode Solution Problem Statement Column Name Type id int name varchar salary int managerId int Table: Employee id is the primary key (column with unique values) for this table. Each

This Leetcode problem Project Employees I LeetCode Solution is done in SQL. List of all LeetCode Solution Project Employees I LeetCode Solution Problem Statement Column Name Type project_id int employee_id int Table: Project (project_id, employee_id) is the primary key of this table. employee_id is a foreign key to Employee table. Each row of this table indicates

This Leetcode problem Duplicate Emails LeetCode Solution is done in SQL. List of all LeetCode Solution Duplicate Emails LeetCode Solution Problem Statement Column Name Type id int email varchar Table: Person id is the primary key (column with unique values) for this table. Each row of this table contains an email. The emails will not contain

This Leetcode problem Product Sales Analysis II LeetCode Solution is done in SQL. List of all LeetCode Solution Product Sales Analysis II LeetCode Solution Problem Statement Column Name Type sale_id int product_id int year int quantity int price int Table: Sales (sale_id, year) is the primary key (combination of columns with unique values) of this table.