MySql

This Leetcode problem Sales Person LeetCode Solution is done in SQL. List of all LeetCode Solution Sales Person LeetCode Solution Problem Statement Column Name Type sales_id int name varchar salary int commission_rate int hire_date date Table: SalesPerson sales_id is the primary key (column with unique values) for this table. Each row of this table indicates the […]

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