Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 54
Server version: 11.8.3-MariaDB-0+deb13u1 from Debian -- Please help get to 10k stars at https://github.com/MariaDB/Server

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 [sks]> select *
    ->   from instructor;
+-------+------------+------------+----------+
| ID    | name       | dept_name  | salary   |
+-------+------------+------------+----------+
| 10101 | Srinivasan | Comp. Sci. | 65000.00 |
| 12121 | Wu         | Finance    | 90000.00 |
| 15151 | Mozart     | Music      | 40000.00 |
| 22222 | Einstein   | Physics    | 95000.00 |
| 32343 | El Said    | History    | 60000.00 |
| 33456 | Gold       | Physics    | 87000.00 |
| 45565 | Katz       | Comp. Sci. | 75000.00 |
| 58583 | Califieri  | History    | 62000.00 |
| 76543 | Singh      | Finance    | 80000.00 |
| 76766 | Crick      | Biology    | 72000.00 |
| 83821 | Brandt     | Comp. Sci. | 92000.00 |
| 98345 | Kim        | Elec. Eng. | 80000.00 |
+-------+------------+------------+----------+
12 rows in set (0.001 sec)

MariaDB [sks]> select dept_name
    ->   from instructor;
+------------+
| dept_name  |
+------------+
| Biology    |
| Comp. Sci. |
| Comp. Sci. |
| Comp. Sci. |
| Elec. Eng. |
| Finance    |
| Finance    |
| History    |
| History    |
| Music      |
| Physics    |
| Physics    |
+------------+
12 rows in set (0.001 sec)

MariaDB [sks]> describe instructor;
+-----------+--------------+------+-----+---------+-------+
| Field     | Type         | Null | Key | Default | Extra |
+-----------+--------------+------+-----+---------+-------+
| ID        | varchar(5)   | NO   | PRI | NULL    |       |
| name      | varchar(20)  | NO   |     | NULL    |       |
| dept_name | varchar(20)  | YES  | MUL | NULL    |       |
| salary    | decimal(8,2) | YES  |     | NULL    |       |
+-----------+--------------+------+-----+---------+-------+
4 rows in set (0.001 sec)

MariaDB [sks]> select *
    ->   from department;
+------------+----------+-----------+
| dept_name  | building | budget    |
+------------+----------+-----------+
| Biology    | Watson   |  90000.00 |
| Comp. Sci. | Taylor   | 100000.00 |
| Elec. Eng. | Taylor   |  85000.00 |
| Finance    | Painter  | 120000.00 |
| History    | Painter  |  50000.00 |
| Music      | Packard  |  80000.00 |
| Physics    | Watson   |  70000.00 |
+------------+----------+-----------+
7 rows in set (0.000 sec)

MariaDB [sks]> select distinct dept_name
    ->   from instructor;
+------------+
| dept_name  |
+------------+
| Biology    |
| Comp. Sci. |
| Elec. Eng. |
| Finance    |
| History    |
| Music      |
| Physics    |
+------------+
7 rows in set (0.000 sec)

MariaDB [sks]> select distinct name
    ->   from instructor;
+------------+
| name       |
+------------+
| Srinivasan |
| Wu         |
| Mozart     |
| Einstein   |
| El Said    |
| Gold       |
| Katz       |
| Califieri  |
| Singh      |
| Crick      |
| Brandt     |
| Kim        |
+------------+
12 rows in set (0.000 sec)

MariaDB [sks]> select salary
    ->   from instructor;
+----------+
| salary   |
+----------+
| 65000.00 |
| 90000.00 |
| 40000.00 |
| 95000.00 |
| 60000.00 |
| 87000.00 |
| 75000.00 |
| 62000.00 |
| 80000.00 |
| 72000.00 |
| 92000.00 |
| 80000.00 |
+----------+
12 rows in set (0.000 sec)

MariaDB [sks]> select distinct salary
    ->   from instructor;
+----------+
| salary   |
+----------+
| 65000.00 |
| 90000.00 |
| 40000.00 |
| 95000.00 |
| 60000.00 |
| 87000.00 |
| 75000.00 |
| 62000.00 |
| 80000.00 |
| 72000.00 |
| 92000.00 |
+----------+
11 rows in set (0.001 sec)

MariaDB [sks]> select id,name,salary/12
    ->   from instructor;
+-------+------------+-------------+
| id    | name       | salary/12   |
+-------+------------+-------------+
| 10101 | Srinivasan | 5416.666667 |
| 12121 | Wu         | 7500.000000 |
| 15151 | Mozart     | 3333.333333 |
| 22222 | Einstein   | 7916.666667 |
| 32343 | El Said    | 5000.000000 |
| 33456 | Gold       | 7250.000000 |
| 45565 | Katz       | 6250.000000 |
| 58583 | Califieri  | 5166.666667 |
| 76543 | Singh      | 6666.666667 |
| 76766 | Crick      | 6000.000000 |
| 83821 | Brandt     | 7666.666667 |
| 98345 | Kim        | 6666.666667 |
+-------+------------+-------------+
12 rows in set (0.001 sec)

MariaDB [sks]> select *
    ->   from instructor, teaches;
