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

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

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!