English Worksheet

Percy Jackson · The Legend of Zelda · SQL Commands

Apollo, the god of music and prophecy, has a problem. His sacred database of quests is a total mess. He calls Percy for help.

"Percy," Apollo says, "I need you to SELECT all heroes from my list. But only the ones who are NOT defeated. We must ORDER BY courage — from highest to lowest."

Percy nods. "Got it. And what about the new guy, Nico?"

"INSERT him INTO the hero table. He is brave, plays bass guitar, and his favourite band is Metallica."

Later, Apollo checks the list and frowns. "Wait — Annabeth's skill level is wrong. We must UPDATE her record and SET it to maximum."

"Done," says Percy. "Anything else?"

"Yes. DELETE the monster Kronos from the quest log. He is WHERE he belongs — defeated and gone."
Übung 1
True or False? — Klick auf T oder F.
Apollo's database is perfectly organized.
Nico plays bass guitar.
Percy uses UPDATE to add Nico to the hero table.
Kronos is deleted from the quest log.
Apollo wants to ORDER BY name.
Übung 2
Fill in the blank — Klick auf ein Wort, dann auf die Lücke.
SELECT INSERT UPDATE DELETE ORDER BY WHERE
1. Apollo wants to all heroes from the list.
2. He needs to courage from highest to lowest.
3. Percy must Nico into the hero table.
4. Annabeth's skill is wrong, so they her record.
5. Kronos is d from the quest log.
Übung 3
Put the words in the right order — Klick auf die Wörter, um den Satz zu bauen.
Apollo hat ein Problem mit seiner Datenbank.
Percy fügt Nico in die Helden-Tabelle ein.
Sie löschen Kronos aus dem Quest-Log.
Princess Zelda has a new problem. Hyrule Castle is buried under paperwork. Shrines, weapons, Korok seeds — nobody knows where anything is. She calls Link.

"Link," she says, "please SELECT all shrines from the map. I want to see every single one."

Link nods silently. (He always nods silently.)

"Good. Now — ORDER BY region. Eldin first, then Lanayru, then Faron."

Then Purah runs in. "Zelda! We found a new shrine near Akkala! You must INSERT it INTO the database immediately!"

Zelda sighs. "Fine. Also — UPDATE the Boko camp records and SET the danger level to high."

"DELETE the old camp data first," she adds. "Use WHERE camp equals 'Eldin South' — otherwise we delete everything and Purah will cry."

Link looks at his inventory. Seven broken weapons. He nods — slowly — and heads out.
Übung 1
True or False? — Klick auf T oder F.
Zelda wants to SELECT all shrines from the map.
The new shrine is near Lanayru.
Purah is excited when she finds the new shrine.
Link has ten broken weapons in his inventory.
Zelda uses WHERE to avoid deleting all camp data.
Übung 2
Fill in the blank — Klick auf ein Wort, dann auf die Lücke.
SELECT INSERT UPDATE DELETE ORDER BY WHERE
1. Zelda wants to all shrines.
2. She tells Link to region.
3. Purah says they must the new shrine into the database.
4. Zelda wants to the Boko camp records.
5. She uses to avoid deleting the wrong data.
Übung 3
Put the words in the right order — Klick auf die Wörter, um den Satz zu bauen.
Zelda möchte alle Schreine von der Karte auswählen.
Purah findet einen neuen Schrein in der Nähe von Akkala.
Link hat sieben kaputte Waffen in seinem Inventar.