+-------+------------+------------+----------+-------+-----------+--------+----------+------+
| ID    | name       | dept_name  | salary   | ID    | course_id | sec_id | semester | year |
+-------+------------+------------+----------+-------+-----------+--------+----------+------+
| 10101 | Srinivasan | Comp. Sci. | 65000.00 | 76766 | BIO-101   | 1      | Summer   | 2017 |
| 12121 | Wu         | Finance    | 90000.00 | 76766 | BIO-101   | 1      | Summer   | 2017 |
| 15151 | Mozart     | Music      | 40000.00 | 76766 | BIO-101   | 1      | Summer   | 2017 |
| 22222 | Einstein   | Physics    | 95000.00 | 76766 | BIO-101   | 1      | Summer   | 2017 |
| 32343 | El Said    | History    | 60000.00 | 76766 | BIO-101   | 1      | Summer   | 2017 |
| 33456 | Gold       | Physics    | 87000.00 | 76766 | BIO-101   | 1      | Summer   | 2017 |
| 45565 | Katz       | Comp. Sci. | 75000.00 | 76766 | BIO-101   | 1      | Summer   | 2017 |
| 58583 | Califieri  | History    | 62000.00 | 76766 | BIO-101   | 1      | Summer   | 2017 |
| 76543 | Singh      | Finance    | 80000.00 | 76766 | BIO-101   | 1      | Summer   | 2017 |
| 76766 | Crick      | Biology    | 72000.00 | 76766 | BIO-101   | 1      | Summer   | 2017 |
| 83821 | Brandt     | Comp. Sci. | 92000.00 | 76766 | BIO-101   | 1      | Summer   | 2017 |
| 98345 | Kim        | Elec. Eng. | 80000.00 | 76766 | BIO-101   | 1      | Summer   | 2017 |
| 10101 | Srinivasan | Comp. Sci. | 65000.00 | 76766 | BIO-301   | 1      | Summer   | 2018 |
| 12121 | Wu         | Finance    | 90000.00 | 76766 | BIO-301   | 1      | Summer   | 2018 |
| 15151 | Mozart     | Music      | 40000.00 | 76766 | BIO-301   | 1      | Summer   | 2018 |
| 22222 | Einstein   | Physics    | 95000.00 | 76766 | BIO-301   | 1      | Summer   | 2018 |
| 32343 | El Said    | History    | 60000.00 | 76766 | BIO-301   | 1      | Summer   | 2018 |
| 33456 | Gold       | Physics    | 87000.00 | 76766 | BIO-301   | 1      | Summer   | 2018 |
| 45565 | Katz       | Comp. Sci. | 75000.00 | 76766 | BIO-301   | 1      | Summer   | 2018 |
| 58583 | Califieri  | History    | 62000.00 | 76766 | BIO-301   | 1      | Summer   | 2018 |
| 76543 | Singh      | Finance    | 80000.00 | 76766 | BIO-301   | 1      | Summer   | 2018 |
| 76766 | Crick      | Biology    | 72000.00 | 76766 | BIO-301   | 1      | Summer   | 2018 |
| 83821 | Brandt     | Comp. Sci. | 92000.00 | 76766 | BIO-301   | 1      | Summer   | 2018 |
| 98345 | Kim        | Elec. Eng. | 80000.00 | 76766 | BIO-301   | 1      | Summer   | 2018 |
| 10101 | Srinivasan | Comp. Sci. | 65000.00 | 10101 | CS-101    | 1      | Fall     | 2017 |
| 12121 | Wu         | Finance    | 90000.00 | 10101 | CS-101    | 1      | Fall     | 2017 |
| 15151 | Mozart     | Music      | 40000.00 | 10101 | CS-101    | 1      | Fall     | 2017 |
| 22222 | Einstein   | Physics    | 95000.00 | 10101 | CS-101    | 1      | Fall     | 2017 |
| 32343 | El Said    | History    | 60000.00 | 10101 | CS-101    | 1      | Fall     | 2017 |
| 33456 | Gold       | Physics    | 87000.00 | 10101 | CS-101    | 1      | Fall     | 2017 |
| 45565 | Katz       | Comp. Sci. | 75000.00 | 10101 | CS-101    | 1      | Fall     | 2017 |
| 58583 | Califieri  | History    | 62000.00 | 10101 | CS-101    | 1      | Fall     | 2017 |
| 76543 | Singh      | Finance    | 80000.00 | 10101 | CS-101    | 1      | Fall     | 2017 |
| 76766 | Crick      | Biology    | 72000.00 | 10101 | CS-101    | 1      | Fall     | 2017 |
| 83821 | Brandt     | Comp. Sci. | 92000.00 | 10101 | CS-101    | 1      | Fall     | 2017 |
| 98345 | Kim        | Elec. Eng. | 80000.00 | 10101 | CS-101    | 1      | Fall     | 2017 |
| 10101 | Srinivasan | Comp. Sci. | 65000.00 | 45565 | CS-101    | 1      | Spring   | 2018 |
| 12121 | Wu         | Finance    | 90000.00 | 45565 | CS-101    | 1      | Spring   | 2018 |
| 15151 | Mozart     | Music      | 40000.00 | 45565 | CS-101    | 1      | Spring   | 2018 |
| 22222 | Einstein   | Physics    | 95000.00 | 45565 | CS-101    | 1      | Spring   | 2018 |
| 32343 | El Said    | History    | 60000.00 | 45565 | CS-101    | 1      | Spring   | 2018 |
| 33456 | Gold       | Physics    | 87000.00 | 45565 | CS-101    | 1      | Spring   | 2018 |
| 45565 | Katz       | Comp. Sci. | 75000.00 | 45565 | CS-101    | 1      | Spring   | 2018 |
| 58583 | Califieri  | History    | 62000.00 | 45565 | CS-101    | 1      | Spring   | 2018 |
| 76543 | Singh      | Finance    | 80000.00 | 45565 | CS-101    | 1      | Spring   | 2018 |
| 76766 | Crick      | Biology    | 72000.00 | 45565 | CS-101    | 1      | Spring   | 2018 |
| 83821 | Brandt     | Comp. Sci. | 92000.00 | 45565 | CS-101    | 1      | Spring   | 2018 |
| 98345 | Kim        | Elec. Eng. | 80000.00 | 45565 | CS-101    | 1      | Spring   | 2018 |
| 10101 | Srinivasan | Comp. Sci. | 65000.00 | 83821 | CS-190    | 1      | Spring   | 2017 |
| 12121 | Wu         | Finance    | 90000.00 | 83821 | CS-190    | 1      | Spring   | 2017 |
| 15151 | Mozart     | Music      | 40000.00 | 83821 | CS-190    | 1      | Spring   | 2017 |
| 22222 | Einstein   | Physics    | 95000.00 | 83821 | CS-190    | 1      | Spring   | 2017 |
| 32343 | El Said    | History    | 60000.00 | 83821 | CS-190    | 1      | Spring   | 2017 |
| 33456 | Gold       | Physics    | 87000.00 | 83821 | CS-190    | 1      | Spring   | 2017 |
| 45565 | Katz       | Comp. Sci. | 75000.00 | 83821 | CS-190    | 1      | Spring   | 2017 |
| 58583 | Califieri  | History    | 62000.00 | 83821 | CS-190    | 1      | Spring   | 2017 |
| 76543 | Singh      | Finance    | 80000.00 | 83821 | CS-190    | 1      | Spring   | 2017 |
| 76766 | Crick      | Biology    | 72000.00 | 83821 | CS-190    | 1      | Spring   | 2017 |
| 83821 | Brandt     | Comp. Sci. | 92000.00 | 83821 | CS-190    | 1      | Spring   | 2017 |
| 98345 | Kim        | Elec. Eng. | 80000.00 | 83821 | CS-190    | 1      | Spring   | 2017 |
| 10101 | Srinivasan | Comp. Sci. | 65000.00 | 83821 | CS-190    | 2      | Spring   | 2017 |
| 12121 | Wu         | Finance    | 90000.00 | 83821 | CS-190    | 2      | Spring   | 2017 |
| 15151 | Mozart     | Music      | 40000.00 | 83821 | CS-190    | 2      | Spring   | 2017 |
| 22222 | Einstein   | Physics    | 95000.00 | 83821 | CS-190    | 2      | Spring   | 2017 |
| 32343 | El Said    | History    | 60000.00 | 83821 | CS-190    | 2      | Spring   | 2017 |
| 33456 | Gold       | Physics    | 87000.00 | 83821 | CS-190    | 2      | Spring   | 2017 |
| 45565 | Katz       | Comp. Sci. | 75000.00 | 83821 | CS-190    | 2      | Spring   | 2017 |
| 58583 | Califieri  | History    | 62000.00 | 83821 | CS-190    | 2      | Spring   | 2017 |
| 76543 | Singh      | Finance    | 80000.00 | 83821 | CS-190    | 2      | Spring   | 2017 |
| 76766 | Crick      | Biology    | 72000.00 | 83821 | CS-190    | 2      | Spring   | 2017 |
| 83821 | Brandt     | Comp. Sci. | 92000.00 | 83821 | CS-190    | 2      | Spring   | 2017 |
| 98345 | Kim        | Elec. Eng. | 80000.00 | 83821 | CS-190    | 2      | Spring   | 2017 |
| 10101 | Srinivasan | Comp. Sci. | 65000.00 | 10101 | CS-315    | 1      | Spring   | 2018 |
| 12121 | Wu         | Finance    | 90000.00 | 10101 | CS-315    | 1      | Spring   | 2018 |
| 15151 | Mozart     | Music      | 40000.00 | 10101 | CS-315    | 1      | Spring   | 2018 |
| 22222 | Einstein   | Physics    | 95000.00 | 10101 | CS-315    | 1      | Spring   | 2018 |
| 32343 | El Said    | History    | 60000.00 | 10101 | CS-315    | 1      | Spring   | 2018 |
| 33456 | Gold       | Physics    | 87000.00 | 10101 | CS-315    | 1      | Spring   | 2018 |
| 45565 | Katz       | Comp. Sci. | 75000.00 | 10101 | CS-315    | 1      | Spring   | 2018 |
| 58583 | Califieri  | History    | 62000.00 | 10101 | CS-315    | 1      | Spring   | 2018 |
| 76543 | Singh      | Finance    | 80000.00 | 10101 | CS-315    | 1      | Spring   | 2018 |
| 76766 | Crick      | Biology    | 72000.00 | 10101 | CS-315    | 1      | Spring   | 2018 |
| 83821 | Brandt     | Comp. Sci. | 92000.00 | 10101 | CS-315    | 1      | Spring   | 2018 |
| 98345 | Kim        | Elec. Eng. | 80000.00 | 10101 | CS-315    | 1      | Spring   | 2018 |
| 10101 | Srinivasan | Comp. Sci. | 65000.00 | 45565 | CS-319    | 1      | Spring   | 2018 |
| 12121 | Wu         | Finance    | 90000.00 | 45565 | CS-319    | 1      | Spring   | 2018 |
| 15151 | Mozart     | Music      | 40000.00 | 45565 | CS-319    | 1      | Spring   | 2018 |
| 22222 | Einstein   | Physics    | 95000.00 | 45565 | CS-319    | 1      | Spring   | 2018 |
| 32343 | El Said    | History    | 60000.00 | 45565 | CS-319    | 1      | Spring   | 2018 |
| 33456 | Gold       | Physics    | 87000.00 | 45565 | CS-319    | 1      | Spring   | 2018 |
| 45565 | Katz       | Comp. Sci. | 75000.00 | 45565 | CS-319    | 1      | Spring   | 2018 |
| 58583 | Califieri  | History    | 62000.00 | 45565 | CS-319    | 1      | Spring   | 2018 |
| 76543 | Singh      | Finance    | 80000.00 | 45565 | CS-319    | 1      | Spring   | 2018 |
| 76766 | Crick      | Biology    | 72000.00 | 45565 | CS-319    | 1      | Spring   | 2018 |
| 83821 | Brandt     | Comp. Sci. | 92000.00 | 45565 | CS-319    | 1      | Spring   | 2018 |
| 98345 | Kim        | Elec. Eng. | 80000.00 | 45565 | CS-319    | 1      | Spring   | 2018 |
| 10101 | Srinivasan | Comp. Sci. | 65000.00 | 83821 | CS-319    | 2      | Spring   | 2018 |
| 12121 | Wu         | Finance    | 90000.00 | 83821 | CS-319    | 2      | Spring   | 2018 |
| 15151 | Mozart     | Music      | 40000.00 | 83821 | CS-319    | 2      | Spring   | 2018 |
| 22222 | Einstein   | Physics    | 95000.00 | 83821 | CS-319    | 2      | Spring   | 2018 |
| 32343 | El Said    | History    | 60000.00 | 83821 | CS-319    | 2      | Spring   | 2018 |
| 33456 | Gold       | Physics    | 87000.00 | 83821 | CS-319    | 2      | Spring   | 2018 |
| 45565 | Katz       | Comp. Sci. | 75000.00 | 83821 | CS-319    | 2      | Spring   | 2018 |
| 58583 | Califieri  | History    | 62000.00 | 83821 | CS-319    | 2      | Spring   | 2018 |
| 76543 | Singh      | Finance    | 80000.00 | 83821 | CS-319    | 2      | Spring   | 2018 |
| 76766 | Crick      | Biology    | 72000.00 | 83821 | CS-319    | 2      | Spring   | 2018 |
| 83821 | Brandt     | Comp. Sci. | 92000.00 | 83821 | CS-319    | 2      | Spring   | 2018 |
| 98345 | Kim        | Elec. Eng. | 80000.00 | 83821 | CS-319    | 2      | Spring   | 2018 |
| 10101 | Srinivasan | Comp. Sci. | 65000.00 | 10101 | CS-347    | 1      | Fall     | 2017 |
| 12121 | Wu         | Finance    | 90000.00 | 10101 | CS-347    | 1      | Fall     | 2017 |
| 15151 | Mozart     | Music      | 40000.00 | 10101 | CS-347    | 1      | Fall     | 2017 |
| 22222 | Einstein   | Physics    | 95000.00 | 10101 | CS-347    | 1      | Fall     | 2017 |
| 32343 | El Said    | History    | 60000.00 | 10101 | CS-347    | 1      | Fall     | 2017 |
| 33456 | Gold       | Physics    | 87000.00 | 10101 | CS-347    | 1      | Fall     | 2017 |
| 45565 | Katz       | Comp. Sci. | 75000.00 | 10101 | CS-347    | 1      | Fall     | 2017 |
| 58583 | Califieri  | History    | 62000.00 | 10101 | CS-347    | 1      | Fall     | 2017 |
| 76543 | Singh      | Finance    | 80000.00 | 10101 | CS-347    | 1      | Fall     | 2017 |
| 76766 | Crick      | Biology    | 72000.00 | 10101 | CS-347    | 1      | Fall     | 2017 |
| 83821 | Brandt     | Comp. Sci. | 92000.00 | 10101 | CS-347    | 1      | Fall     | 2017 |
| 98345 | Kim        | Elec. Eng. | 80000.00 | 10101 | CS-347    | 1      | Fall     | 2017 |
| 10101 | Srinivasan | Comp. Sci. | 65000.00 | 98345 | EE-181    | 1      | Spring   | 2017 |
| 12121 | Wu         | Finance    | 90000.00 | 98345 | EE-181    | 1      | Spring   | 2017 |
| 15151 | Mozart     | Music      | 40000.00 | 98345 | EE-181    | 1      | Spring   | 2017 |
| 22222 | Einstein   | Physics    | 95000.00 | 98345 | EE-181    | 1      | Spring   | 2017 |
| 32343 | El Said    | History    | 60000.00 | 98345 | EE-181    | 1      | Spring   | 2017 |
| 33456 | Gold       | Physics    | 87000.00 | 98345 | EE-181    | 1      | Spring   | 2017 |
| 45565 | Katz       | Comp. Sci. | 75000.00 | 98345 | EE-181    | 1      | Spring   | 2017 |
| 58583 | Califieri  | History    | 62000.00 | 98345 | EE-181    | 1      | Spring   | 2017 |
| 76543 | Singh      | Finance    | 80000.00 | 98345 | EE-181    | 1      | Spring   | 2017 |
| 76766 | Crick      | Biology    | 72000.00 | 98345 | EE-181    | 1      | Spring   | 2017 |
| 83821 | Brandt     | Comp. Sci. | 92000.00 | 98345 | EE-181    | 1      | Spring   | 2017 |
| 98345 | Kim        | Elec. Eng. | 80000.00 | 98345 | EE-181    | 1      | Spring   | 2017 |
| 10101 | Srinivasan | Comp. Sci. | 65000.00 | 12121 | FIN-201   | 1      | Spring   | 2018 |
| 12121 | Wu         | Finance    | 90000.00 | 12121 | FIN-201   | 1      | Spring   | 2018 |
| 15151 | Mozart     | Music      | 40000.00 | 12121 | FIN-201   | 1      | Spring   | 2018 |
| 22222 | Einstein   | Physics    | 95000.00 | 12121 | FIN-201   | 1      | Spring   | 2018 |
| 32343 | El Said    | History    | 60000.00 | 12121 | FIN-201   | 1      | Spring   | 2018 |
| 33456 | Gold       | Physics    | 87000.00 | 12121 | FIN-201   | 1      | Spring   | 2018 |
| 45565 | Katz       | Comp. Sci. | 75000.00 | 12121 | FIN-201   | 1      | Spring   | 2018 |
| 58583 | Califieri  | History    | 62000.00 | 12121 | FIN-201   | 1      | Spring   | 2018 |
| 76543 | Singh      | Finance    | 80000.00 | 12121 | FIN-201   | 1      | Spring   | 2018 |
| 76766 | Crick      | Biology    | 72000.00 | 12121 | FIN-201   | 1      | Spring   | 2018 |
| 83821 | Brandt     | Comp. Sci. | 92000.00 | 12121 | FIN-201   | 1      | Spring   | 2018 |
| 98345 | Kim        | Elec. Eng. | 80000.00 | 12121 | FIN-201   | 1      | Spring   | 2018 |
| 10101 | Srinivasan | Comp. Sci. | 65000.00 | 32343 | HIS-351   | 1      | Spring   | 2018 |
| 12121 | Wu         | Finance    | 90000.00 | 32343 | HIS-351   | 1      | Spring   | 2018 |
| 15151 | Mozart     | Music      | 40000.00 | 32343 | HIS-351   | 1      | Spring   | 2018 |
| 22222 | Einstein   | Physics    | 95000.00 | 32343 | HIS-351   | 1      | Spring   | 2018 |
| 32343 | El Said    | History    | 60000.00 | 32343 | HIS-351   | 1      | Spring   | 2018 |
| 33456 | Gold       | Physics    | 87000.00 | 32343 | HIS-351   | 1      | Spring   | 2018 |
| 45565 | Katz       | Comp. Sci. | 75000.00 | 32343 | HIS-351   | 1      | Spring   | 2018 |
| 58583 | Califieri  | History    | 62000.00 | 32343 | HIS-351   | 1      | Spring   | 2018 |
| 76543 | Singh      | Finance    | 80000.00 | 32343 | HIS-351   | 1      | Spring   | 2018 |
| 76766 | Crick      | Biology    | 72000.00 | 32343 | HIS-351   | 1      | Spring   | 2018 |
| 83821 | Brandt     | Comp. Sci. | 92000.00 | 32343 | HIS-351   | 1      | Spring   | 2018 |
| 98345 | Kim        | Elec. Eng. | 80000.00 | 32343 | HIS-351   | 1      | Spring   | 2018 |
| 10101 | Srinivasan | Comp. Sci. | 65000.00 | 15151 | MU-199    | 1      | Spring   | 2018 |
| 12121 | Wu         | Finance    | 90000.00 | 15151 | MU-199    | 1      | Spring   | 2018 |
| 15151 | Mozart     | Music      | 40000.00 | 15151 | MU-199    | 1      | Spring   | 2018 |
| 22222 | Einstein   | Physics    | 95000.00 | 15151 | MU-199    | 1      | Spring   | 2018 |
| 32343 | El Said    | History    | 60000.00 | 15151 | MU-199    | 1      | Spring   | 2018 |
| 33456 | Gold       | Physics    | 87000.00 | 15151 | MU-199    | 1      | Spring   | 2018 |
| 45565 | Katz       | Comp. Sci. | 75000.00 | 15151 | MU-199    | 1      | Spring   | 2018 |
| 58583 | Califieri  | History    | 62000.00 | 15151 | MU-199    | 1      | Spring   | 2018 |
| 76543 | Singh      | Finance    | 80000.00 | 15151 | MU-199    | 1      | Spring   | 2018 |
| 76766 | Crick      | Biology    | 72000.00 | 15151 | MU-199    | 1      | Spring   | 2018 |
| 83821 | Brandt     | Comp. Sci. | 92000.00 | 15151 | MU-199    | 1      | Spring   | 2018 |
| 98345 | Kim        | Elec. Eng. | 80000.00 | 15151 | MU-199    | 1      | Spring   | 2018 |
| 10101 | Srinivasan | Comp. Sci. | 65000.00 | 22222 | PHY-101   | 1      | Fall     | 2017 |
| 12121 | Wu         | Finance    | 90000.00 | 22222 | PHY-101   | 1      | Fall     | 2017 |
| 15151 | Mozart     | Music      | 40000.00 | 22222 | PHY-101   | 1      | Fall     | 2017 |
| 22222 | Einstein   | Physics    | 95000.00 | 22222 | PHY-101   | 1      | Fall     | 2017 |
| 32343 | El Said    | History    | 60000.00 | 22222 | PHY-101   | 1      | Fall     | 2017 |
| 33456 | Gold       | Physics    | 87000.00 | 22222 | PHY-101   | 1      | Fall     | 2017 |
| 45565 | Katz       | Comp. Sci. | 75000.00 | 22222 | PHY-101   | 1      | Fall     | 2017 |
| 58583 | Califieri  | History    | 62000.00 | 22222 | PHY-101   | 1      | Fall     | 2017 |
| 76543 | Singh      | Finance    | 80000.00 | 22222 | PHY-101   | 1      | Fall     | 2017 |
| 76766 | Crick      | Biology    | 72000.00 | 22222 | PHY-101   | 1      | Fall     | 2017 |
| 83821 | Brandt     | Comp. Sci. | 92000.00 | 22222 | PHY-101   | 1      | Fall     | 2017 |
| 98345 | Kim        | Elec. Eng. | 80000.00 | 22222 | PHY-101   | 1      | Fall     | 2017 |
+-------+------------+------------+----------+-------+-----------+--------+----------+------+
180 rows in set (0.001 sec)

