|
1
2
3
4
5
6
7
8
|
# Write your MySQL query statement below
select p.product_id, p.product_name
from Sales s
left join Product p
on p.product_id = s.product_id
group by s.product_id
having min(s.sale_date)>='2019-01-01'
and max(s.sale_date)<='2019-03-31'
|
cs |
반응형
'SQL' 카테고리의 다른 글
| hackerrank Occupations (0) | 2022.11.13 |
|---|---|
| leetcode 1050. Actors and Directors Who Cooperated At Least Three Times (0) | 2022.07.26 |
| leetcode 607. Sales Person (0) | 2022.07.18 |
| leetcode 1527. Patients With a Condition (0) | 2022.07.18 |
| leetcode 1729. Find Followers Count (0) | 2022.07.18 |
댓글