Question: For questions involving SQL, return only the specified info using a single query and add a comment with your answer. 1. Using the course database,

For questions involving SQL, return only the specified info using a single query and add a comment with your answer. 1. Using the course database, suggest a suitable domain for each attribute of PRODUCT. 2. Find the age of the oldest employee at 'Tiny Clothes'. 3. Are there any employees under the age of 50 whose name contains the letter 'R? 4. Retrieve the employment number of the sales department manager. 5. How many departments are there at 'Tiny Clothes'? 6. What is Carol's customer number? 7. Who works in Department D2? 8. How many white-colored products are in stock? 9. Use a LEFT JOIN to join EMPLOYEE and DEPARTMENT (in that order) on DEPT_NO. For questions involving SQL, return only the specified info using a single query and add a comment with your answer. 1. Using the course database, suggest a suitable domain for each attribute of PRODUCT. 2. Find the age of the oldest employee at 'Tiny Clothes'. 3. Are there any employees under the age of 50 whose name contains the letter 'R? 4. Retrieve the employment number of the sales department manager. 5. How many departments are there at 'Tiny Clothes'? 6. What is Carol's customer number? 7. Who works in Department D2? 8. How many white-colored products are in stock? 9. Use a LEFT JOIN to join EMPLOYEE and DEPARTMENT (in that order) on DEPT_NO
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
