Question: 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 testtext Emp city Emp salary 10 text Insen the following data into

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!