MySql

Employees Earning More Than Their Managers LeetCode Solution

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 […]

Employees Earning More Than Their Managers LeetCode Solution Read More »

Leetcode Solution

Project Employees I LeetCode Solution

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

Project Employees I LeetCode Solution Read More »

Leetcode Solution

Duplicate Emails LeetCode Solution

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

Duplicate Emails LeetCode Solution Read More »

Leetcode Solution

Product Sales Analysis III LeetCode Solution

This Leetcode problem Product Sales Analysis III LeetCode Solution is done in SQL. List of all LeetCode Solution Product Sales Analysis III 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.

Product Sales Analysis III LeetCode Solution Read More »

Leetcode Solution

Second Highest Salary LeetCode Solution

This Leetcode problem Second Highest Salary LeetCode Solution is done in SQL. List of all LeetCode Solution Second Highest Salary LeetCode Solution Problem Statement Column Name Type id int salary int Table: Employee id is the primary key (column with unique values) for this table. Each row of this table contains information about the salary of

Second Highest Salary LeetCode Solution Read More »

Leetcode Solution

Product Sales Analysis II LeetCode Solution

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.

Product Sales Analysis II LeetCode Solution Read More »

Leetcode Solution

Customers Who Never Order LeetCode Solution

This Leetcode problem Customers Who Never Order LeetCode Solution is done in SQL. List of all LeetCode Solution Customers Who Never Order LeetCode Solution Problem Statement Column Name Type id int name varchar Table: Customers id is the primary key (column with unique values) for this table. Each row of this table indicates the ID and

Customers Who Never Order LeetCode Solution Read More »

Leetcode Solution

Actors and Directors Who Cooperated At Least Three Times LeetCode Solution

This Leetcode problem Actors and Directors Who Cooperated At Least Three Times LeetCode Solution is done in SQL. List of all LeetCode Solution Actors and Directors Who Cooperated At Least Three Times LeetCode Solution Problem Statement Column Name Type actor_id int director_id int timestamp int Table: ActorDirector timestamp is the primary key (column with unique values)

Actors and Directors Who Cooperated At Least Three Times LeetCode Solution Read More »

Leetcode Solution

Game Play Analysis I LeetCode Solution

This Leetcode problem Game Play Analysis I LeetCode Solution is done in SQL. List of all LeetCode Solution Game Play Analysis I LeetCode Solution Problem Statement Column Name Type player_id int device_id int event_date date games_played int Table: Activity (player_id, event_date) is the primary key (combination of columns with unique values) of this table. This table

Game Play Analysis I LeetCode Solution Read More »

Leetcode Solution

Customers Who Bought All Products LeetCode Solution

This Leetcode problem Customers Who Bought All Products LeetCode Solution is done in SQL. List of all LeetCode Solution Customers Who Bought All Products LeetCode Solution Problem Statement Column Name Type customer_id int product_key int Table: Customer This table may contain duplicates rows. customer_id is not NULL. product_key is a foreign key (reference column) to Product

Customers Who Bought All Products LeetCode Solution Read More »

Leetcode Solution

Game Play Analysis II LeetCode Solution

This Leetcode problem Game Play Analysis II LeetCode Solution is done in SQL. List of all LeetCode Solution Game Play Analysis II LeetCode Solution Problem Statement Column Name Type player_id int device_id int event_date date games_played int Table: Activity (player_id, event_date) is the primary key of this table. This table shows the activity of players

Game Play Analysis II LeetCode Solution Read More »

Leetcode Solution

Rising Temperature LeetCode Solution

This Leetcode problem Rising Temperature LeetCode Solution is done in SQL. List of all LeetCode Solution Rising Temperature LeetCode Solution Problem Statement Column Name Type id int recordDate date temperature int Table: Weather id is the column with unique values for this table. There are no different rows with the same recordDate. This table contains information

Rising Temperature LeetCode Solution Read More »

Leetcode Solution

Combine Two Tables LeetCode Solution

This Leetcode problem Combine Two Tables LeetCode Solution is done in SQL. List of all LeetCode Solution Combine Two Tables LeetCode Solution Problem Statement Write a solution to report the first name, last name, city, and state of each person in the Person table. If the address of a personId is not present in the Address table, report null instead. Return the result

Combine Two Tables LeetCode Solution Read More »

Leetcode Solution
Scroll to Top