-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathday-22.sql
More file actions
21 lines (18 loc) · 767 Bytes
/
day-22.sql
File metadata and controls
21 lines (18 loc) · 767 Bytes
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
-- SQL Advent Calendar - Day 22
-- Title: Penguin Sleigh Ride Filter
-- Difficulty: easy
--
-- Question:
-- The penguins are signing up for a community sleigh ride, but the organizers need a list of everyone who did NOT choose the "Evening Ride." How would you return all penguins whose selected time is not the evening slot?
--
-- The penguins are signing up for a community sleigh ride, but the organizers need a list of everyone who did NOT choose the "Evening Ride." How would you return all penguins whose selected time is not the evening slot?
--
-- Table Schema:
-- Table: sleigh_ride_signups
-- signup_id: INT
-- penguin_name: VARCHAR
-- ride_time: VARCHAR
--
-- My Solution:
select penguin_name from sleigh_ride_signups
where ride_time != 'Evening'