1.
SELECT Username
FROM Accounts
ORDER BY Username ASC;
2.
SELECT EmailFROM AccountsWHERE Adresse ILIKE '%Berlin%'ORDER BY Email DESC;
3.
SELECT Title, UploadDatum
FROM Videos
WHERE UploadDatum >= DATE '2025-10-01'ORDER BY UploadDatum ASC;
4.
SELECT KommentarTextFROM KommentareWHERE ErstellungsDatum::date = DATE '2025-10-06';
5.
SELECT Title, BeschreibungFROM VideosWHERE CHAR_LENGTH(Beschreibung) > 20ORDER BY Title ASC;
6.
SELECT ChannelNameFROM ChannelsWHERE ChannelBeschreibung ILIKE '%Reise%'ORDER BY ChannelName ASC;
7.
SELECT Username, LebensalterFROM AccountsWHERE Lebensalter >= 20ORDER BY Lebensalter DESC;
8.
SELECT TitleFROM VideosWHERE Title LIKE 'A%'ORDER BY Title ASC;
9.
SELECT KommentarText, ErstellungsDatumFROM KommentareWHERE VideoID = 6;
10.
SELECT ChannelName, ChannelBeschreibungFROM ChannelsWHERE ChannelName LIKE 'Finn%'ORDER BY ChannelName ASC;
11.
SELECT KommentarID, VideoID, AccountID, KommentarText, Rating, ErstellungsDatumFROM KommentareWHERE Rating <= 2ORDER BY Rating ASC, ErstellungsDatum DESC;
12.
SELECT KommentarID, Rating, (Rating::numeric / 5.0) AS NormalizedRatingFROM Kommentare;
13.
SELECT KommentarID, AccountID, KommentarText, Rating, ErstellungsDatumFROM KommentareWHERE Rating = 1AND CHAR_LENGTH(KommentarText) < 15ORDER BY ErstellungsDatum DESC;
14.
SELECT KommentarID,Rating,(Rating::numeric / 5.0) AS Normalized,POWER((Rating::numeric / 5.0), 2) AS BoostedFROM Kommentare;