Create table If Not Exists cinema (id int, movie varchar(255), description varchar(255), rating float(2, 1))

Truncate table cinema

insert into cinema (id, movie, description, rating) values ('1', 'War', 'great 3D', '8.9')

insert into cinema (id, movie, description, rating) values ('2', 'Science', 'fiction', '8.5')

insert into cinema (id, movie, description, rating) values ('3', 'irish', 'boring', '6.2')

insert into cinema (id, movie, description, rating) values ('4', 'Ice song', 'Fantacy', '8.6')

insert into cinema (id, movie, description, rating) values ('5', 'House card', 'Interesting', '9.1')

Create table If Not Exists Project (project_id int, employee_id int)

Create table If Not Exists Employee (employee_id int, name varchar(10), experience_years int)

Truncate table Project

insert into Project (project_id, employee_id) values ('1', '1')

insert into Project (project_id, employee_id) values ('1', '2')

insert into Project (project_id, employee_id) values ('1', '3')

insert into Project (project_id, employee_id) values ('2', '1')

insert into Project (project_id, employee_id) values ('2', '4')

Truncate table Employee

insert into Employee (employee_id, name, experience_years) values ('1', 'Khaled', '3')

insert into Employee (employee_id, name, experience_years) values ('2', 'Ali', '2')

insert into Employee (employee_id, name, experience_years) values ('3', 'John', '1')

insert into Employee (employee_id, name, experience_years) values ('4', 'Doe', '2')
Create table If Not Exists Users (user_id int, user_name varchar(20))

Create table If Not Exists Register (contest_id int, user_id int)

Truncate table Users

insert into Users (user_id, user_name) values ('6', 'Alice')

insert into Users (user_id, user_name) values ('2', 'Bob')

insert into Users (user_id, user_name) values ('7', 'Alex')

Truncate table Register

insert into Register (contest_id, user_id) values ('215', '6')

insert into Register (contest_id, user_id) values ('209', '2')

insert into Register (contest_id, user_id) values ('208', '2')

insert into Register (contest_id, user_id) values ('210', '6')

insert into Register (contest_id, user_id) values ('208', '6')

insert into Register (contest_id, user_id) values ('209', '7')

insert into Register (contest_id, user_id) values ('209', '6')

insert into Register (contest_id, user_id) values ('215', '7')

insert into Register (contest_id, user_id) values ('208', '7')

insert into Register (contest_id, user_id) values ('210', '2')

insert into Register (contest_id, user_id) values ('207', '2')

insert into Register (contest_id, user_id) values ('210', '7')

Create table If Not Exists UnitsSold (product_id int, purchase_date date, units int)

Truncate table Prices

insert into Prices (product_id, start_date, end_date, price) values ('1', '2019-02-17', '2019-02-28', '5')

insert into Prices (product_id, start_date, end_date, price) values ('1', '2019-03-01', '2019-03-22', '20')

insert into Prices (product_id, start_date, end_date, price) values ('2', '2019-02-01', '2019-02-20', '15')

insert into Prices (product_id, start_date, end_date, price) values ('2', '2019-02-21', '2019-03-31', '30')

Truncate table UnitsSold

insert into UnitsSold (product_id, purchase_date, units) values ('1', '2019-02-25', '100')

insert into UnitsSold (product_id, purchase_date, units) values ('1', '2019-03-01', '15')

insert into UnitsSold (product_id, purchase_date, units) values ('2', '2019-02-10', '200')

insert into UnitsSold (product_id, purchase_date, units) values ('2', '2019-03-22', '30')

Create table If Not Exists Queries (query_name varchar(30), result varchar(50), position int, rating int)

Truncate table Queries

insert into Queries (query_name, result, position, rating) values ('Dog', 'Golden Retriever', '1', '5')

insert into Queries (query_name, result, position, rating) values ('Dog', 'German Shepherd', '2', '5')

insert into Queries (query_name, result, position, rating) values ('Dog', 'Mule', '200', '1')

insert into Queries (query_name, result, position, rating) values ('Cat', 'Shirazi', '5', '2')

insert into Queries (query_name, result, position, rating) values ('Cat', 'Siamese', '3', '3')

insert into Queries (query_name, result, position, rating) values ('Cat', 'Sphynx', '7', '4')

Create table If Not Exists Transactions (id int, country varchar(4), state enum('approved', 'declined'),
amount int, trans_date date)

Truncate table Transactions

insert into Transactions (id, country, state, amount, trans_date) values ('122', 'US', 'declined', '2000',
'2018-12-19')

insert into Transactions (id, country, state, amount, trans_date) values ('123', 'US', 'approved', '2000',
'2019-01-01')

insert into Transactions (id, country, state, amount, trans_date) values ('124', 'DE', 'approved', '2000',
'2019-01-07')

Create table If Not Exists Delivery (delivery_id int, customer_id int, order_date date,
customer_pref_delivery_date date)

Truncate table Delivery

insert into Delivery (delivery_id, customer_id, order_date, customer_pref_delivery_date) values ('1', '1',
'2019-08-01', '2019-08-02')

insert into Delivery (delivery_id, customer_id, order_date, customer_pref_delivery_date) values ('2', '2',
'2019-08-02', '2019-08-02')

insert into Delivery (delivery_id, customer_id, order_date, customer_pref_delivery_date) values ('3', '1',
'2019-08-11', '2019-08-12')

insert into Delivery (delivery_id, customer_id, order_date, customer_pref_delivery_date) values ('4', '3',
'2019-08-24', '2019-08-24')

insert into Delivery (delivery_id, customer_id, order_date, customer_pref_delivery_date) values ('5', '3',
'2019-08-21', '2019-08-22')