MariaDB [sks]> select *
    ->   from instructor, teaches
    ->   where instructor.ID = teaches.ID;
+-------+------------+------------+----------+-------+-----------+--------+----------+------+
| ID    | name       | dept_name  | salary   | ID    | course_id | sec_id | semester | year |
+-------+------------+------------+----------+-------+-----------+--------+----------+------+
| 76766 | Crick      | Biology    | 72000.00 | 76766 | BIO-101   | 1      | Summer   | 2017 |
| 76766 | Crick      | Biology    | 72000.00 | 76766 | BIO-301   | 1      | Summer   | 2018 |
| 10101 | Srinivasan | Comp. Sci. | 65000.00 | 10101 | CS-101    | 1      | Fall     | 2017 |
| 45565 | Katz       | Comp. Sci. | 75000.00 | 45565 | CS-101    | 1      | Spring   | 2018 |
| 83821 | Brandt     | Comp. Sci. | 92000.00 | 83821 | CS-190    | 1      | Spring   | 2017 |
| 83821 | Brandt     | Comp. Sci. | 92000.00 | 83821 | CS-190    | 2      | Spring   | 2017 |
| 10101 | Srinivasan | Comp. Sci. | 65000.00 | 10101 | CS-315    | 1      | Spring   | 2018 |
| 45565 | Katz       | Comp. Sci. | 75000.00 | 45565 | CS-319    | 1      | Spring   | 2018 |
| 83821 | Brandt     | Comp. Sci. | 92000.00 | 83821 | CS-319    | 2      | Spring   | 2018 |
| 10101 | Srinivasan | Comp. Sci. | 65000.00 | 10101 | CS-347    | 1      | Fall     | 2017 |
| 98345 | Kim        | Elec. Eng. | 80000.00 | 98345 | EE-181    | 1      | Spring   | 2017 |
| 12121 | Wu         | Finance    | 90000.00 | 12121 | FIN-201   | 1      | Spring   | 2018 |
| 32343 | El Said    | History    | 60000.00 | 32343 | HIS-351   | 1      | Spring   | 2018 |
| 15151 | Mozart     | Music      | 40000.00 | 15151 | MU-199    | 1      | Spring   | 2018 |
| 22222 | Einstein   | Physics    | 95000.00 | 22222 | PHY-101   | 1      | Fall     | 2017 |
+-------+------------+------------+----------+-------+-----------+--------+----------+------+
15 rows in set (0.001 sec)

