Pastebin

New Paste Add Image

SELECT Nazwa, Cena, grupa
FROM Produkty
WHERE Nazwa LIKE 'M%' OR Nazwa LIKE 'P%';

SELECT Imie, Nazwisko, Email
FROM Klienci
WHERE (Miasto = 'Warszawa' OR TRIM(Miasto) = 'Lublin')
  AND DataUrodzenia > '2000-01-01';

SELECT Imie, Nazwisko, Stanowisko, Pensja
FROM Pracownicy
ORDER BY Pensja DESC, Nazwisko ASC;

SELECT 
    ROUND(AVG(Cena), 2) AS SredniaCena,
    MAX(Cena) AS NajwyzszaCena,
    MIN(Cena) AS NajnizszaCena,
    COUNT(*) AS LiczbaProduktow
FROM Produkty;

SELECT 
    Miasto,
    COUNT(*) AS LiczbaDostawcow
FROM Dostawcy
GROUP BY Miasto
ORDER BY LiczbaDostawcow DESC;

SELECT 
    grupa,
    ROUND(AVG(Cena), 2) AS SredniaCena
FROM Produkty
GROUP BY grupa
HAVING AVG(Cena) > 5.00
ORDER BY SredniaCena DESC;

SELECT 
    Nazwa,
    Cena,
    DataDodania,
    YEAR(DataDodania) AS Rok
FROM Produkty
WHERE YEAR(DataDodania) BETWEEN 2000 AND 2020
ORDER BY Rok ASC;

SELECT 
    Imie,
    Nazwisko,
    DataUrodzenia,
    TIMESTAMPDIFF(YEAR, DataUrodzenia, CURDATE()) AS Wiek
FROM Klienci
HAVING Wiek > 10;

Settings

Title : [Optional]

Paste Folder : [Optional]

Syntax : [Optional]

Expiration : [Optional]

Status : [Optional]

Password : [Optional]

Description: [Optional]

Tags: [Optional]

Encrypt Paste (?)

You are currently not logged in, this means you can not edit or delete anything you paste. Sign Up or Login

Settings

Site Languages