insert into Delivery (delivery_id, customer_id, order_date, customer_pref_delivery_date) values ('6', '2',
'2019-08-11', '2019-08-13')

insert into Delivery (delivery_id, customer_id, order_date, customer_pref_delivery_date) values ('7', '4',
'2019-08-09', '2019-08-09')

Create table If Not Exists Activity (player_id int, device_id int, event_date date, games_played int)

Truncate table Activity

insert into Activity (player_id, device_id, event_date, games_played) values ('1', '2', '2016-03-01', '5')
insert into Activity (player_id, device_id, event_date, games_played) values ('1', '2', '2016-03-02', '6')

insert into Activity (player_id, device_id, event_date, games_played) values ('2', '3', '2017-06-25', '1')

insert into Activity (player_id, device_id, event_date, games_played) values ('3', '1', '2016-03-02', '0')

insert into Activity (player_id, device_id, event_date, games_played) values ('3', '4', '2018-07-03', '5')

Create table If Not Exists Teacher (teacher_id int, subject_id int, dept_id int)

Truncate table Teacher

insert into Teacher (teacher_id, subject_id, dept_id) values ('1', '2', '3')

insert into Teacher (teacher_id, subject_id, dept_id) values ('1', '2', '4')

insert into Teacher (teacher_id, subject_id, dept_id) values ('1', '3', '3')

insert into Teacher (teacher_id, subject_id, dept_id) values ('2', '1', '1')

insert into Teacher (teacher_id, subject_id, dept_id) values ('2', '2', '1')

insert into Teacher (teacher_id, subject_id, dept_id) values ('2', '3', '1')

insert into Teacher (teacher_id, subject_id, dept_id) values ('2', '4', '1')

Create table If Not Exists Activity (user_id int, session_id int, activity_date date, activity_type
ENUM('open_session', 'end_session', 'scroll_down', 'send_message'))

Truncate table Activity

insert into Activity (user_id, session_id, activity_date, activity_type) values ('1', '1', '2019-07-20',
'open_session')

insert into Activity (user_id, session_id, activity_date, activity_type) values ('1', '1', '2019-07-20',
'scroll_down')
insert into Activity (user_id, session_id, activity_date, activity_type) values ('1', '1', '2019-07-20',
'end_session')

insert into Activity (user_id, session_id, activity_date, activity_type) values ('2', '4', '2019-07-20',
'open_session')

insert into Activity (user_id, session_id, activity_date, activity_type) values ('2', '4', '2019-07-21',
'send_message')

insert into Activity (user_id, session_id, activity_date, activity_type) values ('2', '4', '2019-07-21',
'end_session')

insert into Activity (user_id, session_id, activity_date, activity_type) values ('3', '2', '2019-07-21',
'open_session')

insert into Activity (user_id, session_id, activity_date, activity_type) values ('3', '2', '2019-07-21',
'send_message')

insert into Activity (user_id, session_id, activity_date, activity_type) values ('3', '2', '2019-07-21',
'end_session')

insert into Activity (user_id, session_id, activity_date, activity_type) values ('4', '3', '2019-06-25',
'open_session')

insert into Activity (user_id, session_id, activity_date, activity_type) values ('4', '3', '2019-06-25',
'end_session')

Create table If Not Exists Sales (sale_id int, product_id int, year int, quantity int, price int)

Create table If Not Exists Product (product_id int, product_name varchar(10))

Truncate table Sales

insert into Sales (sale_id, product_id, year, quantity, price) values ('1', '100', '2008', '10', '5000')

insert into Sales (sale_id, product_id, year, quantity, price) values ('2', '100', '2009', '12', '5000')

insert into Sales (sale_id, product_id, year, quantity, price) values ('7', '200', '2011', '15', '9000')

Truncate table Product

insert into Product (product_id, product_name) values ('100', 'Nokia')

insert into Product (product_id, product_name) values ('200', 'Apple')

insert into Product (product_id, product_name) values ('300', 'Samsung')

Truncate table Courses

insert into Courses (student, class) values ('A', 'Math')

insert into Courses (student, class) values ('B', 'English')

insert into Courses (student, class) values ('C', 'Math')

insert into Courses (student, class) values ('D', 'Biology')

insert into Courses (student, class) values ('E', 'Math')

insert into Courses (student, class) values ('F', 'Computer')

insert into Courses (student, class) values ('G', 'Math')

insert into Courses (student, class) values ('H', 'Math')

insert into Courses (student, class) values ('I', 'Math')

Create table If Not Exists Followers(user_id int, follower_id int)

Truncate table Followers

insert into Followers (user_id, follower_id) values ('0', '1')

insert into Followers (user_id, follower_id) values ('1', '0')

insert into Followers (user_id, follower_id) values ('2', '0')

insert into Followers (user_id, follower_id)

Create table If Not Exists MyNumbers (num int)

Truncate table MyNumbers

insert into MyNumbers (num) values ('8')

insert into MyNumbers (num) values ('8')

insert into MyNumbers (num) values ('3')

insert into MyNumbers (num) values ('3')

insert into MyNumbers (num) values ('4')

insert into MyNumbers (num) values ('5')

insert into MyNumbers (num) values ('6')

Create table If Not Exists Customer (customer_id int, product_key int)

Create table Product (product_key int)

Truncate table Customer

insert into Customer (customer_id, product_key) values ('1', '5')

insert into Customer (customer_id, product_key) values ('2', '6')

insert into Customer (customer_id, product_key) values ('3', '5')

insert into Customer (customer_id, product_key) values ('3', '6')

insert into Customer (customer_id, product_key) values ('1', '6')

Truncate table Product

insert into Product (product_key) values ('5')

insert into Product (product_key) values ('6')