Answered step by step
Verified Expert Solution
Question
1 Approved Answer
i tried to put the script but it is too long so i could not able to put the script . i can send you
i tried to put the script but it is too long so i could not able to put the script . i can send you when you request me I think.
1. List the ID's of the volunteers that have not worked. 2. List all the product IDs, product names, suggested price and product types. Order by product name 3. List the names of the sponsor companies that donated in July of 2008 4. List all the different prices suppliers have for 'Tasty Meat" product 5. List the ID, first name and last name of those employees who have made a transaction. Do not include duplicates in your result. 6. Display all different types of maintenance which are done by employees. Make sure there are no duplicates 7. List the names of those corporate sponsors whose donations are between 10,000 and 25,000 8. Find employee first names, last names, and salaries for those employees who make between $35,000 and $47,000 and are from St Paul, Maplewood, or Bloomington. Use the IN operator. Order results by last name. 9. List the employee ID, employee first and last namewhose salary is greater than $75,000. Order the data by the employee's last name 10. Give the first and last name of the employee whose transaction amount equals 14 dollars using a subguery. 11. Find the product ID and product purchased price of the Zoo Magnet. Use a Subquery. 12. List the ID, first name, and last name of employees who work in the 'Finance' department 1. List the ID's of the volunteers that have not worked. 2. List all the product IDs, product names, suggested price and product types. Order by product name 3. List the names of the sponsor companies that donated in July of 2008 4. List all the different prices suppliers have for 'Tasty Meat" product 5. List the ID, first name and last name of those employees who have made a transaction. Do not include duplicates in your result. 6. Display all different types of maintenance which are done by employees. Make sure there are no duplicates 7. List the names of those corporate sponsors whose donations are between 10,000 and 25,000 8. Find employee first names, last names, and salaries for those employees who make between $35,000 and $47,000 and are from St Paul, Maplewood, or Bloomington. Use the IN operator. Order results by last name. 9. List the employee ID, employee first and last namewhose salary is greater than $75,000. Order the data by the employee's last name 10. Give the first and last name of the employee whose transaction amount equals 14 dollars using a subguery. 11. Find the product ID and product purchased price of the Zoo Magnet. Use a Subquery. 12. List the ID, first name, and last name of employees who work in the 'Finance' departmentStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started