Rename values in one column, depending on the value in other column

I have two tables with orders and parcels in MariaDB:

Rename values in one column, depending on the value in other column

I have two tables with orders and parcels in MariaDB:

Rename values in one column, depending on the value in other column

I have two tables with orders and parcels in MariaDB:

Rename values in one column, depending on the value in other column

I have two tables with orders and parcels in MariaDB:

Rename values in one column, depending on the value in other column

I have two tables with orders and parcels in MariaDB:

Rename values in one column, depending on the value in other column

I have two tables with orders and parcels in MariaDB:

Rename values in one column, depending on the value in other column

I have two tables with orders and parcels in MariaDB:

Rename values in one column, depending on the value in other column

I have two tables with orders and parcels in MariaDB:

Avoid the use of alias in query with nested SELECT clause

I have this table:

Avoid the use of alias in query with nested SELECT clause

I have this table: