Assignment $3$

Please create these tables and answer all questions. Then share all your SQL codes and results as a pdf

file.

Create a Table Empl to store employee details as shown below and write

statements for following queries based on the table.

Consider the Empl table and write SQL command to get the following.

a$.$ Write a query to display EName and Sal of employees whose salaries are greater than

or equal to $2200?$

b$.$ Write a query to display details of employees who are not getting commission?

c$.$ Write a query to display the employee's name and salary of those employees who

don't have a salary in the range of $2500$ to $4000?$

d$.$ Write a query to display the name, job title, and salary of employees who don't have a

manager?

e$.$ Write a query to display the name of an employee whose name contains $"A"$ as the

third alphabet?

f$.$ Write a query to display the name of an employee whose name contains $"$ T $"$ as the last

alphabet?

g$.$ Write a query to display the name of employee whose name contains" M$"$ as First and

$"L"$ as the third alphabet?

h$.$ Write a query to display details of employees with the text "Not given", if the

commission is null?

Consider the following relational schema that manages the telephone bills of a mobile phone

company.

CUSTOMER $($ SSN$,$ Name, Surname, PhoneNum, Plan$)$

PRICINGPLAN $($ Code, ConnectionFee, PricePerSecond $)$

PHONECALL $($ SSN$,$ Date, Time, CalledNum, Seconds$)$

BILL $($ SSN$,$ Month, Year, amount $)$

$1-$ Write a trigger that after each phone call updates the customer's bill.

$2-$ Write a trigger that after insert of new customer we can keep their SSN and name in a new

table with the message $$inserted$.$ Please note that to keep this info after each insertion you

need to create a new table with any name you like. The same way we practice in our sessions.

Good Luck