MariaDB [sks]> select name,course_id
    ->   from instructor, teaches
    ->   where instructor.ID = teaches.ID ;
+------------+-----------+
| name       | course_id |
+------------+-----------+
| Crick      | BIO-101   |
| Crick      | BIO-301   |
| Srinivasan | CS-101    |
| Katz       | CS-101    |
| Brandt     | CS-190    |
| Brandt     | CS-190    |
| Srinivasan | CS-315    |
| Katz       | CS-319    |
| Brandt     | CS-319    |
| Srinivasan | CS-347    |
| Kim        | EE-181    |
| Wu         | FIN-201   |
| El Said    | HIS-351   |
| Mozart     | MU-199    |
| Einstein   | PHY-101   |
+------------+-----------+
15 rows in set (0.000 sec)

MariaDB [sks]> select ID,name,course_id
    ->   from instructor, teaches
    ->   where instructor.ID = teaches.ID;
ERROR 1052 (23000): Column 'ID' in SELECT is ambiguous
MariaDB [sks]> select instructor.ID,name,course_id
    ->   from instructor, teaches
    ->   where instructor.ID = teaches.ID ;
+-------+------------+-----------+
| ID    | name       | course_id |
+-------+------------+-----------+
| 76766 | Crick      | BIO-101   |
| 76766 | Crick      | BIO-301   |
| 10101 | Srinivasan | CS-101    |
| 45565 | Katz       | CS-101    |
| 83821 | Brandt     | CS-190    |
| 83821 | Brandt     | CS-190    |
| 10101 | Srinivasan | CS-315    |
| 45565 | Katz       | CS-319    |
| 83821 | Brandt     | CS-319    |
| 10101 | Srinivasan | CS-347    |
| 98345 | Kim        | EE-181    |
| 12121 | Wu         | FIN-201   |
| 32343 | El Said    | HIS-351   |
| 15151 | Mozart     | MU-199    |
| 22222 | Einstein   | PHY-101   |
+-------+------------+-----------+
15 rows in set (0.001 sec)

