Write a SUB Query to display name of the Instrument that are manufactured in USA (country). instrumentidintPKmanufacturerinstrument namemanufacturer idvarchar(255)intFKOHidcategoryintPKPK+varchar(255)intcountrycategory_iddescriptionidintintFKnamecategory_namevarchar(255)textcountry idFKOidintPKcountry_namevarchar(255)itemidintPKinstrument_idserial numberdescriptionyear_of_productioncountry_idpriceintFKvarchar(255)textNintFKdecimal(10,2)order_itemcustomer_orderidcustomer order_iditem_idpriceintPKcustomerintFKOidintPKFKOintvarchar(255)varchar(255)varchar(255)varchar(255)intFKcustomer idintidPKorder_timedelivery_addresspreferred delivery timeorder status idtime paidtimestampvarchar(255)timestampdecimal(10,2)customer nameemailuser_namepasswordconfirmation codeconfirmation_timecountry_idintFKtimestamptimestamptimestamptimestamptimestampdecimal(10,2)decimal(10,2)decimal(10,2)texttime canceledtimestampintNtime_completedtime_senttime_deliveredFKorder_statusidintPKtotal pricediscountfinal pricestatus namevarchar(255)activeboolEzzzzz

Answer: In this subquery First of all with the help of join we will connect three table Instrument,…

Answered: instrument category category name…

Engineering

Computer Engineering

