mysql [as for monitoring]

Question 1

Select specific columns from table

Answer 1

select , from ;

Question 2

Select all names beginning with “Olya” from table “friends”

Answer 2

select * from friends where name = ‘Olya%’;

Question 3

Select all names ending with “Matveyev” from table “friends”

Answer 3

select * from friends where name = ‘%Matveyev”;

Question 4

Select all friends that are called “Ratmir” and are interested in “flying”

Answer 4

select * from friends where name = ‘Ratmir’ AND interest = ‘flying’;

Question 5

Select by id all friends with their interest and days we know one another

Answer 5

select ID, CONCAT(name, ‘ interested in ‘, interest) AS name, daysknow from friends;

Question 6

Display the total number of employees in every department of a company

Answer 6

mysql> SELECT DEPT, COUNT(*) FROM employee GROUP BY DEPT;
\+------------+----------+
| dept       | count(*) |
\+------------+----------+
| Accounting |        1 |
| Marketing  |        1 |
| Sales      |        1 |
| Technology |        3 |
\+------------+----------+
4 rows in set (0.00 sec)