MariaDB [sks]> select teaches.ID,name,course_id
    ->   from instructor, teaches
    ->   where instructor.ID = teaches.ID ;
+-------+------------+-----------+
| ID    | name       | course_id |
+-------+------------+-----------+
| 76766 | Crick      | BIO-101   |
| 76766 | Crick      | BIO-301   |
| 10101 | Srinivasan | CS-101    |
| 45565 | Katz       | CS-101    |
| 83821 | Brandt     | CS-190    |
| 83821 | Brandt     | CS-190    |
| 10101 | Srinivasan | CS-315    |
| 45565 | Katz       | CS-319    |
| 83821 | Brandt     | CS-319    |
| 10101 | Srinivasan | CS-347    |
| 98345 | Kim        | EE-181    |
| 12121 | Wu         | FIN-201   |
| 32343 | El Said    | HIS-351   |
| 15151 | Mozart     | MU-199    |
| 22222 | Einstein   | PHY-101   |
+-------+------------+-----------+
15 rows in set (0.001 sec)

MariaDB [sks]> select *
    ->   from teaches as T1, teaches as T2
    ->   where T1.ID = T2.ID and T1.course_id != T2.course_id;
+-------+-----------+--------+----------+------+-------+-----------+--------+----------+------+
| ID    | course_id | sec_id | semester | year | ID    | course_id | sec_id | semester | year |
+-------+-----------+--------+----------+------+-------+-----------+--------+----------+------+
| 76766 | BIO-101   | 1      | Summer   | 2017 | 76766 | BIO-301   | 1      | Summer   | 2018 |
| 76766 | BIO-301   | 1      | Summer   | 2018 | 76766 | BIO-101   | 1      | Summer   | 2017 |
| 10101 | CS-101    | 1      | Fall     | 2017 | 10101 | CS-315    | 1      | Spring   | 2018 |
| 10101 | CS-101    | 1      | Fall     | 2017 | 10101 | CS-347    | 1      | Fall     | 2017 |
| 45565 | CS-101    | 1      | Spring   | 2018 | 45565 | CS-319    | 1      | Spring   | 2018 |
| 83821 | CS-190    | 1      | Spring   | 2017 | 83821 | CS-319    | 2      | Spring   | 2018 |
| 83821 | CS-190    | 2      | Spring   | 2017 | 83821 | CS-319    | 2      | Spring   | 2018 |
| 10101 | CS-315    | 1      | Spring   | 2018 | 10101 | CS-101    | 1      | Fall     | 2017 |
| 10101 | CS-315    | 1      | Spring   | 2018 | 10101 | CS-347    | 1      | Fall     | 2017 |
| 45565 | CS-319    | 1      | Spring   | 2018 | 45565 | CS-101    | 1      | Spring   | 2018 |
| 83821 | CS-319    | 2      | Spring   | 2018 | 83821 | CS-190    | 1      | Spring   | 2017 |
| 83821 | CS-319    | 2      | Spring   | 2018 | 83821 | CS-190    | 2      | Spring   | 2017 |
| 10101 | CS-347    | 1      | Fall     | 2017 | 10101 | CS-101    | 1      | Fall     | 2017 |
| 10101 | CS-347    | 1      | Fall     | 2017 | 10101 | CS-315    | 1      | Spring   | 2018 |
+-------+-----------+--------+----------+------+-------+-----------+--------+----------+------+
14 rows in set (0.000 sec)

