Answered step by step
Verified Expert Solution
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 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 Problems
What departments are listed in the Departments table?
How Many Lockers are there, and what numbers are they?
Chapter Problems
Take your results from the chapter problems and sort them both ascending and descending.
Chapter Problems You will use the TYSQL Database for these questions
Show me products not made by Vendor DLL I want to see the products, and which vendor makes them.
Which products are at a price point between and dollars? Hint: Use the Between function
Chapter Problems
Which employees are named Jones and work in production
Which employees are named Jackson or work in accounting?
Chapter Problems
Which employee first names start with the letter SHint: 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 Problems You will use the TYSQL Database for these questions
From the OrderItems table, tell me the total price of all RGAN products sold in order
Chapter Problems You will use the TYSQL Database for these questions
Using the Soundex function, find a custname in the Customers table that sounds like Kids Palace.
Chapter 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 Problems You will use the TYSQL Database for these questions
List all the vendors who have or more products priced at or more.
Chapter Problems
Create a nested query in either the WPC or TYSQL database.
Chapter Problems
Which students have a full locker? Hint: Join the Student and Locker tables
Chapter 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 Problems
Perform a union from the TYSQL database
Step 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