MariaDB [bazaLS]> SELECT * FROM klienci;
+----------+----------+-----------+---------------+-----+
| imie     | nazwisko | telefon   | email         | kID |
+----------+----------+-----------+---------------+-----+
| Jan      | Kowalski | 618666666 | jkowal@o2.pl  |   1 |
| Jacek    | Nowak    |      NULL | NULL          |   2 |
| Jacek    | Nowak    | 618546234 | jnowak@o2.pl  |   3 |
| Marek    | Wielki   | 618456123 | mwielki@o2.pl |   4 |
| Jan      | Malwa    | 618453124 | jmalwa@o2.pl  |   5 |
| Robert   | Konrad   | 618431567 | rkonrad@o2.pl |   6 |
| Hubert   | Mocny    | 618561263 | hmocny@o2.pl  |   7 |
| Grzegorz | Wolny    | 618317538 | gwolny@o2.pl  |   8 |
+----------+----------+-----------+---------------+-----+
8 rows in set (0.00 sec)

MariaDB [bazaLS]> GRANT ALL PRIVILEGES ON bazals.* TO 'uczenLS'@'localhost' IDENTIFIED BY 'hasloLS';
Query OK, 0 rows affected (0.00 sec)

MariaDB [bazaLS]> SHOW GRANTS FOR uczenLS@localhost;
+----------------------------------------------------------------------------------------------------------------+
| Grants for uczenLS@localhost                                                                                   |
+----------------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'uczenLS'@'localhost' IDENTIFIED BY PASSWORD '*E81630CAA76524F0C15B6C5A78251D3E1657CB46' |
| GRANT ALL PRIVILEGES ON `bazals`.* TO 'uczenLS'@'localhost'                                                    |
+----------------------------------------------------------------------------------------------------------------+
2 rows in set (0.00 sec)

MariaDB [bazaLS]> SELECT imie, nazwisko, email FROM klienci WHERE nazwisko='Nowak';
+-------+----------+--------------+
| imie  | nazwisko | email        |
+-------+----------+--------------+
| Jacek | Nowak    | NULL         |
| Jacek | Nowak    | jnowak@o2.pl |
+-------+----------+--------------+
2 rows in set (0.00 sec)

MariaDB [bazaLS]> SELECT imie, nazwisko FROM klienci WHERE nazwisko LIKE '%ow%';
+-------+----------+
| imie  | nazwisko |
+-------+----------+
| Jan   | Kowalski |
| Jacek | Nowak    |
| Jacek | Nowak    |
+-------+----------+
3 rows in set (0.00 sec)

MariaDB [bazaLS]> SELECT nazwa FROM produkty WHERE nazwa LIKE '__s%';
+--------+
| nazwa  |
+--------+
| myszka |
+--------+
1 row in set (0.00 sec)

MariaDB [bazaLS]> SELECT cena, cena*1.23 AS 'cena_brutto' FROM produkty;
+-------+-------------+
| cena  | cena_brutto |
+-------+-------------+
| 70.50 |     86.7150 |
|  2.90 |      3.5670 |
| 11.15 |     13.7145 |
| 35.60 |     43.7880 |
|  5.90 |      7.2570 |
|  8.90 |     10.9470 |
+-------+-------------+
6 rows in set (0.00 sec)

MariaDB [bazaLS]> SELECT CONCAT(nazwisko, ' ', imie) AS lista FROM klienci;
+----------------+
| lista          |
+----------------+
| Kowalski Jan   |
| Nowak Jacek    |
| Nowak Jacek    |
| Wielki Marek   |
| Malwa Jan      |
| Konrad Robert  |
| Mocny Hubert   |
| Wolny Grzegorz |
+----------------+
8 rows in set (0.00 sec)

MariaDB [bazaLS]> SELECT imie, nazwisko FROM klienci WHERE imie='Jan' OR nazwisko='Wielki';
+-------+----------+
| imie  | nazwisko |
+-------+----------+
| Jan   | Kowalski |
| Marek | Wielki   |
| Jan   | Malwa    |
+-------+----------+
3 rows in set (0.00 sec)

