Изпитване 18.11.2021

Setting environment for using XAMPP for Windows.
nelly@NELLYIVANOVA c:\xampp
# mysql -uroot
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 19
Server version: 10.4.21-MariaDB mariadb.org binary distribution

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> create database company;
Query OK, 1 row affected (0.017 sec)

MariaDB [(none)]> use company;
Database changed
MariaDB [company]> create table company(
    -> name VARCHAR (50) NOT NULL,
    -> position VARCHAR (50) NOT NULL,
    -> year INT,
    -> age INT,
    -> salary FLOAT);
Query OK, 0 rows affected (0.065 sec)

MariaDB [company]> INSERT INTO company (name, position, year, age, salary) VALUES('Ralitsa Marinova','CEO','2015','45','8000');
Query OK, 1 row affected (0.026 sec)

MariaDB [company]> select* from company;
+------------------+----------+------+------+--------+
| name             | position | year | age  | salary |
+------------------+----------+------+------+--------+
| Ralitsa Marinova | CEO      | 2015 |   45 |   8000 |
+------------------+----------+------+------+--------+
1 row in set (0.012 sec)

MariaDB [company]> INSERT INTO company (name, position, year, age, salary) VALUES('Galia Ivanova','senior programmer','2018','45','6000');
Query OK, 1 row affected (0.002 sec)

MariaDB [company]> INSERT INTO company (name, position, year, age, salary) VALUES('Milena Georgieva','junior programmer','2020','23','4000');
Query OK, 1 row affected (0.008 sec)

MariaDB [company]> INSERT INTO company (name, position, year, age, salary) VALUES('Kristina Petkova','junior programmer','2020','24','4000');
Query OK, 1 row affected (0.008 sec)

MariaDB [company]> INSERT INTO company (name, position, year, age, salary) VALUES('Nadia Ivanova','Online Business Manager','2020','22','3000');
Query OK, 1 row affected (0.002 sec)

MariaDB [company]> INSERT INTO company (name, position, year, age, salary) VALUES('Georgi Hristov','senior programmer','2017','28','6500');
Query OK, 1 row affected (0.008 sec)

MariaDB [company]> INSERT INTO company (name, position, year, age, salary) VALUES('Gabriel Yankov','designer','2017','28','5000');
Query OK, 1 row affected (0.003 sec)

MariaDB [company]> INSERT INTO company (name, position, year, age, salary) VALUES('Daniel Dimitrov','designer','2018','26','5500');
Query OK, 1 row affected (0.002 sec)

MariaDB [company]> INSERT INTO company (name, position, year, age, salary) VALUES('Samuil Georgiev','QA','2019','26','4000');
Query OK, 1 row affected (0.007 sec)

MariaDB [company]> INSERT INTO company (name, position, year, age, salary) VALUES('Ivana Karaivanova','QA','2019','24','3800');
Query OK, 1 row affected (0.007 sec)

MariaDB [company]> select* from company;
+-------------------+-------------------------+------+------+--------+
| name              | position                | year | age  | salary |
+-------------------+-------------------------+------+------+--------+
| Ralitsa Marinova  | CEO                     | 2015 |   45 |   8000 |
| Galia Ivanova     | senior programmer       | 2018 |   45 |   6000 |
| Milena Georgieva  | junior programmer       | 2020 |   23 |   4000 |
| Kristina Petkova  | junior programmer       | 2020 |   24 |   4000 |
| Nadia Ivanova     | Online Business Manager | 2020 |   22 |   3000 |
| Georgi Hristov    | senior programmer       | 2017 |   28 |   6500 |
| Gabriel Yankov    | designer                | 2017 |   28 |   5000 |
| Daniel Dimitrov   | designer                | 2018 |   26 |   5500 |
| Samuil Georgiev   | QA                      | 2019 |   26 |   4000 |
| Ivana Karaivanova | QA                      | 2019 |   24 |   3800 |
+-------------------+-------------------------+------+------+--------+
10 rows in set (0.007 sec)

MariaDB [company]> select * from company ORDER BY salary DESC;
+-------------------+-------------------------+------+------+--------+
| name              | position                | year | age  | salary |
+-------------------+-------------------------+------+------+--------+
| Ralitsa Marinova  | CEO                     | 2015 |   45 |   8000 |
| Georgi Hristov    | senior programmer       | 2017 |   28 |   6500 |
| Galia Ivanova     | senior programmer       | 2018 |   45 |   6000 |
| Daniel Dimitrov   | designer                | 2018 |   26 |   5500 |
| Gabriel Yankov    | designer                | 2017 |   28 |   5000 |
| Milena Georgieva  | junior programmer       | 2020 |   23 |   4000 |
| Kristina Petkova  | junior programmer       | 2020 |   24 |   4000 |
| Samuil Georgiev   | QA                      | 2019 |   26 |   4000 |
| Ivana Karaivanova | QA                      | 2019 |   24 |   3800 |
| Nadia Ivanova     | Online Business Manager | 2020 |   22 |   3000 |
+-------------------+-------------------------+------+------+--------+
10 rows in set (0.009 sec)

MariaDB [company]> SELECT MIN(age) from company;
+----------+
| MIN(age) |
+----------+
|       22 |
+----------+
1 row in set (0.001 sec)

MariaDB [company]> select* from company where position='Online Business Manager'and name='Nadia Ivanova';
+---------------+-------------------------+------+------+--------+
| name          | position                | year | age  | salary |
+---------------+-------------------------+------+------+--------+
| Nadia Ivanova | Online Business Manager | 2020 |   22 |   3000 |
+---------------+-------------------------+------+------+--------+
1 row in set (0.001 sec)

MariaDB [company]> Select position,AVG(salary) as "average salary" from company Group by position;
+-------------------------+----------------+
| position                | average salary |
+-------------------------+----------------+
| CEO                     |           8000 |
| designer                |           5250 |
| junior programmer       |           4000 |
| Online Business Manager |           3000 |
| QA                      |           3900 |
| senior programmer       |           6250 |
+-------------------------+----------------+
6 rows in set (0.003 sec)

MariaDB [company]> Select year,COUNT(year) as "count" from company Group by year;
+------+------------+
| year |    count   |
+------+------------+
| 2015 |          1 |
| 2017 |          2 |
| 2018 |          2 |
| 2019 |          2 |
| 2020 |          3 |
+------+------------+
5 rows in set (0.001 sec)

MariaDB [company]>