Копия Prac 8 Zokirov Farrukh dbms
Download 207.41 Kb. Pdf ko'rish
|
Копия Prac 8 Zokirov Farrukh dbms
Practice work #8 Complex queries i. Select the names of all departments ii. Select the first names of all employees and hours that they work per week iii. Show the descriptions of all departments iv. Which employee works per week more than other employees? v. What is the family name of the manager of the Sales department? vi. Determine the employees that have the given and family names beginning on the same letter. vii. Make the manager of the Research department from the employee, that works per week more than all other employees Before: After:
viii. Which employee has worked the number of hours most approximate to the average for all workers? ix. How much time each employee spends in each department (in hours)? x. For each employee determine the departments in which he spends the greatest part of his time xi. Replace the employee tax file number 123-234-456 to 876-166-456 in such a way that the changes appear in all tables. Make that in just one query.
xii. Display the names of employees and their number of working hours per week so, that the results are sorted in ascending of hours of work and descending of names xiii. Display the departments names, described by the word "Innovation" xiv. Determine the name of the department that is described with the greatest number of words xv. Using the ALTER TABLE construction for each table, where there is a foreign key of Department presented, add the constraint condition for the cascade update and delete data xvi. Remove from the table with the departments the row with the number 001 xvii. Change the first name and the last name of the employee with tfn = 326-888-711 in their places Download 207.41 Kb. Do'stlaringiz bilan baham: |
ma'muriyatiga murojaat qiling