Tagged in

Sql

Data Science & LeetCode for Kindergarten

Easy Peasy Data Science & LeetCode

More information

Followers

Elsewhere

More, on Medium

Sharko Shen in Data Science & LeetCode for Kindergarten

Mar 27, 2023

1084. Sales Analysis III

Table: Product

+--------------+---------+
| Column Name  | Type    |
+--------------+---------+
| product_id   | int     |
| product_name | varchar |
| unit_price   | int     |
+--------------+---------+
product_id is the primary key of this table.
Each row…

Sharko Shen in Data Science & LeetCode for Kindergarten

Mar 27, 2023

1587. Bank Account Summary II

Table: Users

+--------------+---------+
| Column Name  | Type    |
+--------------+---------+
| account      | int     |
| name         | varchar |
+--------------+---------+
account is the primary key for this table.
Each row of this table contains…

Sharko Shen in Data Science & LeetCode for Kindergarten

Mar 27, 2023

1050. Actors and Directors Who Cooperated At Least Three Times

Table: ActorDirector

+-------------+---------+
| Column Name | Type    |
+-------------+---------+
| actor_id    | int     |
| director_id | int     |
| timestamp   | int     |…

Sharko Shen in Data Science & LeetCode for Kindergarten

Mar 26, 2023

182. Duplicate Emails

Table: Person

+-------------+---------+
| Column Name | Type    |
+-------------+---------+
| id          | int     |
| email       | varchar |
+-------------+---------+
id is the primary key column for this table.
Each row of this table contains an email. The…

Sharko Shen in Data Science & LeetCode for Kindergarten

Mar 26, 2023

1158. Market Analysis I

Table: Users

+----------------+---------+
| Column Name    | Type    |
+----------------+---------+
| user_id        | int     |
| join_date      | date    |
| favorite_brand | varchar |
+----------------+---------+
user_id is the primary key of this table…

Sharko Shen in Data Science & LeetCode for Kindergarten

Mar 26, 2023

1407. Top Travellers

Table: Users

+---------------+---------+
| Column Name   | Type    |
+---------------+---------+
| id            | int     |
| name          | varchar |
+---------------+---------+
id is the primary key for this table.
name is the name of the user.

Sharko Shen in Data Science & LeetCode for Kindergarten

Mar 23, 2023

1741. Find Total Time Spent by Each Employee

Table: Employees

+-------------+------+
| Column Name | Type |
+-------------+------+
| emp_id      | int  |
| event_day   | date |
| in_time     | int  |
| out_time    | int  |
+-------------+------+
(emp_id, event_day…

Sharko Shen in Data Science & LeetCode for Kindergarten

Mar 23, 2023

1890. The Latest Login in 2020

Table: Logins

+----------------+----------+
| Column Name    | Type     |
+----------------+----------+
| user_id        | int      |
| time_stamp     | datetime |
+----------------+----------+
(user_id, time_stamp) is the primary key for this table…

Sharko Shen in Data Science & LeetCode for Kindergarten

Mar 23, 2023

511. Game Play Analysis I

Table: Activity

+--------------+---------+
| Column Name  | Type    |
+--------------+---------+
| player_id    | int     |
| device_id    | int     |
| event_date   | date    |
| games_played | int     |
+--------------+---------+
(player_id, event_date) is…

Sharko Shen in Data Science & LeetCode for Kindergarten

Mar 23, 2023

586. Customer Placing the Largest Number of Orders

Table: Orders

+-----------------+----------+
| Column Name     | Type     |
+-----------------+----------+
| order_number    | int      |
| customer_number | int      |
+-----------------+----------+
order_number is…