show databases; create database Subquery; use subquery; show tables; create table orders select * from products; select *from orders; insert into orders select Product_id, P_name, sell_price from products where Product_id in (select product_id from products where sell_price>1000); create table products (Product_id int, P_name varchar(30), sell_price int, P_type varchar(30)); insert into products values (101, 'laptop', 1400, 'Luxury'), (102, 'Camera', 61, 'Non luxury'), (103, 'Neckplace', 1200, 'Non luxury'), (104, 'Sofa', 800, 'Non luxury'); create table orders (order_id int, Product_sold varchar(30), selling_price int); select * from products; create table Employees (Name VARCHAR(25), Age int, sex CHAR(1), address varchar(15), salary float); insert into Employees values("Mohamed", 35, "M", "Sousse", 150000), ("Ali", 35, "M", "Sousse", 155000), ("Chaima", 22, "F", "Sousse", 62000), ("Hasna", 21, "F", "Tunis", 57000), ("Wala", 25, "F", "Alger", 72000), ("Oumaima", 26, "F", "Annaba", 80000); select * from employees; update employees set salary = salary* 1.4 where age in (select age from employees_B where age >34); update employees set salary = 150000 where name in (select name from employees_B where name= 'Mohamed'); update employees set salary = 155000 where name in (select name from employees_B where name= 'Ali'); Delete from employees where age in (select age from employees_b where age<=22); insert into employees values ("Chaima", 22, "F", "Sousse", 62000), ("Hasna", 21, "F", "Tunis", 57000); select name from employees where salary=(select Max(salary) from employees); select name, age, address, salary from employees where salary<(select avg(salary) from employees); create table Employees_B (Name VARCHAR(25), Age int, sex CHAR(1), address varchar(15), salary float); insert into Employees_B values("Mohamed", 35, "M", "Sousse", 150000), ("Ali", 35, "M", "Sousse", 155000), ("Chaima", 22, "F", "Sousse", 62000), ("Hasna", 21, "F", "Tunis", 57000), ("Wala", 25, "F", "Alger", 72000), ("Oumaima", 26, "F", "Annaba", 80000);