나는 이렇게 학습한다/Algorithm & SQL

SQL Basics: Simple IN

daco2020 2022. 6. 17. 22:00
반응형

For this challenge you need to create a SELECT statement, this SELECT statement will use an IN to check whether a department has had a sale with a price over 98.00 dollars.

departments table schema

  • id
  • name

sales table schema

  • id
  • department_id (department foreign key)
  • name
  • price
  • card_name
  • card_number
  • transaction_date

resultant table schema

  • id
  • name

 

 

Solution:

SELECT 
  id, name 
FROM 
  departments
WHERE 
  id IN (
    SELECT department_id FROM sales WHERE price > 98.00
  )

 

 

Result:

id name
1 Shoes
4 Tools
5 Home

 

 

반응형