SQL 必知必会第七课 创建计算字段

SQL 必知必会第七课 创建计算字段

select concat(vend_name, '( ',vend_country,' )') from Vendors order by vend_name;
## 拼接供应商名，左括号，供应商国家，右括号 

select concat(vend_name, '( ',vend_country,' )') as vend_title from Vendors order by vend_name;

select prod_id,quantity, item_price from OrderItems where order_num = 20008;

select prod_id,quantity, item_price, quantity * item_price as expanded_price  from OrderItems where order_num = 20008;


##Challenges
select vend_id, vend_name as vname, vend_address as vaddress, vend_city as vcity from Vendors order by vend_name;  -- 1

select prod_id, prod_price, 0.9 * prod_price as sale_price from Products; -- 2 

注意点

1. 若想要有空格，需要加空格字符，不用trim函数去空格

2. 别名还可以用来修改合法的字符名