instrument category category name varchar(255) varchar(255 rchar(255) instrument id Ezzzzz

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

Q: In what situations is it necessary to add a GROUP BY clause in a query?

A: Group By clause is used when we have to group the data into groups. It is used when we want to…

Q: LIST THE FIRST AND LAST NAMES OF ALL OWNERS WHO OWN A TWO-BEDROOM PROPERTY. USE THE IN OPERATOR IN…

A: Considering there are 2 tables:- OWNER: which holds the OWNER_NUM, FIRST_NAME, and LAST_NAME…

Q: Write a query to list the book number, title, and number of times each book has been checked out…

A: Query The query for viewing book number, title and the number of times each book had been checked…

Q: Write a query to list the book subject and the number of books in each subject. Limit your result to…

A: SELECT – to query data in the database INSERT – to insert data into a table UPDATE – to update…

Q: Use a query to compute the total of all purchases, the number of purchases, and the average purchase…

A: SQL query The Round() function is used to round off the number to the desired decimal places. The…

Q: Show the last name, the trip id, and arrival town of those pilots who have flown with more than 450…

A: Consider pilots table and it contains the attributes last name, trip id, arrival town, airport name.…

Q: Write a query to display the book number, title and cost of books that have the lowest cost of any…

A: Query: In general, the term query describes a question or request that is made by a user or another…

Q: Write a query to display the book number, title, and replacement cost for all books in the…

A: Query to display the book number, title , and replacement cost for all books in the "Database"…

Q: FROM SALESPERSON WHERE SPNUM= (SELECT SPNUM FROM CUSTOMER WHERE CUSTNUM=772): What is this subquery…

A: Given subquery SELECT SPNUM FROM CUSTOMER WHERE CUSTNUM=772

Q: Create a query to sort by city in ascending order and within each city the yrgoal in descending…

A: SQL Query: CREATE TABLE donors( donorid INT NOT NULL, name VARCHAR(20) NOT NULL, city…

Q: Animal animal_id name adopter_id Adopter adopter_id name Given the above data for an adoption…

A: Cross join : Each row from the first table is combined with each row from the second table using a…

Q: Write a query to display the employee number, last name, email address, title, and department name…

A: QUERY: SELECT EMP_NUM, EMP_LNAME,EMP_EMAIL, EMP_TITLE,DEPT_NAME FROM EMPLOYEE WHERE EMP_TITLE NOT…

Q: using the code write a query to display the movie number, movie title, movie cost, and movie genre…

A: 1. Create a table named MOVIE: - Define columns: - MOVIE_NUM as INT (Primary Key) -…

Q: Create a query to show the subject and the quantity of books in each category. Sort the results in…

A: Introduction: Important information to remember: Hey! I hope you're doing well! Thank you for your…

Question

Write a SUB Query to display name of the Instrument that are manufactured in USA (country).

instrument
id
int
PK
manufacturer
instrument name
manufacturer id
varchar(255)
int
FKO
Hid
category
int
PK
PK+
varchar(255)
int
country
category_id
description
id
int
int
FK
name
category_name
varchar(255)
text
country id
FKO
id
int
PK
country_name
varchar(255)
item
id
int
PK
instrument_id
serial number
description
year_of_production
country_id
price
int
FK
varchar(255)
text
N
int
FK
decimal(10,2)
order_item
customer_order
id
customer order_id
item_id
price
int
PK
customer
int
FKO
id
int
PK
FKO
int
varchar(255)
varchar(255)
varchar(255)
varchar(255)
int
FK
customer id
int
id
PK
order_time
delivery_address
preferred delivery time
order status id
time paid
timestamp
varchar(255)
timestamp
decimal(10,2)
customer name
email
user_name
password
confirmation code
confirmation_time
country_id
int
FK
timestamp
timestamp
timestamp
timestamp
timestamp
decimal(10,2)
decimal(10,2)
decimal(10,2)
text
time canceled
timestamp
int
N
time_completed
time_sent
time_delivered
FK
order_status
id
int
PK
total price
discount
final price
status name
varchar(255)
active
bool
Ezzzzz

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Step 3

VIEW

Step by step

Solved in 3 steps with 1 images

SEE SOLUTION Check out a sample Q&A here

Similar questions

Write a query to list the author last name, author first name and the book title and cost for each book written by the author “Xia Chiang”. Sort the result by the book title and then the costdescending
Write a query to display the eight departments in the LGDEPARTMENT table sorted by department name. In this query, you can either display Dept_Num or Dept_Name or both. It does not matter.
code of create table and insert table only please
Write a query to display the employee number, last name, first name, salary “from” date, salary end date, and salary amount for employees 99675, 53845, and 44035. Sort the output by employee number and salary “from” date.
Write a query to list the book title, checkout date, checkout due date and checkout in date for each book.
Write the following as MySQL query: Find the employee ID, first and last name, and salary for each employee whose salary ismore than $20,000 or who works in the shipping department. Use the UNION set operator. List the country ID, country name, city, and state/province. Be sure all country names areincluded in the result, regardless of whether there is no matching city and state/province. You have to use an outer join.
Write an SQL query using the UPDDATE and SET operator that willoverwrite all values containing 16 with 32 in the SupplierID attribute inthe Products table.
If a subquery is used in the FROM clause of a query, how are the subquery’s results referenced in other clauses of the query?
Write a query to get the maximum and minimum salary from the senators table (in that order).
Create a query to show the Technician Number, Last Name, First Name, Client Number,and Client Name for clients whose technician number is 23 (use Boolean variables).Save your query
Run a query or multiple queries if needed to report on final exam average based on thestudent’s age. Give an average for all students 40 and below and an average for all studentsover 40. This report will be used continuously so you cannot just figure out what 40 years agotoday was. You need to use the date to calculate their age somewhere in your solution
Insert into table customerPayment, columns customerOrderld and total result set returned from query a. Select columns id and total from table customerOrder where column orderStateld is equal to subquery i. (select column id from table orderState where column state is equal to "Payment received") Write Test Case 1 as a SQL join query to do the following a. Select using concatenation of columns firstName and lastName from table www customer as Customer b. Select customerOrderId from table customerPayment as "Customer Order" c. Select description from table product as Product d. Select total from table customerOrder as “Product Total" e. Join tables customerPavment, customerOrder, customer, product f. Order by column lastName from table customer Alter table purchaseOrder add column total as data type decimal size 7,2, not null, default value of 0.0