EBK CONCEPTS OF DATABASE MANAGEMENT
8th Edition
ISBN: 8220100706004
Author: Last
Publisher: Cengage Learning US
expand_more
expand_more
format_list_bulleted
Question
Chapter 1, Problem 7TDE
To determine
To provide the sum of balances for all customers who are represented by Rafael Campos.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
In the Summary sheet, calculate average and median sales and commissions. Use the named ranges shown in cells A23:B26.
In cell B5, enter a formula to calculate the average annual sales for all sales associates. Use the named range AnnualSales.
Use SQL and TAL Distributors database to complete the following questions:TAL Distributors is running a promotion that is valid for up to 20 days after an order is placed. List the order number, customer number, customer name, and the promotion date for each order. The promotion date is 20 days after the order was placed.
Solve the following queries:
Display all details of the item table.
Display item name, section and price of all garments.
Display the number of customers from Muscat and their total amount.
Display the average of all garment items sold.
5. Display the maximum and minimum amount of the customer.
Display all items ending with ‘et’ and are décor.
Display customer number and location of customer with amount not less than 50.
Display all garments and décor items.
Display all décor items with prices not less than 10.
Display item name, section and price of all accessories with price less than equal to 5.
Display the average amount of Nizwa city customers.
Display all items with price between 5 and 10. (without using between)
Remove duplicate values from the section column of the item table.
Display item name, price, customer number of C2 customer.
Chapter 1 Solutions
EBK CONCEPTS OF DATABASE MANAGEMENT
Ch. 1 - Prob. 1RQCh. 1 - Prob. 2RQCh. 1 - Prob. 3RQCh. 1 - Prob. 4RQCh. 1 - Prob. 5RQCh. 1 - Prob. 6RQCh. 1 - Prob. 7RQCh. 1 - Prob. 8RQCh. 1 - Prob. 9RQCh. 1 - Prob. 10RQ
Ch. 1 - Prob. 11RQCh. 1 - Prob. 12RQCh. 1 - Prob. 13RQCh. 1 - Prob. 14RQCh. 1 - Prob. 15RQCh. 1 - Prob. 16RQCh. 1 - Prob. 17RQCh. 1 - Prob. 18RQCh. 1 - Prob. 19RQCh. 1 - Prob. 20RQCh. 1 - Prob. 21RQCh. 1 - Prob. 22RQCh. 1 - Prob. 23RQCh. 1 - Prob. 1TDECh. 1 - Prob. 2TDECh. 1 - Prob. 3TDECh. 1 - Prob. 4TDECh. 1 - Prob. 5TDECh. 1 - Prob. 6TDECh. 1 - Prob. 7TDECh. 1 - Prob. 8TDECh. 1 - Prob. 9TDECh. 1 - Prob. 10TDECh. 1 - Prob. 11TDECh. 1 - Prob. 12TDECh. 1 - Prob. 1CATCCh. 1 - Prob. 2CATCCh. 1 - Prob. 3CATCCh. 1 - Prob. 4CATCCh. 1 - Prob. 5CATCCh. 1 - Prob. 6CATCCh. 1 - Prob. 7CATCCh. 1 - Prob. 8CATCCh. 1 - Prob. 9CATCCh. 1 - Prob. 10CATCCh. 1 - Prob. 11CATCCh. 1 - Prob. 12CATCCh. 1 - Prob. 13CATCCh. 1 - Prob. 14CATCCh. 1 - Prob. 15CATCCh. 1 - Prob. 16CATCCh. 1 - Prob. 17CATCCh. 1 - Prob. 1SCGCCh. 1 - Prob. 2SCGCCh. 1 - Prob. 3SCGCCh. 1 - Prob. 4SCGCCh. 1 - Prob. 5SCGCCh. 1 - Prob. 6SCGCCh. 1 - Prob. 7SCGCCh. 1 - Prob. 8SCGCCh. 1 - Prob. 9SCGCCh. 1 - Prob. 10SCGCCh. 1 - Prob. 11SCGCCh. 1 - Prob. 12SCGC
Knowledge Booster
Similar questions
- Ensure that the only legal values for the BDRMS column in the CONDO_UNIT table are 1, 2, or 3.arrow_forwardWrite SQL queries for the following statements (Use only Cartesian product and join) Show name of customer and orderno who have placed any order and belong to “Islamabad”. Show name of customer and product description who placed order before 2016/2/23. Show data of those customer who place two or more than two order in same day. Show data of those product that are purchased by those customer who neither belong to “Rawat” nor ”Rawalpindi” nor ”Chakwal”. Show cname of those customer who order a product with low price. Show description, vendor and order date that are order by after 2016/2/23 and order placed by other Than “Bilal”. Show data of products who have ordered by more than 3 time. Show detail of those products which not purchased by any customer. Show list of customer name and product vendor they have ordered recently. Show Customer city and invoice quantity of those product whose quantity is minimum.arrow_forwardConsider the following Customers table and express in relational algebra each of the questions below: Customers customerNO Name Address City Zip 100 Salma Amri Street freedom Muscat 213 101 Ayman Zawamri Street 11 September Nizwa 210 102 Said Raafit Street 13 October Salalah 211 103 Salem Samri Street Yasamine Sur 205 List the names of customers who are from the city of “Muscat”. List the details of customers who are not from “Nizwa”. List the names and addresses of customers having the numbers 101 or 103.arrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
Np Ms Office 365/Excel 2016 I NtermedComputer ScienceISBN:9781337508841Author:CareyPublisher:Cengage
A Guide to SQLComputer ScienceISBN:9781111527273Author:Philip J. PrattPublisher:Course Technology Ptr
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr