FROM SALESPERSON WHERE SPNUM= (SELECT SPNUM FROM CUSTOMER WHERE CUSTNUM=772): What is this subquery determining? A: Which salesperson number is associated with customer number 772 B: Which customer number is associated with 772 salesperson C: Which salesperson number is associated with 772 customers D: which customer number is associated with salesperson number 772

FROM SALESPERSON WHERE SPNUM= (SELECT SPNUM FROM CUSTOMER WHERE CUSTNUM=772): What is this subquery determining? A: Which salesperson number is associated with customer number 772 B: Which customer number is associated with 772 salesperson C: Which salesperson number is associated with 772 customers D: which customer number is associated with salesperson number 772

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Q: The query should list all employees whose Position begins with the word greenhouse and whose weekly…

A: These question answer is as follows,

Q: Task 4: Use the IN operator to find the ID, first name, and last name of each customer for which as…

A: The above question is solved in step 2 :-

Q: Write the SQL code that will compute the total number of hours worked and total amount billed by all…

A: To compute the total number of hours worked and total amount billed by all workers, we need to have…

Q: if you want to get username from user table how to do this query O SELECT USERNAME FROM USER GET…

A: The USER_NAME() function returns the database user name based on the specified id. If id is not…

Q: Display the names of the books sold by the bookstore which were published by a publisher from New…

A: As per our guidelines, we are supposed to answer only 1st three parts. Kindly repost the remaining…

Q: t the title of all books in the same category as books previously purchased by customer 1007. Don’t…

A: Lets see the solution.

Q: Write a SELECT statement that uses a correlated subquery to return one row per customer,…

A: SYNTAX - SELECT cust.first_name, cust.last_name, o.order_id, o.order_date, o.total_quantityFROM…

Q: Write a query to produce the total number of hours round to 1 digit and charges round to 2 digits…

A: The Sql Query corresponding to the above problem is solved as : SELECT Proj_Num,…

Q: Changes this SQL query statement to Xquery Statements select distinct company_name from…

A: Hey, since multiple questions posted, we will answer first question according to our policy. If you…

Q: Use select statements to create queries that answer the following questions. Only provide the…

A: Queries: 1) SELECT ItemDescription, Price FROM Flower WHERE ItemDescription LIKE '%Bouquet%' AND…

Q: 7. List all customers who were referred to the bookstore by another customer. List each customer’s…

A: The answer to the question is given below:

Q: For each order id, calculate the total of the Order. The total of an order is the sum of the prices…

A: For each order id, calculate the total of the Order. The total of an order is the sum of the prices…

Q: ServiceCategory CategoryNum CategoryDescription 1 Plumbing 2 Heating/Air Conditioning 3 Painting 4…

A: The query to List the location number and unit number for every condo whose square footage is equal…

Q: The code: "SELECT SupplierlID FROM Products Order By SupplierName DESC;" extracts data from Products…

A: Sol1: Current procedure terminology (CPT) is a code such as reflex testing and is an integrated part…

Q: salary is above 4000 and job_id starts with a letter “S”

A: 1. SELECT * FROM employee WHERE (salary > 4000) AND job_id LIKE 'S%' 2. SELECT *,…

Question

26.In the given query, SPNAME is salesperson name,
SPNUM is salesperson number, and CUSTNUM is
customer number.
SELECT SPNAME
FROM SALESPERSON
WHERE SPNUM=
(SELECT SPNUM
FROM CUSTOMER
WHERE CUSTNUM=772):
What is this subquery determining?
A: Which salesperson number is associated with customer
number 772
B: Which customer number is associated with 772
salesperson
C: Which salesperson number is associated with 772
customers
D: which customer number is associated with salesperson
number 772

Expert Solution

This question has been solved!

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

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions

Write an SQL query using the IN operator to show all customers residingin the following zip codes: 91508, 91510, 33111
The Colombia City office of StayWell indicated that there is a new tenant by the name of Yigit Yilmaz staying at the property with an ID of 13. You need to include this new resident in the RESIDENTS table.
Write a short C program that declares and initializes (to any value you like) a double, an int, and a char. Next declare and initialize a pointer to each of the three variables. Your program should then print the address of, and value stored in, and the memory size (in bytes) of each of the six variables.
From the following query, identify the value of City: INSERT INTO Customers ( CustomerName, ContactName, Address, City, PostalCode, Country) VALUES (‘Cardinal,”Tom B. Erichsen”,”Skagen 21”, “Stavanger,” “4006Norway’);
List all vendors with their address(city, state,zipcode) for all the vendors who have credited account (credit total>0)) Hint:Vendors & Invoices tables with credit total column WHERE vendors.vendor id = invoices.vendor id AND CREDIT_TOTAL>0; %3D
Write the SQL code that will produce the results shown as below. Write the SQL code to calculate the ASSIGN_CHARGE values in the ASSIGNMENT table. Note that ASSIGN_CHARGE is a derived attribute that is calculated by multiplying ASSIGN_CHG_HR by ASSIGN_HOURS. Write the SQL code that will yield the total number of hours worked for each employee and the total charges stemming from those hours worked. The result is shown as below.
query no 2 is select avg(CustBal) from Customer where CusState='WA' GROUP BY city. Here aggregate function avg is used to calculate average of customer balance.next where statement is used to filter the customer who live in Washington state and at last group by clause is used to show the balance city wise.
What type of situation requires using a subquery?
When should a subquery be nested in a HAVING clause?
The CLARITY_SER table contains information about providers. Which of the following queries successfully creates a temp table that stores the names of providers who are pharmacists (PHARMACIST_YN = 'Y')? T ONE OF THE FOLLOWING (2 PTS) A. SELECT PROV_NAME INTO #Pharm FROM CLARITY_SER WHERE PHARMACIST YN = 'Y" B. SELECT PROV_NAME FROM CLARITY_SER WHERE PHARMACIST YN = 'Y' INTO #Pharm C. SELECT PROV_NAME FROM CLARITY_SER INTO #Pharm WHERE PHARMACIST_YN = 'Y' D. SELECT INTO #Pharm FROM CLARITY_SER.PROV_NAME WHERE PHARMACIST_YN = 'Y' DONT BEDRE BESONDERE IHREN ENTEN KOEN ORIGIN SEISINGENİN RENAUER BER
What are the types of subquery?