SQL

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 Delete Duplicate Emails LeetCode Solution is done in SQL. List of all LeetCode Solution Delete 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

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

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.

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

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)

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

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

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

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