Skip to content

Latest commit

 

History

History
30 lines (24 loc) · 944 Bytes

SQL-Basics-Simple-WITH.md

File metadata and controls

30 lines (24 loc) · 944 Bytes

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 90.00 dollars BUT the sql MUST use the WITH statement which will be used to select all columns from sales where the price is greater than 90.00, you must call this sub-query special_sales.

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

NOTE: Your solution should use pure SQL. Ruby is used within the test cases to do the actual testing.

使用 WITH 創建一個 special_sales 查詢，並將其用於 IN

-- Create your SELECT statement here
WITH  special_sales AS (
  SELECT department_id FROM sales WHERE price > 90.00
)


SELECT id, name FROM departments WHERE id IN ( SELECT * FROM special_sales)