Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Instructions Your manager is asking you for data from various company databases. For each of the following ten data requests, write only two SQL statements:

image text in transcribed

image text in transcribed

image text in transcribed

Instructions Your manager is asking you for data from various company databases. For each of the following ten data requests, write only two SQL statements: - The SQL statement to specify which database to use - The SQL statement to retrieve the information requested in the order requested (if any) Do not include any other lines in your answer including SHOW or DESC statements. I highly recommend that you execute each SQL statement in Cloud 9 to be sure that it runs without error and that it provides an answer that makes sense. Save your queries in individual files named as indicated after each question. You should end up with ten files named Q1.sql - Q10.sql. Refer to the page named Submitting Your SQL Assignments in the Class Resources folder near the top of this course for instructions. Questions The following questions are worth 3 points each. From the Sales Orders Database 1. "Show me all the information on our employees." (save as Q1.sql) 2. "Show me a list of cities, in alphabetical order, where our vendors are located, and include the names of the vendors we work with in each city." (save as Q2.sql) The following questions are worth 3 points each. From the Sales Orders Database 1. "Show me all the information on our employees." (save as Q1.sql) 2. "Show me a list of cities, in alphabetical order, where our vendors are located, and include the names of the vendors we work with in each city." (save as Q2.sql) From the Entertainment Agency Database 3. "Give me the first and last names and phone numbers of all our agents, and list them in last name/first name order." (save as Q3.sql) 4. "List all engagement numbers and their associated start dates. Sort the records by date in descending order and by engagement number in ascending order." (save as Q4.sql) From the School Scheduling Database 5. "What kinds of titles are associated with our faculty?" (save as Q5.sql) 6. "List the names and complete phone numbers of all our staff, and sort them by last name and first name." (save as Q6.sql) From the Bowling League Database 7. "List all of the team names in alphabetical order." (save as Q7.sql) 8. "Show me a list of bowler names and street addresses, and sort it in alphabetical order by only last name. " (save as Q8.sql) From the Recipes Database 9. "Show me a list of the names of all the ingredients we currently keep track of." (save as Q9.sql) 10. "Show me all the recipe IDs, titles and classIDs, and sort them by the name of the recipe in alphabetical order." (save Q10.5ql)

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

Step: 3

blur-text-image

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

More Books

Students also viewed these Databases questions

Question

Explain the difference between price- takers and price- setters.

Answered: 1 week ago