10000 1st solution · dana3601/Leetcode-Problems@9d88cab · GitHub
[go: up one dir, main page]
Skip to content

Commit 9d88cab

Browse files
Qian-Yu-2020Qian-Yu-2020
committed
1st solution
1 parent eedc412 commit 9d88cab

9 files changed

+82
-0
lines changed

‎.DS_Store

18 KB
Binary file not shown.

‎Order and Deliver/# 1068. Product Sales Analysis I.sql

Lines changed: 7 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,7 @@
1+
# 1068. Product Sales Analysis I
2+
3+
# Reports all product names of the products in the Sales table along with their selling year and price
4+
5+
SELECT p.product_name, s.year, s.price
6+
FROM Sales s JOIN Product p USING(product_id)
7+
;

‎Order and Deliver/# 1069. Product Sales Analysis II.sql

Lines changed: 7 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,7 @@
1+
# 1069. Product Sales Analysis II
2+
3+
# Reports the total quantity sold for every product id
4+
SELECT product_id, SUM(quantity) AS total_quantity
5+
FROM Sales
6+
GROUP BY product_id
7+
;

‎Order and Deliver/# 1082. Sales Analysis I.sql

Lines changed: 14 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,14 @@
1+
# 1082. Sales Analysis I
2+
3+
# Reports the best seller by total sales price, If there is a tie, report them all.
4+
5+
SELECT seller_id
6+
FROM Sales
7+
GROUP BY seller_id
8+
HAVING SUM(price) = (
9+
SELECT SUM(price)
10+
FROM Sales
11+
GROUP BY seller_id
12+
ORDER BY SUM(price) DESC
13+
LIMIT 1)
14+
;

‎Others /# 1050. Actors and Directors Who Cooperated.sql

Lines changed: 9 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,9 @@
1+
# 1050. Actors and Directors Who Cooperated At Least Three Times
2+
3+
# Report that provides the pairs (actor_id, director_id) where the actor have cooperated with the director at least 3 times
4+
5+
SELECT actor_id, director_id
6+
FROM ActorDirector
7+
GROUP BY 1, 2
8+
HAVING COUNT(timestamp) >2
9+
;

‎Others /# 619. Biggest Single Number.sql

Lines changed: 13 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,13 @@
1+
# 619. Biggest Single Number
2+
3+
# Write a SQL query to find the biggest number, which only appears once
4+
5+
SELECT (
6+
SELECT num
7+
FROM my_numbers
8+
GROUP BY num
9+
HAVING COUNT(*) = 1
10+
ORDER BY num DESC
11+
LIMIT 1
12+
) as num
13+
;

‎Others /# 620. Not Boring Movies.sql

Lines changed: 10 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,10 @@
1+
# 620. Not Boring Movies
2+
3+
# Output movies with an odd numbered ID and a description that is not 'boring'. Order the result by rating
4+
5+
SELECT *
6+
FROM cinema
7+
WHERE description != "boring"
8+
AND id%2 = 1
9+
ORDER BY rating DESC
10+
;

‎Schools and Organizations/# 1075. Project Employees I

Lines changed: 7 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,7 @@
1+
# 1075. Project Employees I
2+
3+
# Reports the average experience years of all the employees for each project, rounded to 2 digits
4+
5+
SELECT project_id, ROUND(AVG(experience_years),2) AS average_years
6+
FROM Project JOIN Employee USING(employee_id)
7+
GROUP BY project_id

‎Schools and Organizations/# 1076. Project Employees II.sql

Lines changed: 15 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,15 @@
1+
# 1076. Project Employees II
2+
3+
# Reports all the projects that have the most employees
4+
5+
SELECT project_id
6+
FROM Project
7+
GROUP BY project_id
8+
HAVING COUNT(employee_id) = (
9+
SELECT COUNT(employee_id)
10+
FROM Project
11+
GROUP BY project_id
12+
ORDER BY COUNT(employee_id) DESC
13+
LIMIT 1)
14+
;
15+

0 commit comments

Comments
 (0)
0