SQL Basics
This SQL command is used to display all rows and columns from a table.
What is SELECT *?
This character is the last known Airbender and the Avatar in the series.
Who is Aang?
The field that uniquely identifies each record in a table.
What is a primary key?
This popular Halloween symbol is a carved pumpkin with a face, often illuminated by a candle inside.
What is a jack-o'-lantern?
Write an SQL query to display all columns from the Authors table.
What is SELECT * FROM Authors;?
This SQL keyword removes duplicate values from the results.
What is DISTINCT?
This character is Aang’s Earthbending teacher and a member of Team Avatar known for her blindness.
Who is Toph Beifong?
his type of database is composed of interconnected tables.
What is a relational database?
In North America, children traditionally dress in costumes and go door-to-door saying this phrase to receive candy.
What is "Trick-or-treat"
Write a query to show the family names of all authors.
What is SELECT Family FROM Authors;?
This SQL command is used to sort query results in descending order.
What is ORDER BY ... DESC?
his is the name of the Fire Nation prince's sister who is initially Aang's enemy but eventually becomes his ally. (Also my dog's name)
Azula
A database table column, also known as this, represents an attribute of the entity.
What is a field?
This animal, often associated with witches, is considered a symbol of bad luck, especially if it crosses your path.
What is a black cat?
Write a query to list the barcodes of all missing items in the Items table.
What is SELECT Barcode FROM Items WHERE Status = 'Missing';?
This clause filters results to show only entries matching specific criteria.
What is WHERE?
This episode introduced the audience to the tragic love story of Avatar Kuruk and his lost love.
What is "The Puppetmaster"?
A database engine that operates without a server and is commonly used in embedded applications (Also what the web publication we are using today is based on).
What is SQLite?
The origin of Halloween can be traced back to this ancient Celtic festival, which celebrated the end of the harvest season.
What is Samhain (pronounced "sow-in")?
Write an SQL query to retrieve all titles from the Works table published in 2020.
What is SELECT Title FROM Works WHERE Date = 2020;?
This SQL function counts the number of rows that meet a condition.
What is COUNT()?
This spirit is known as the "Face Stealer" and is feared by many for its ability to take faces.
Who is Koh?
This special value indicates missing or unknown data in a table.
What is NULL?
Known as the “Pumpkin King,” this character from a 1993 Tim Burton movie decides to take over Christmas, causing spooky chaos.
Who is Jack Skellington?
Write a query to find the first and last names of authors born after 1950.
What is SELECT Family, Personal FROM Authors WHERE Birth > 1950;?