MariaDB [bazaLS]> SELECT nazwa, cena FROM produkty WHERE cena BETWEEN 2 AND 10 ORDER BY cena DESC;
+-----------+------+
| nazwa     | cena |
+-----------+------+
| kabel     | 8.90 |
| slizgacze | 5.90 |
| szmatka   | 2.90 |
+-----------+------+
3 rows in set (0.00 sec)

MariaDB [bazaLS]> SELECT DISTINCT imie FROM klienci;
+----------+
| imie     |
+----------+
| Jan      |
| Jacek    |
| Marek    |
| Robert   |
| Hubert   |
| Grzegorz |
+----------+
6 rows in set (0.00 sec)

MariaDB [bazaLS]> SELECT nazwisko, LENGTH(nazwisko) AS dlugosc FROM klienci;
+----------+---------+
| nazwisko | dlugosc |
+----------+---------+
| Kowalski |       8 |
| Nowak    |       5 |
| Nowak    |       5 |
| Wielki   |       6 |
| Malwa    |       5 |
| Konrad   |       6 |
| Mocny    |       5 |
| Wolny    |       5 |
+----------+---------+
8 rows in set (0.00 sec)

MariaDB [bazaLS]> SELECT K.nazwisko, P.nazwa, ZP.ilosc FROM `zamowienia` AS Z
    -> INNER JOIN klienci AS K ON K.kID=Z.kID
    -> INNER JOIN zam_prod AS ZP ON ZP.zID=Z.zID
    -> INNER JOIN produkty AS P ON P.pID=ZP.pID
    -> ORDER BY ZP.ilosc ASC;
+----------+------------+-------+
| nazwisko | nazwa      | ilosc |
+----------+------------+-------+
| Kowalski | podkladka  |     1 |
| Nowak    | klawiatura |     1 |
| Malwa    | szmatka    |     1 |
| Wielki   | szmatka    |     2 |
| Malwa    | podkladka  |     2 |
| Kowalski | myszka     |     3 |
| Malwa    | myszka     |     5 |
+----------+------------+-------+
7 rows in set (0.00 sec)

MariaDB [bazaLS]> SELECT K.nazwisko,Z.data,Z.koszt FROM klienci AS K
    -> LEFT JOIN zamowienia AS Z ON Z.kID=K.kID
    -> ORDER BY Z.koszt DESC;
+----------+------------+-------+
| nazwisko | data       | koszt |
+----------+------------+-------+
| Wielki   | 2002-03-06 | 79.98 |
| Malwa    | 2002-02-10 | 64.98 |
| Kowalski | 2002-02-19 | 39.99 |
| Malwa    | 2002-02-18 | 34.98 |
| Malwa    | 2002-03-04 | 24.99 |
| Kowalski | 2002-03-12 | 24.95 |
| Nowak    | 2002-03-01 | 14.97 |
| Wolny    | NULL       |  NULL |
| Nowak    | NULL       |  NULL |
| Konrad   | NULL       |  NULL |
| Mocny    | NULL       |  NULL |
+----------+------------+-------+
11 rows in set (0.00 sec)

MariaDB [bazals]> SELECT K.nazwisko, AVG(Z.koszt) as 'ś˜rednia' FROM klienci AS K
    -> INNER JOIN zamowienia AS Z ON Z.kID=K.kID
    -> GROUP BY K.nazwisko
    -> HAVING AVG(Z.koszt)>40;
+----------+-----------+
| nazwisko | ˜średnia   |
+----------+-----------+
| Malwa    | 41.650000 |
| Wielki   | 79.980000 |
+----------+-----------+
2 rows in set (0.00 sec)

MariaDB [bazals]> SELECT K.nazwisko, MAX(Z.koszt) as 'maksymalny_wydatek' FROM klienci AS K
    -> INNER JOIN zamowienia AS Z ON Z.kID=K.kID
    -> GROUP BY K.nazwisko
    -> ORDER BY K.nazwisko DESC;
+----------+--------------------+
| nazwisko | maksymalny_wydatek |
+----------+--------------------+
| Wielki   |              79.98 |
| Nowak    |              14.97 |
| Malwa    |              64.98 |
| Kowalski |              39.99 |
+----------+--------------------+
4 rows in set (0.00 sec)

MariaDB [bazals]>