Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

SQL Homework - BADM 3 2 3 - USE SQL Please include a screenshot of your script and your results for each question. You can

SQL Homework - BADM 323- USE SQL
Please include a screenshot of your script and your results for each question.
You can attach the screen shots in a word doc or on this document.
Unless I clarify in the problem, you will be using the WPC database.
Chapter 2 Problems
What departments are listed in the Departments table?
How Many Lockers are there, and what numbers are they?
Chapter 3 Problems
Take your results from the chapter 2 problems and sort them both ascending and descending.
Chapter 4 Problems (You will use the TYSQL Database for these questions)
Show me products not made by Vendor DLL01. I want to see the products, and which vendor makes them.
Which products are at a price point between 4 and 12 dollars? (Hint: Use the Between function)
Chapter 5 Problems
Which employees are named Jones and work in production
Which employees are named Jackson or work in accounting?
Chapter 6 Problems
Which employee first names start with the letter S?(Hint: use the Like function)
From the Employees table, show me someone with the same initial as your first or last name. If nothing exists, that is ok, s
Chapter 7 Problems (You will use the TYSQL Database for these questions)
From the OrderItems table, tell me the total price of all RGAN01 products sold in order 20007
Chapter 8 Problems (You will use the TYSQL Database for these questions)
Using the Soundex function, find a cust_name in the Customers table that sounds like Kids Palace.
Chapter 9 Problems
What is the average overhead from the Department table? (Hint: use the AVG() function)
Which project has the highest hourly rate? (Hint: use the MAX () function)
Chapter 10 Problems (You will use the TYSQL Database for these questions)
List all the vendors who have 2 or more products priced at 4 or more.
Chapter 11 Problems
Create a nested query in either the WPC or TYSQL database.
Chapter 12 Problems
Which students have a full locker? (Hint: Join the Student and Locker tables)
Chapter 13 Problems
Make a Right Join of STUDENT and LOCKER selecting the StudentName where the LockerType is half
Which Students are not assigned to a locker? (Hint, Right join LOCKER and STUDENT selecting Student Name and Locker N
Chapter 14 Problems
Perform a union from the TYSQL database

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

The Accidental Data Scientist

Authors: Amy Affelt

1st Edition

1573877077, 9781573877077

More Books

Students also viewed these Databases questions