Answered step by step
Verified Expert Solution
Question
1 Approved Answer
2. Create the seminar table Field Siure Data T text test text Emp city Emp salary 10 text Insen the following data into the seminar
2. Create the seminar table Field Siure Data T text test text Emp city Emp salary 10 text Insen the following data into the seminar table which you have created Seminar table Sem no S1 S2 Sem name database Sem cost 1000 1200 insert the following data into the employee table which you have created Employee table Emp no El E2 ?? E4 E5 E6 Sem no S2 S2 SI MaryamS Mohamed Sharjah Sharjah 15000 12000 8500 16000 22000 9000 Dubai ona Sharjah Aleem Dubai ReemSharjah S2 Write/run the SQL commands for the following queries .List the employee name and the seminar name for the employees who join S2. 6. Create a new table from a query which displays the names of the employees and their salary who live in Sharjah and their salary is greater than $10000. Name the new table "Sharjahemp" 7 Display the first three characters of the employee name whose city is Sharjah. SWhat is the number of employees in each seminar for the seminars which have more than two employees? Display the seminar number and the number of empl 9. Add 500 Dirhams to the employees whose salary is less than 15000. Display the employee name, the old salary and the new salary. Name the new field "newsalary" oyees
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started