数据库学习3

本笔记为阿里云天池龙珠计划SQL训练营的学习内容，链接为：https://tianchi.aliyun.com/specials/promotion/aicampsql；

视图基于表建立，创建一张临时表

语法：CREATE VIEW <视图名称> (<列名1>,<列名2>,) AS

eg: CREATE VIEW product_sum (product_type, cnt_product) AS SELECT product_type, COUNT(*)  FROM product GROUP BY product_type ;

​​​​​​​