QuestionQuestion

Consider the vendor table below and write a query to display the vendor information, explicitly showing the vendor name, state, and catalog. Order the list by the vendor name and then by the state. Restrict the list to those vendors located in VA,MD, and PA.
Discussion Question:
You have been tasked to write a set of queries for your management company to display assets, by owner.

Consider the tables below and write a set of Queries to retrieve all of the attributes from the asset and owner tables to show the assets, by owner. You do not have to write join conditions to accomplish this task since simple queries will suffice. Consider which functions you might use in order to sort the data by owner and summarize asset values. Be unique in your response and do not duplicate other responses.
Asset

Asset_ID    Asset_Name             Asset_Type    Asset_Value      Owner_ID
1                Primary Residence       Real Estate         $1M                1000
2                Vacation Residence    Real Estate         $2M                1000
3                         Boat                     Vehicle                500k                2000
4                Vacation Residence    Real Estate         $10M               1000

Owner
Owner_ID          Owner_First_Name      Owner_Last_Name
1000                            Bruce                         Wayne
2000                            Tony                           Stark

Solution PreviewSolution Preview

This material may consist of step-by-step explanations on how to solve a problem or examples of proper writing, including the use of citations, references, bibliographies, and formatting. This material is made available for the sole purpose of studying and learning - misuse is strictly forbidden.

Query 1 : display all assert by owner
SELECT o.OWNER_ID ,o.OWNER_FIRST_NAME, o.OWNER_LAST_NAME,
ast.ASSET_ID, ast.ASSET_NAME, ast.ASSET_TYPE, '$' || ast.ASSET_VALUE || 'k' as "ASSET_VALUE"
FROM ASSET ast,OWNER o
where o.OWNER_ID = ast.OWNER_ID
order by o.OWNER_ID
;...
$18.00 for this solution

PayPal, G Pay, ApplePay, Amazon Pay, and all major credit cards accepted.

Find A Tutor

View available Database Development Tutors

Get College Homework Help.

Are you sure you don't want to upload any files?

Fast tutor response requires as much info as possible.

Decision:
Upload a file
Continue without uploading

SUBMIT YOUR HOMEWORK
We couldn't find that subject.
Please select the best match from the list below.

We'll send you an email right away. If it's not in your inbox, check your spam folder.

  • 1
  • 2
  • 3
Live Chats