MariaDB [sks]> select distinct T1.id
    ->   from teaches as T1, teaches as T2
    ->   where T1.ID = T2.ID and T1.course_id != T2.course_id;
+-------+
| id    |
+-------+
| 76766 |
| 10101 |
| 45565 |
| 83821 |
+-------+
4 rows in set (0.000 sec)

MariaDB [sks]> select id,name,salary/12
    ->   from instructor;
+-------+------------+-------------+
| id    | name       | salary/12   |
+-------+------------+-------------+
| 10101 | Srinivasan | 5416.666667 |
| 12121 | Wu         | 7500.000000 |
| 15151 | Mozart     | 3333.333333 |
| 22222 | Einstein   | 7916.666667 |
| 32343 | El Said    | 5000.000000 |
| 33456 | Gold       | 7250.000000 |
| 45565 | Katz       | 6250.000000 |
| 58583 | Califieri  | 5166.666667 |
| 76543 | Singh      | 6666.666667 |
| 76766 | Crick      | 6000.000000 |
| 83821 | Brandt     | 7666.666667 |
| 98345 | Kim        | 6666.666667 |
+-------+------------+-------------+
12 rows in set (0.000 sec)

MariaDB [sks]> select id,name,salary/12 as monthlysalary
    ->   from instructor;
+-------+------------+---------------+
| id    | name       | monthlysalary |
+-------+------------+---------------+
| 10101 | Srinivasan |   5416.666667 |
| 12121 | Wu         |   7500.000000 |
| 15151 | Mozart     |   3333.333333 |
| 22222 | Einstein   |   7916.666667 |
| 32343 | El Said    |   5000.000000 |
| 33456 | Gold       |   7250.000000 |
| 45565 | Katz       |   6250.000000 |
| 58583 | Califieri  |   5166.666667 |
| 76543 | Singh      |   6666.666667 |
| 76766 | Crick      |   6000.000000 |
| 83821 | Brandt     |   7666.666667 |
| 98345 | Kim        |   6666.666667 |
+-------+------------+---------------+
12 rows in set (0.000 sec)

MariaDB [sks]> select distinct T1.id as busyID
    ->   from teaches as T1, teaches as T2
    ->   where T1.ID = T2.ID and T1.course_id != T2.course_id;
+--------+
| busyID |
+--------+
| 76766  |
| 10101  |
| 45565  |
| 83821  |
+--------+
4 rows in set (0.001 sec)

MariaDB [sks]> (select course_id
    ->   from section
    ->   where semester = "Fall" and year = "2017");
+-----------+
| course_id |
+-----------+
| CS-101    |
| CS-347    |
| PHY-101   |
+-----------+
3 rows in set (0.000 sec)

MariaDB [sks]> (select course_id
    ->   from section
    ->   where semester = "Spring" and year = "2018");
+-----------+
| course_id |
+-----------+
| CS-101    |
| FIN-201   |
| MU-199    |
| HIS-351   |
| CS-319    |
| CS-319    |
| CS-315    |
+-----------+
7 rows in set (0.000 sec)

MariaDB [sks]> (select course_id
    ->   from section
    ->   where semester = "Fall" and year = "2017") 
    ->   union
    -> (select course_id
    ->   from section
    ->   where semester = "Spring" and year = "2018");
+-----------+
| course_id |
+-----------+
| CS-101    |
| CS-347    |
| PHY-101   |
| FIN-201   |
| MU-199    |
| HIS-351   |
| CS-319    |
| CS-315    |
+-----------+
8 rows in set (0.001 sec)

MariaDB [sks]> select course_id
    ->   from section
    ->   where semester = "Fall" and year = "2017"
    ->   union
    -> (select course_id
    ->   from section
    ->   where semester = "Spring" and year = "2018");
+-----------+
| course_id |
+-----------+
| CS-101    |
| CS-347    |
| PHY-101   |
| FIN-201   |
| MU-199    |
| HIS-351   |
| CS-319    |
| CS-315    |
+-----------+
8 rows in set (0.001 sec)

MariaDB [sks]> (select course_id
    ->   from section
    ->   where semester = "Fall" and year = "2017") 
    -> intersect
    -> (select course_id
    ->   from section
    ->   where semester = "Spring" and year = "2018");
+-----------+
| course_id |
+-----------+
| CS-101    |
+-----------+
1 row in set (0.000 sec)

MariaDB [sks]> (select course_id
    ->   from section
    ->   where semester = "Fall" and year = "2017") 
    -> except (select course_id
    ->   from section
    ->   where semester = "Spring" and year = "2018");
+-----------+
| course_id |
+-----------+
| CS-347    |
| PHY-101   |
+-----------+
2 rows in set (0.001 sec)

MariaDB [sks]> (select course_id
    ->   from course)
    -> except
    -> (select course_id
    ->   from section
    ->   where semester = "Spring" and year = "2018");
+-----------+
| course_id |
+-----------+
| BIO-101   |
| BIO-301   |
| BIO-399   |
| CS-190    |
| CS-347    |
| EE-181    |
| PHY-101   |
+-----------+
7 rows in set (0.001 sec)

