SQL

This Leetcode problem User Activity for the Past 30 Days II LeetCode Solution is done in SQL. List of all LeetCode Solution User Activity for the Past 30 Days II 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 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