St. Paddy's Basics
What color is most associated with St. Patrick's Day?
Green
What do leprechauns supposedly hide at the end of a rainbow?
A pot of gold
What ocean is to the west of Ireland?
The Atlantic Ocean
What do people say you'll get if you're not wearing green on St. Patrick's Day?
Pinched
Write a query to select ALL columns from the Leprechauns table
SELECT * FROM Leprechauns;
What country does St. Patrick's Day originate from?
Ireland
According to legend, what did St. Patrick drive out of Ireland?
Snakes
What is the most popular St. Patrick's Day parade city in the USA?
New York City / Chicago
What breakfast cereal features a leprechaun named Lucky?
Lucky Charms
Write a query to find all leprechauns whose FavoriteColor is 'Green'
SELECT * FROM Leprechauns WHERE FavoriteColor = 'Green';
What is the name of the small magical creature associated with St. Patrick's Day?
Leprechaun
How many leaves does a lucky clover have?
4
What color does Chicago dye its river every St. Patrick's Day?
Green
What does "Erin Go Bragh" mean?
Ireland Forever
Write a query to show all leprechaun Names ordered by PotOfGold from highest to lowest
SELECT Name FROM Leprechauns ORDER BY PotOfGold DESC;
What plant is the symbol of Ireland and St. Patrick's Day?
Shamrock / Clover
What is a leprechaun's traditional job or trade?
Shoemaker / Cobbler
What famous Irish dance style features stiff upper bodies and fast footwork?
Riverdance / Irish Step Dancing
What famous UFC fighter is from Ireland?
Connor McGregor
Write a query to find leprechauns with more than 3 wishes AND whose FavoriteColor is 'Green'
SELECT * FROM Leprechauns WHERE NumberOfWishes > 3 AND FavoriteColor = 'Green';
What is the capital city of Ireland?
Dublin
What is the name of the mythical fairy mound where leprechauns are said to live in Irish folklore?
Sídhe (Shee)
What is the traditional Irish instrument often associated with Irish folk music?
Fiddle / Harp / Tin Whistle
What drink does McDonald's sell for St Patrick's Day?
Shamrock Shake
Write a query to find leprechauns where PotOfGold IS missing (NULL), ordered by Name A–Z
SELECT * FROM Leprechauns WHERE PotOfGold IS NULL ORDER BY Name ASC;