Answered: Lab Exercise • Use the online database…

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Related questions

Question

plz quickly???

Lab Exercise
• Use the online database provided by Live SQL in Find option.
To take an overview about any schema select Find option in live sql, then to
access a table in your queries from other schema write shcema name before
table name schema_abbreviation.table_name
For each query screenshot the SQL code and the result table.
Arrange everything in 1 file by the query number.
Upload your work to Blackboard as a PDF file.
A) Work on (customers), (orders), and (stores) tables from co schema as
needed:
1. List customer ids, customers full name and order ids, using left join.
2. List stores names of the refunded orders, using subquery.
3. List full information of the orders of the customer name 'Victor Morris',
using subquery.

Transcribed Image Text:Columns %23 Column Туре Length Precision Scale Nullable Semantics ORDER ID Com NUMBER 22 No Auto-incrementing primary key 2 ORDER DATETIME TIMESTAMP(6) 11 No When the order was placed 3 CUSTOMER ID NUMBER 22 No Who placed this order What state the order is in. Valid values PAID - money has been received from the products have been dispatched to customer has received the order CANCE the order REFUNDED - there has been. money has been retumed to the custom 4 ORDER STATUS VARCHAR2 40 No Character 5. STORE ID NUMBER 22 No Where this order was placed Columns Column Type Length Precision Scale Nullable Semantics Comment CUSTOMER ID NUMBER 22 No Auto-incrementing primary key 2 EMAIL ADDRESS VARCHAR2 1020 No Character The email address the person uses to access the account 3 FULL NAME VARCHAR2 1020 No Character What this customer is called "yyers Constraints 23 Column Туре Length Precision Scale Nullable Semantics Co 1 STORE ID NUMBER 22 No Auto-incrementing priman STORE NAME VARCHAR2 1020 No Character What the store is called 3. WEB ADDRESS VARCHAR2 400 Yes Character The URL of a virtual store 4 PHYSICAL ADDRESS VARCHAR2 2048 Yes Character The postal address of this LATITUDE NUMBER 22 Yes The north-south positkan of 6. LONGITUDE NUMBER The east-west position of a 22 Yes 7. LOGO BLOB 4000 Yes An image used by this store LOGO MIME_TYPE VARCHAR2 2048 Yes Character The mime-type of the store LOGO FILENAME VARCHAR2 2048 Yes Character The name of the file loaded in 9 VARCHAR2 2048 Yes Character The character set used to enco 10 LOGO CHARSET DATE 7. Yes The date the image was last ch 11 LOGO LAST_UPDATED

Expert Solution