In einer Tabelle mit den zwei Feldern Name und Getränk stehen zu jeder Person die bevorzugten Getränke.
SQL: Gib mir die Namen aller Personen, die nicht Bier angegeben haben.
Stamms (author)
Author, followers, and translators associated with this PostIt.
| Thumbnail | Username | Role | Balance | Deadline | Emailed | Closed | |
|---|---|---|---|---|---|---|---|
|
- Author | toll@oli-it.com | Author | $1.17 | - | Yes | Yes |
|
Oli | Oli@NullLogic.de | Follower | $1.00 | - | Yes | Yes |
| Flo | Flo@oli-it.com | Follower | $23.00 | - | Yes | Yes | |
|
Schabernack | Schabernack@oli-it.com | Follower | $0.00 | - | Yes | Yes |
Codes (Descriptions)
| Comment | Status | Scanned | Receivers | |
|---|---|---|---|---|
| Code von - | - | Yes | 1 | view |
Angler (Matching)
| Angler | Status | Matched Time | Read Time | |
|---|---|---|---|---|
| relational | ok 07.08.2003 21:32:19 | 2003-08-07 18:04 | - | view |
TopLabs (Answers)
| Thumbnail | TopLab | Author | Date | Reward |
|---|---|---|---|---|
| Ausschnitt zoomen SELECT Freund FROM Freunde WHERE FreundID NOT IN (SELECT FreundID FROM trinkt_gerne WHERE Getränk = "Bier" ;) ;) | Flo | 1994-08-17 | $23.81 |