-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathday-16.sql
More file actions
22 lines (19 loc) · 768 Bytes
/
day-16.sql
File metadata and controls
22 lines (19 loc) · 768 Bytes
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
-- SQL Advent Calendar - Day 16
-- Title: Cozy Snow Day Tasks
-- Difficulty: easy
--
-- Question:
-- It's a snow day, and Buddy is deciding which tasks he can do from under a blanket. Can you find all tasks that are either marked as 'Work From Home' or 'Low Priority' so he can stay cozy and productive?
--
-- It's a snow day, and Buddy is deciding which tasks he can do from under a blanket. Can you find all tasks that are either marked as 'Work From Home' or 'Low Priority' so he can stay cozy and productive?
--
-- Table Schema:
-- Table: daily_tasks
-- task_id: INTEGER
-- task_name: VARCHAR
-- task_type: VARCHAR
-- priority: VARCHAR
--
-- My Solution:
select task_name FROM daily_tasks
where task_type ='Work From Home' or priority = 'Low Priority';