HW 9 RSQLite 1. Make you have imported the database tables into your database. T
ID: 3875101 • Letter: H
Question
HW 9 RSQLite 1. Make you have imported the database tables into your database. These can be found on GS as esv files Write and submit the following RSQLite queries. Sketch out the result, or part of it, before trying to write the SOL query 2. Retrieve the names of all employees 3. Retrieve the names of all distinct employee names. 4. Retrieve the names of all employees whose name begins with the letter 'B 5. Retrieve the names and NI numbers (NI NO) of all employces 6. Retrieve details of employees who are over 31 years of age. 7. Retrieve details of employces who are between 31 years of age and 65 years of age. 8. Retrieve the average employee age, the age of the youngest employee and the age of the oldest employce. 9. Retrieve the names of all employees and the names of the departments in which they work. 10. Retrieve details of employees who share the phone extension 123.Explanation / Answer
LAB 10
1) A>Select employee name, room number, department number,phone extension, order by employee name ,department number
b)ALTER TABLE phone directory ALTER COLUMN 'extension' to 'phone'
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.