Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedimage text in transcribedimage text in transcribed

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' department

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Machine Learning And Knowledge Discovery In Databases European Conference Ecml Pkdd 2015 Porto Portugal September 7 11 2015 Proceedings Part 3 Lnai 9286

Authors: Albert Bifet ,Michael May ,Bianca Zadrozny ,Ricard Gavalda ,Dino Pedreschi ,Francesco Bonchi ,Jaime Cardoso ,Myra Spiliopoulou

1st Edition

3319234609, 978-3319234601

More Books

Students also viewed these Databases questions

Question

4. Describe the role of narratives in constructing history.

Answered: 1 week ago

Question

1. Identify six different types of history.

Answered: 1 week ago