MariaDB [sks]> select avg(salary)
    ->   from instructor;
+--------------+
| avg(salary)  |
+--------------+
| 74833.333333 |
+--------------+
1 row in set (0.000 sec)

MariaDB [sks]> select avg(salary) as avgsal
    ->   from instructor;
+--------------+
| avgsal       |
+--------------+
| 74833.333333 |
+--------------+
1 row in set (0.000 sec)

MariaDB [sks]> select min(salary)
    ->   from instructor;
+-------------+
| min(salary) |
+-------------+
|    40000.00 |
+-------------+
1 row in set (0.000 sec)

MariaDB [sks]> select max(salary)
    ->   from instructor;
+-------------+
| max(salary) |
+-------------+
|    95000.00 |
+-------------+
1 row in set (0.000 sec)

MariaDB [sks]> select sum(salary)
    ->   from instructor;
+-------------+
| sum(salary) |
+-------------+
|   898000.00 |
+-------------+
1 row in set (0.000 sec)

MariaDB [sks]> select avg(salary) as avgsal
    ->   from (select *
    ->   from instructor
    ->   where salary > 70000);
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 4
MariaDB [sks]> select avg(salary) as avgsal
    ->   from (select *
    ->   from instructor
    ->   where salary > 70000) as newtable;
+--------------+
| avgsal       |
+--------------+
| 83875.000000 |
+--------------+
1 row in set (0.001 sec)

MariaDB [sks]> with avg_budget(value) as
    ->   (select avg(budget)
    ->    from department)
    -> select dept_name
    ->   from department,avg_budget
    ->   where department.budget > avg_budget.value;
+------------+
| dept_name  |
+------------+
| Biology    |
| Comp. Sci. |
| Finance    |
+------------+
3 rows in set (0.001 sec)

MariaDB [sks]> select dept_name
    ->   from department,(select avg(budget)
    ->                    from department) as avg_budget(value)
    ->   where department.budget > avg_budget.value;
+------------+
| dept_name  |
+------------+
| Biology    |
| Comp. Sci. |
| Finance    |
+------------+
3 rows in set (0.001 sec)

MariaDB [sks]> select name
    ->   from instructor where dept_name like "Phy%";
+----------+
| name     |
+----------+
| Einstein |
| Gold     |
+----------+
2 rows in set (0.001 sec)

MariaDB [sks]> select name
    ->   from instructor where dept_name like "phy%";
+----------+
| name     |
+----------+
| Einstein |
| Gold     |
+----------+
2 rows in set (0.001 sec)

MariaDB [sks]> select name
    ->   from instructor where dept_name like "phy";
Empty set (0.000 sec)

MariaDB [sks]> select name
    ->   from instructor where dept_name like "phy_";
Empty set (0.000 sec)

MariaDB [sks]> select name
    ->   from instructor where dept_name like "%phy%";
+----------+
| name     |
+----------+
| Einstein |
| Gold     |
+----------+
2 rows in set (0.000 sec)

MariaDB [sks]> select name
    ->   from instructor where dept_name like "%y%";
+-----------+
| name      |
+-----------+
| Einstein  |
| El Said   |
| Gold      |
| Califieri |
| Crick     |
+-----------+
5 rows in set (0.000 sec)

MariaDB [sks]> select name
    ->   from instructor where name like "%ei%ei%";
+----------+
| name     |
+----------+
| Einstein |
+----------+
1 row in set (0.001 sec)

MariaDB [sks]> select name
    ->   from instructor where name like "%ri%";
+------------+
| name       |
+------------+
| Srinivasan |
| Califieri  |
| Crick      |
+------------+
3 rows in set (0.000 sec)

MariaDB [sks]> select name
    ->   from instructor
    ->   where name like "%ri_%";
+------------+
| name       |
+------------+
| Srinivasan |
| Crick      |
+------------+
2 rows in set (0.001 sec)

MariaDB [sks]> select *
    ->   from instructor
    ->   order by name;
+-------+------------+------------+----------+
| ID    | name       | dept_name  | salary   |
+-------+------------+------------+----------+
| 83821 | Brandt     | Comp. Sci. | 92000.00 |
| 58583 | Califieri  | History    | 62000.00 |
| 76766 | Crick      | Biology    | 72000.00 |
| 22222 | Einstein   | Physics    | 95000.00 |
| 32343 | El Said    | History    | 60000.00 |
| 33456 | Gold       | Physics    | 87000.00 |
| 45565 | Katz       | Comp. Sci. | 75000.00 |
| 98345 | Kim        | Elec. Eng. | 80000.00 |
| 15151 | Mozart     | Music      | 40000.00 |
| 76543 | Singh      | Finance    | 80000.00 |
| 10101 | Srinivasan | Comp. Sci. | 65000.00 |
| 12121 | Wu         | Finance    | 90000.00 |
+-------+------------+------------+----------+
12 rows in set (0.000 sec)

MariaDB [sks]> select *
    ->   from instructor
    ->   order by salary;
+-------+------------+------------+----------+
| ID    | name       | dept_name  | salary   |
+-------+------------+------------+----------+
| 15151 | Mozart     | Music      | 40000.00 |
| 32343 | El Said    | History    | 60000.00 |
| 58583 | Califieri  | History    | 62000.00 |
| 10101 | Srinivasan | Comp. Sci. | 65000.00 |
| 76766 | Crick      | Biology    | 72000.00 |
| 45565 | Katz       | Comp. Sci. | 75000.00 |
| 76543 | Singh      | Finance    | 80000.00 |
| 98345 | Kim        | Elec. Eng. | 80000.00 |
| 33456 | Gold       | Physics    | 87000.00 |
| 12121 | Wu         | Finance    | 90000.00 |
| 83821 | Brandt     | Comp. Sci. | 92000.00 |
| 22222 | Einstein   | Physics    | 95000.00 |
+-------+------------+------------+----------+
12 rows in set (0.001 sec)

MariaDB [sks]> select *
    ->   from instructor
    ->   order by salary,name;
+-------+------------+------------+----------+
| ID    | name       | dept_name  | salary   |
+-------+------------+------------+----------+
| 15151 | Mozart     | Music      | 40000.00 |
| 32343 | El Said    | History    | 60000.00 |
| 58583 | Califieri  | History    | 62000.00 |
| 10101 | Srinivasan | Comp. Sci. | 65000.00 |
| 76766 | Crick      | Biology    | 72000.00 |
| 45565 | Katz       | Comp. Sci. | 75000.00 |
| 98345 | Kim        | Elec. Eng. | 80000.00 |
| 76543 | Singh      | Finance    | 80000.00 |
| 33456 | Gold       | Physics    | 87000.00 |
| 12121 | Wu         | Finance    | 90000.00 |
| 83821 | Brandt     | Comp. Sci. | 92000.00 |
| 22222 | Einstein   | Physics    | 95000.00 |
+-------+------------+------------+----------+
12 rows in set (0.000 sec)

