# Test case with simple view without GROUP BY
# Env: MySQL 8.0.34

drop database if exists testcase;

create database testcase ;
use testcase ;


drop table if exists emp;
create table emp (emp_id int, emp_name varchar(100), salary int, dept_id int);
insert into emp values
(1, 'emp_A', 1000, 10),
(2, 'emp_B', 2000, 20),
(3, 'emp_C', 3000, 30),
(4, 'emp_D', 2000, 10),
(5, 'emp_E', 3000, 20);


# Create simple view by copying table "emp"
drop view if exists vw_emp ;
CREATE VIEW `vw_emp` AS
select emp_id, emp_name, salary, dept_id from emp;


drop table if exists dept;
create table dept (dept_id int, dept_name varchar(100));
insert into dept values
(10, 'dept_A'),
(20, 'dept_B'),
(30, 'dept_C'),
(40, 'dept_D'),
(50, 'dept_E'),
(60, 'dept_F');

commit;