Easy

This Leetcode problem Consecutive Available Seats LeetCode Solution is done in SQL. List of all LeetCode Solution Consecutive Available Seats LeetCode Solution Problem Statement Several friends at a cinema ticket office would like to reserve consecutive available seats.Write a query for all the consecutive available seats ordered by the seat_id using the following cinema table. […]

This Leetcode problem Reformat Department Table LeetCode Solution is done in SQL. List of all LeetCode Solution Reformat Department Table LeetCode Solution Problem Statement Column Name Type id int revenue int month varchar Table: Department In SQL,(id, month) is the primary key of this table. The table has information about the revenue of each department per

This Leetcode problem Immediate Food Delivery I LeetCode Solution is done in SQL. List of all LeetCode Solution Immediate Food Delivery I LeetCode Solution Problem Statement Column Name Type delivery_id int customer_id int order_date date customer_pref_delivery_date date Table: Delivery delivery_id is the primary key of this table.The table holds information about food delivery to customers

This Leetcode problem Friend Requests I Overall Acceptance Rate LeetCode Solution is done in SQL. List of all LeetCode Solution Friend Requests I Overall Acceptance Rate LeetCode Solution Problem Statement In social network like Facebook or Twitter, people send friend requests and accept others’ requests as well. Now given two tables as below: sender_id send_to_id

This Leetcode problem Article Views I LeetCode Solution is done in SQL. List of all LeetCode Solution Article Views I LeetCode Solution Problem Statement Column Name Type article_id int author_id int viewer_id int view_date date Table: Views There is no primary key (column with unique values) for this table, the table may have duplicate rows. Each

This Leetcode problem Classes More Than 5 Students LeetCode Solution is done in SQL. List of all LeetCode Solution Classes More Than 5 Students LeetCode Solution Problem Statement Column Name Type student varchar class varchar Table: Courses (student, class) is the primary key (combination of columns with unique values) for this table. Each row of this

This Leetcode problem Reported Posts LeetCode Solution is done in SQL. List of all LeetCode Solution Reported Posts LeetCode Solution Problem Statement Column Name Type user_id int post_id int action_date date action enum extra varchar Table: Actions There is no primary key for this table, it may have duplicate rows.The action column is an ENUM

This Leetcode problem Big Countries LeetCode Solution is done in SQL. List of all LeetCode Solution Big Countries LeetCode Solution Problem Statement Column Name Type name varchar continent varchar area int population int gdp bigint Table: World name is the primary key (column with unique values) for this table. Each row of this table gives information

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