JEOPARDY GAME #2 – VALENTINE’S EDITION

Candy Queries

100

What candy is most popular on Valentine’s Day in the U.S.?

Chocolate

200

Name one chocolate brand commonly given on Valentine’s Day.

Hershey’s, Reese’s, Dove, etc.

300

What candy has messages printed on it?

Conversation Hearts

400

Which candy is heart-shaped and usually filled with chocolate?

Chocolate box (heart-shaped box)

500

Name two types of Valentine’s candy.

Any two (Chocolate, Gummies, Hearts, Lollipops, etc.)

Valentine’s History

100

Valentine’s Day is celebrated on what date?

February 14

200

Valentine’s Day is named after which saint?

Saint Valentine

300

What country started the tradition of exchanging Valentine’s cards?

England

400

What Roman festival is believed to have influenced Valentine’s Day?

Lupercalia

500

In what era did Valentine’s Day become associated with romantic love?

Middle Ages

Fun Facts

100

What color is most associated with Valentine’s Day?

Red

200

What flower is most commonly given on Valentine’s Day?

Rose

300

What symbol represents love and is often shown as a small winged baby?

Cupid

400

True or False: More cards are sent on Valentine’s Day than any other holiday except Christmas.

True

500

Approximately how many Valentine’s cards are sent each year?

About 145 million

Love & Logic

100

What shape is traditionally associated with Valentine’s Day?

Heart

200

If someone gives out 5 Valentine’s cards to 4 friends, how many total cards did they give?

20

300

If 12 students each receive 3 Valentine’s cards, how many total cards were received?

36

400

If 24 chocolates are split evenly between 6 friends, how many does each friend get?

4

500

If a class has 25 students and everyone gives one card to all other students, how many cards are given in total?

600
(25 × 24 = 600)

SQL (Valentine’s Database)Assume we have a table called Valentines:| Name | FavoriteCandy | CrushName | NumberOfCards |

100

Select all columns from the Valentines table.

SELECT * FROM Valentines;

200

Select only the names of students who like chocolate.

SELECT Name FROM Valentines
WHERE FavoriteCandy = 'Chocolate';

300

Count how many students have a crush listed.

SELECT COUNT(*) FROM Valentines
WHERE CrushName IS NOT NULL;

400

Sort students by the number of Valentine’s cards they received (most to least).

SELECT * FROM Valentines
ORDER BY NumberOfCards DESC;

500

Count how many students prefer each type of candy.

SELECT FavoriteCandy, COUNT(*)
FROM Valentines
GROUP BY FavoriteCandy;