mysql> show tables;
+----------------+
| Tables_in_lab7 |
+----------------+
| countries      |
| department     |
| employees      |
| location       |
| namelist       |
+----------------+
5 rows in set (0.00 sec)

mysql> select * from namelist;
+----+-----------+----------+-------------+
| SN | FirstName | LastName | FullName    |
+----+-----------+----------+-------------+
|  1 | Farid     | Lawan    | Farid Lawan |
|  2 | Zainab    | Isah     | Zainab Isah |
+----+-----------+----------+-------------+
2 rows in set (0.00 sec)

mysql> select d. LOCATION_ID, 1.location_id, 1.street_address, 1.city,
    ->
    -> -> 1.country_id from department d RIGHT JOIN location 1
    ->
    -> -> ON d. LOCATION_ID = 1.location_id;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-> 1.country_id from department d RIGHT JOIN location 1

-> ON d. LOCATION_ID = ' at line 3
mysql> select d.LOCATION_ID, 1.location_id, 1.street_address, 1.city,
    ->
    -> -> 1.country_id from department d RIGHT JOIN location 1
    ->
    -> -> ON d.LOCATION_ID = 1.location_id;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-> 1.country_id from department d RIGHT JOIN location 1

-> ON d.LOCATION_ID = 1' at line 3
mysql> select d.LOCATION_ID, 1.location_id, 1.street_address, 1.city,
    ->
    -> -> l.country_id from department d RIGHT JOIN location l
    ->
    -> -> ON d.LOCATION_ID = l.location_id;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-> l.country_id from department d RIGHT JOIN location l

-> ON d.LOCATION_ID = l' at line 3
mysql> select d.LOCATION_ID, l.location_id, l.street_address, l.city,
    ->
    -> -> l.country_id from department d RIGHT JOIN location l
    ->
    -> -> ON d.LOCATION_ID = l.location_id;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-> l.country_id from department d RIGHT JOIN location l

-> ON d.LOCATION_ID = l' at line 3
mysql> create database lab7test
    -> ;
Query OK, 1 row affected (0.00 sec)

mysql> use lab7test;
Database changed
mysql> create table List(Name varchar(100), Surname varchar(100));
Query OK, 0 rows affected (0.05 sec)

mysql> insert into list values('Ahmad', 'Muhammad');
Query OK, 1 row affected (0.01 sec)

mysql> select * from list;
+-------+----------+
| Name  | Surname  |
+-------+----------+
| Ahmad | Muhammad |
+-------+----------+
1 row in set (0.00 sec)

mysql> use lab7;
Database changed
mysql> alter table namelist add Email varchar(220) GENERATED ALWAYS AS(CONCAT(LastName, FirstName, "@mail.com"));
Query OK, 0 rows affected (0.02 sec)
Records: 0  Duplicates: 0  Warnings: 0

mysql> select * from namelist;
+----+-----------+----------+-------------+---------------------+
| SN | FirstName | LastName | FullName    | Email               |
+----+-----------+----------+-------------+---------------------+
|  1 | Farid     | Lawan    | Farid Lawan | LawanFarid@mail.com |
|  2 | Zainab    | Isah     | Zainab Isah | IsahZainab@mail.com |
+----+-----------+----------+-------------+---------------------+
2 rows in set (0.00 sec)

mysql> use lab7test;
Database changed
mysql> show tables;
+--------------------+
| Tables_in_lab7test |
+--------------------+
| list               |
+--------------------+
1 row in set (0.00 sec)

mysql> select * from list;
+-------+----------+
| Name  | Surname  |
+-------+----------+
| Ahmad | Muhammad |
+-------+----------+
1 row in set (0.00 sec)

mysql>