MariaDB [sks]> select *
    ->   from instructor
    ->   order by salary desc,name;
+-------+------------+------------+----------+
| ID    | name       | dept_name  | salary   |
+-------+------------+------------+----------+
| 22222 | Einstein   | Physics    | 95000.00 |
| 83821 | Brandt     | Comp. Sci. | 92000.00 |
| 12121 | Wu         | Finance    | 90000.00 |
| 33456 | Gold       | Physics    | 87000.00 |
| 98345 | Kim        | Elec. Eng. | 80000.00 |
| 76543 | Singh      | Finance    | 80000.00 |
| 45565 | Katz       | Comp. Sci. | 75000.00 |
| 76766 | Crick      | Biology    | 72000.00 |
| 10101 | Srinivasan | Comp. Sci. | 65000.00 |
| 58583 | Califieri  | History    | 62000.00 |
| 32343 | El Said    | History    | 60000.00 |
| 15151 | Mozart     | Music      | 40000.00 |
+-------+------------+------------+----------+
12 rows in set (0.000 sec)

MariaDB [sks]> select *
    ->   from instructor
    ->   order by salary desc,name desc;
+-------+------------+------------+----------+
| ID    | name       | dept_name  | salary   |
+-------+------------+------------+----------+
| 22222 | Einstein   | Physics    | 95000.00 |
| 83821 | Brandt     | Comp. Sci. | 92000.00 |
| 12121 | Wu         | Finance    | 90000.00 |
| 33456 | Gold       | Physics    | 87000.00 |
| 76543 | Singh      | Finance    | 80000.00 |
| 98345 | Kim        | Elec. Eng. | 80000.00 |
| 45565 | Katz       | Comp. Sci. | 75000.00 |
| 76766 | Crick      | Biology    | 72000.00 |
| 10101 | Srinivasan | Comp. Sci. | 65000.00 |
| 58583 | Califieri  | History    | 62000.00 |
| 32343 | El Said    | History    | 60000.00 |
| 15151 | Mozart     | Music      | 40000.00 |
+-------+------------+------------+----------+
12 rows in set (0.000 sec)

MariaDB [sks]> select dept_name, avg(salary)
    ->   from instructor
    ->   group by dept_name ;
+------------+--------------+
| dept_name  | avg(salary)  |
+------------+--------------+
| Biology    | 72000.000000 |
| Comp. Sci. | 77333.333333 |
| Elec. Eng. | 80000.000000 |
| Finance    | 85000.000000 |
| History    | 61000.000000 |
| Music      | 40000.000000 |
| Physics    | 91000.000000 |
+------------+--------------+
7 rows in set (0.000 sec)

MariaDB [sks]> select dept_name, count(*)
    ->   from instructor
    ->   group by dept_name ;
+------------+----------+
| dept_name  | count(*) |
+------------+----------+
| Biology    |        1 |
| Comp. Sci. |        3 |
| Elec. Eng. |        1 |
| Finance    |        2 |
| History    |        2 |
| Music      |        1 |
| Physics    |        2 |
+------------+----------+
7 rows in set (0.000 sec)

MariaDB [sks]> select name,dept_name, count(*)
    ->   from instructor
    ->   group by dept_name ;
+------------+------------+----------+
| name       | dept_name  | count(*) |
+------------+------------+----------+
| Crick      | Biology    |        1 |
| Srinivasan | Comp. Sci. |        3 |
| Kim        | Elec. Eng. |        1 |
| Wu         | Finance    |        2 |
| El Said    | History    |        2 |
| Mozart     | Music      |        1 |
| Einstein   | Physics    |        2 |
+------------+------------+----------+
7 rows in set (0.000 sec)

MariaDB [sks]> select name,dept_name, count(*)
    ->   from instructor
    ->   group by dept_name
    ->   order by name;
+------------+------------+----------+
| name       | dept_name  | count(*) |
+------------+------------+----------+
| Crick      | Biology    |        1 |
| Einstein   | Physics    |        2 |
| El Said    | History    |        2 |
| Kim        | Elec. Eng. |        1 |
| Mozart     | Music      |        1 |
| Srinivasan | Comp. Sci. |        3 |
| Wu         | Finance    |        2 |
+------------+------------+----------+
7 rows in set (0.000 sec)

MariaDB [sks]> select name,dept_name, count(*) from
    ->   (select * from instructor order by name) as xyz
    ->   group by dept_name
    ->   order by name;
+------------+------------+----------+
| name       | dept_name  | count(*) |
+------------+------------+----------+
| Crick      | Biology    |        1 |
| Einstein   | Physics    |        2 |
| El Said    | History    |        2 |
| Kim        | Elec. Eng. |        1 |
| Mozart     | Music      |        1 |
| Srinivasan | Comp. Sci. |        3 |
| Wu         | Finance    |        2 |
+------------+------------+----------+
7 rows in set (0.000 sec)

MariaDB [sks]> select dept_name, avg(salary) from instructor
    ->   group by dept_name
    ->   having max(salary) > 80000 ;
+------------+--------------+
| dept_name  | avg(salary)  |
+------------+--------------+
| Comp. Sci. | 77333.333333 |
| Finance    | 85000.000000 |
| Physics    | 91000.000000 |
+------------+--------------+
3 rows in set (0.000 sec)

MariaDB [sks]> select dept_name, avg(salary), max(salary)
    ->   from instructor
    ->   group by dept_name
    ->   having max(salary) > 80000 ;
+------------+--------------+-------------+
| dept_name  | avg(salary)  | max(salary) |
+------------+--------------+-------------+
| Comp. Sci. | 77333.333333 |    92000.00 |
| Finance    | 85000.000000 |    90000.00 |
| Physics    | 91000.000000 |    95000.00 |
+------------+--------------+-------------+
3 rows in set (0.000 sec)

MariaDB [sks]> select dept_name, avg(salary), max(salary)
    ->   from instructor group by dept_name
    ->   having max(salary) > 90000 ;
+------------+--------------+-------------+
| dept_name  | avg(salary)  | max(salary) |
+------------+--------------+-------------+
| Comp. Sci. | 77333.333333 |    92000.00 |
| Physics    | 91000.000000 |    95000.00 |
+------------+--------------+-------------+
2 rows in set (0.000 sec)

MariaDB [sks]> select dept_name, count(*)
    ->   from instructor
    ->   group by dept_name
    ->   having count(*) > 1;
+------------+----------+
| dept_name  | count(*) |
+------------+----------+
| Comp. Sci. |        3 |
| Finance    |        2 |
| History    |        2 |
| Physics    |        2 |
+------------+----------+
4 rows in set (0.000 sec)

MariaDB [sks]> exit