LConsultantConsitNum LastName FirstName Street19ChristopherPatrickSarahTom35$1ClientClientNum ClientName175299322363405449TurnerJordanAllenShields458Hershey, JarrodGoduto, SeanTwo CraftyCousinsPrichard's Pizza &Salazar, JasonFisherman's SpotShopSeymour,LindseyBonnie's BeautifulBoutiqueYates, NickHowler, LauraHarpersburg BankMarketPoint SalesStreet135 Mill Street12 Saratoga Parkway9787 NCR 350West501 Air Parkway733458554 Brown Dr.2287 Port Rd.82 Elliott St.373 Lincoln Ln.322867322363867826677733826867WorkOrdersOrderNum OrderDate ClientNum671019/6/2018673139/7/20189/10/20186742467838679496825268868689799/10/20189/10/20189/12/20189/14/20189/17/20184091 Brentwood Ln9565 Ridge Rd.231 Day Rd.1368 E. 1000 S.65 Forrest Blvd.826 Host St.CityTri CityEastonLiztonSunlandCityEastonTri CitySunland68252688686897968979Lizton56473 Cherry Tree Dr Easton FL.49 Elwood Ave.Harpersburg FL.AmoTri CityStateFLVR39WA33FLDIB 5SA44AC65DA11StateFLFLFLSunlandLiztonHarpersburg FL.FastonFL.OrderLineOrderNum TaskID67101S17767313LASI67424MO4967424UP3867838LAB167949PI546794967949FLFLFLZipCode Hours32889339983434439876339983123440ZipCode Balance CreditLimit ConsitNum33998 $1,904.55 $2,500.0032889 $2,814.55 $5,000.0039876 $8,354.00 $10,000.00191922344661034344 $7,335.55 $10,000.00Rate$22.50$22.50$20.00$15.009/24/20189/24/20189/27/20189/27/2018$557.7032889 $4,053.8035$900.75 $2,500.00$4,113.40 $7,500.00 19$5,000.00$7,500.0039876 $2,523.80 $2,500.0034344 $3,658.05 $5,000,0031234 $6,824.55 $10,000.0033998 $3,089.00 $5,000.00ScheduledDate QuotedPrice9/10/20189/12/20189/14/20189/14/20189/20/20189/21/20189/21/20189/21/201835$144.00$104.00$65.000$185.00$104,00$50.00$88,00$126.00$50.00$200.00$77.00$970.00INESAT352219TasksTaskIDAC65DALID185HA63HIBILASIMÖ49OT99PISASA44S177S191UP38VR39WABBWC19DescriptionAccessoriesData recovery majorData recovery minorHardware majorHardware minorLocal area networking (LAN)MobilityOther workPrinting issuesSoftware majorSoftware minorSecurity install/repairUpgradesVirus removalWide area networking (WAN)Web connectivity|| DRMCategory PriceACC$80.00$175.00$50.00$225.00$165.70$104.00$65.00$99.99$50.00DRMHANDHANILANMOBPRISOMSOMSIRUPGVIRWANWEC$200.00$144.00$126.00$185.00$90.00$130.00$75.005. List the number and date of all orders that were placed on 9/10/2018 or that were placed by aclient whose consultant number is 19.6. List the number and date of all orders that were placed on 9/10/2018 by a client whoseconsultant number is 35.7. List the number and date of all orders that were placed on 9/10/2018 but not by a client whoseconsultant number is 35.

SELECT OrderNum, OrderDateFROM WorkOrdersWHERE OrderDate = '2018-09-10' OR ClientNum IN (SELECT…

5. List the number and date of all orders that were placed on 9/10/2018 or that were placed by a client whose consultant number is 19. 6. List the number and date of all orders that were placed on 9/10/2018 by a client whose consultant number is 35. 7. List the number and date of all orders that were placed on 9/10/2018 but not by a client whose consultant number is 35.

5. List the number and date of all orders that were placed on 9/10/2018 or that were placed by a client whose consultant number is 19. 6. List the number and date of all orders that were placed on 9/10/2018 by a client whose consultant number is 35. 7. List the number and date of all orders that were placed on 9/10/2018 but not by a client whose consultant number is 35.

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: For each Consultant, list the Consultant last name, the average balance of the consultant’s clients,…

A: SQL query: The query is to obtain the consultant's last name, the average balance of the…

Q: Observe the table ENROLLMENT: ENROLLMENT StudentName MajorID MajorName English StudentID 111 Joe E…

A: A deletion anomaly is the accidental loss of data because of cancellation of different data.

Q: Q1: Show all the information from the employee table. SELECT * FROM emp; Q2: Show the employees…

A: The select statement is used to select a value from the database. The selected columns are displayed…

Q: List the invoice number and invoice date for each invoice created for the customer James Gonzalez

A: SQL queries are a set of instructions given to the database to retrieve specific data. SQL was…

Q: Normalize the following unnormalized table using the three normalization rules and describe each…

A: Dear Student, The three normalization rules are nothing but the normal form conversion of the table,…

Q: lter table product so that column productlype is an integer instead of a varchar, not null should be…

A: Lets see the solution.

Q: If the functional dependencies are consistent with the above relation, put TRUE. If they are not,…

A: functionally dependent defines the relationship between attributes, how they are related. A-> B…

Q: 1. List the address, square footage, owner number, services ID, number of estimated hours, and…

A: List the address, square footage, owner number, service ID, number of estimated hours, and number of…

Q: . Which manufacturers are located in the city of New York? Show the manufacturer's name, state,…

A: First, three parts will be answered. SQL query: 1) In this query, the SELECT statement along with…

Q: ITEM (ITEM ID, DESCRIPTION, ON HAND, CATEGORY, LOCATION, PRICE, NUM, INVOICE _ DATE, CUST PRICE))…

Q: access databases Normalization Exercise Represent this table as a collection of tables in 3NF:…

A: The key for the given relation is (StudentNumber, CourseNumber) The partial functional dependency…

Q: Which quality of the table demonstrates why it is not in first normal form? A: There are only…

A: Here, we have to explain why the table is not in first normal form.

Q: Question 2: For the following table find the relevant Functional Dependencies and resolve them till…

A: Third normal form: The Third Normal Form (3NF) is a normal form used in the normalization process of…

Q: Given the following Staff2 table, please write a SQL statement to find the superno who supervised 4…

A: To find the superno where COUNT(superno) is greater than or equal to 4.

Q: Note: sales records is in sales table, purchase records are in purchases table, inventory records…

A: 1) since u have given only table names , i will assume the tables details as follows *…

Q: Course evaluation must have a student, the students relation contains a unique student id, full name…

A: An Entity–relationship model (ER model) describes the structure of a database with the help of a…

Q: Hotels Rooms Hotel ID Room Number. Zipcode Room Type Reservation City 太 Rates Room location…

A: the below is relational schema for above given ER diagram

Q: This is data base question. Schema is also uploaded. 1. Show all the movie names with their type…

A: As per our company guidelines we are supposed to answer ?️only first 3️⃣ sub-parts. Kindly repost…

Q: Select the best answer from the given choices: Using the company schema, when creating the…

A: Actually, database is used to stores the data.

Q: Your university runs many hundreds of courses each semester and needs to keep track of key…

A: the code is given below:-

Q: Check the following statement: select sysdate Today, (select count (*) from departments)…

A: Solution :

Q: For each sale made on June 1, 2015, show the following information: CustomerID, Customer name…

A: Hey, since there are multiple questions posted, we will answer first question. If you want any…

Q: CUST_ID 78 CUST _ID 54 NAME YORK UNIVERSITY NAME SENECA COLLEGE LOCATION…

A: Given, CUST _ID NAME LOCATION SALES_REP 78 YORK UNIVERSITY NORTH YORK ANDRE MARTIN 54 SENECA…

Concept explainers

SQL Query

Structured Query Language is the full form of SQL. It is one of the standard languages to deal with the relational database. It is used to insert, update, delete, and search the records stored in a RDBMS. The relational databases are created and managed by using SQL.

Question

L
Consultant
ConsitNum LastName FirstName Street
19
Christopher
Patrick
Sarah
Tom
35
$1
Client
ClientNum ClientName
175
299
322
363
405
449
Turner
Jordan
Allen
Shields
458
Hershey, Jarrod
Goduto, Sean
Two Crafty
Cousins
Prichard's Pizza &
Salazar, Jason
Fisherman's Spot
Shop
Seymour,
Lindsey
Bonnie's Beautiful
Boutique
Yates, Nick
Howler, Laura
Harpersburg Bank
MarketPoint Sales
Street
135 Mill Street
12 Saratoga Parkway
9787 NCR 350
West
501 Air Parkway
733
458
554 Brown Dr.
2287 Port Rd.
82 Elliott St.
373 Lincoln Ln.
322
867
322
363
867
826
677
733
826
867
WorkOrders
OrderNum OrderDate ClientNum
67101
9/6/2018
67313
9/7/2018
9/10/2018
67424
67838
67949
68252
68868
68979
9/10/2018
9/10/2018
9/12/2018
9/14/2018
9/17/2018
4091 Brentwood Ln
9565 Ridge Rd.
231 Day Rd.
1368 E. 1000 S.
65 Forrest Blvd.
826 Host St.
City
Tri City
Easton
Lizton
Sunland
City
Easton
Tri City
Sunland
68252
68868
68979
68979
Lizton
56473 Cherry Tree Dr Easton FL.
49 Elwood Ave.
Harpersburg FL.
Amo
Tri City
State
FL
VR39
WA33
FL
DIB 5
SA44
AC65
DA11
State
FL
FL
FL
Sunland
Lizton
Harpersburg FL.
Faston
FL.
OrderLine
OrderNum TaskID
67101
S177
67313
LASI
67424
MO49
67424
UP38
67838
LAB1
67949
PI54
67949
67949
FL
FL
FL
ZipCode Hours
32889
33998
34344
39876
33998
31234
40
ZipCode Balance CreditLimit ConsitNum
33998 $1,904.55 $2,500.00
32889 $2,814.55 $5,000.00
39876 $8,354.00 $10,000.00
19
19
22
34466
10
34344 $7,335.55 $10,000.00
Rate
$22.50
$22.50
$20.00
$15.00
9/24/2018
9/24/2018
9/27/2018
9/27/2018
$557.70
32889 $4,053.80
35
$900.75 $2,500.00
$4,113.40 $7,500.00 19
$5,000.00
$7,500.00
39876 $2,523.80 $2,500.00
34344 $3,658.05 $5,000,00
31234 $6,824.55 $10,000.00
33998 $3,089.00 $5,000.00
ScheduledDate QuotedPrice
9/10/2018
9/12/2018
9/14/2018
9/14/2018
9/20/2018
9/21/2018
9/21/2018
9/21/2018
35
$144.00
$104.00
$65.000
$185.00
$104,00
$50.00
$88,00
$126.00
$50.00
$200.00
$77.00
$970.00
INESAT
35
22
19
Tasks
TaskID
AC65
DALI
D185
HA63
HIBI
LASI
MÖ49
OT99
PISA
SA44
S177
S191
UP38
VR39
WABB
WC19
Description
Accessories
Data recovery major
Data recovery minor
Hardware major
Hardware minor
Local area networking (LAN)
Mobility
Other work
Printing issues
Software major
Software minor
Security install/repair
Upgrades
Virus removal
Wide area networking (WAN)
Web connectivity
|| DRM
Category Price
ACC
$80.00
$175.00
$50.00
$225.00
$165.70
$104.00
$65.00
$99.99
$50.00
DRM
HAND
HANI
LAN
MOB
PRI
SOM
SOM
SIR
UPG
VIR
WAN
WEC
$200.00
$144.00
$126.00
$185.00
$90.00
$130.00
$75.00
5. List the number and date of all orders that were placed on 9/10/2018 or that were placed by a
client whose consultant number is 19.
6. List the number and date of all orders that were placed on 9/10/2018 by a client whose
consultant number is 35.
7. List the number and date of all orders that were placed on 9/10/2018 but not by a client whose
consultant number is 35.

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: 5. Answer

VIEW

Step 2: 6. Answer

VIEW

Solution

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 3 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

Please provide a correct, clear answer for this SQL question 8)
student(sid, sname, sex, age, year, gpa) dept(dname, numphds) prof(pname, dname) course(cno, cname, dname) major(dname, sid) section(dname, cno, sectno, pname) enroll(sid, grade, dname, cno, sectno) Write the following SQL query for the schema above: Print the name(s) and sid(s) of the student(s) enrolled in the most classes.
Tables: department, dept_emp, dept_manager, employees, salaries, titles department (columns): dept_no, dept_name dept_emp (columns): emp_no, dept_no, from_date, to_date dept_manager (columns): emp_no, dept_no, from_date, to_date employees (columns): emp_no, birth_date, first_name, Last_name, gender, hire_date salaries (columns): emp_no, salary, from_date, to_date titles (columns): emp_no, title, from_date, to_date a) Your task is to write a SQL query to find count of employee who does not have a manager in the above given table schema?
given data Team (tname, year, coach, salary) Player (pname, position) Winner (tname, year) Played (pname, tname, year, salary) write the sql queries for the following questions. 1) List all the players who have salary higher than 2M$, and have played for all the teams in the league . 2) List coaches who have also been players, and have coached only teams they once played for. 3)List all the players who won the Stanley Cup during two consecutive years with two different teams.
a) List the names (Fame and Lame) and SSN of all male employees (Sex='M). b) List the last name and SSN of employees who work on project 'City Tower', sorted by alphabetical order of last na c) Retrieve the average salary of all female employees (Sex='F'). d) List department names and the number of employees who work for each department. Sort by department name. e) Retrieve the names of employees who make at least $10,000 more than thé employee who is pald the least in
List the names of all Staff members who hold a faculty position and have a salary of $45,000 or less. Show their names as their first name, followed by a space, and then their last name but sort the list alphabetically by last name and then first name. Hint: Check out the Position column in the Staff table. All staff members who do not hold a faculty position will get a bonus this year equal to 5% of their salary. List the names, current salary, and bonus amount for each Staff member (non-faculty) who is due a bonus. Show your list in order with the person receiving the highest bonus first.
have data base with following information: customer table with filed(cid,cname,city,country) order table with filed(cid ,oid,total amount) Q: List all orders with customer information.
I need C please
Lab #9 – Joining Data From Multiple Tables List the order number and order date for every order that was placed by Mary Nelson and that contains an order line for an iron. Use an INTERSECT operator. Lab #10 – Sub Queries Find the sales rep number, last name, and first name for every sales rep who represents at least one customer with a credit limit of $2000. List the order number and order date for every order that was placed by Mary Nelson and that contains an order line for an iron. Down below are the tables ORDER_LINE ORLN_ORDER_NUMBER ORLN_PART_NUMBER ORLN_NUMBER_ORDERED ORLN_QUOTED_PRICE ORDER_TABLE ORDR_ORDER_NUMBER ORDR_ORDER_DATE ORDR_CUSTOMER_NUMBER CUSTOMER CUST_NUMBER CUST_LAST CUST_FIRST CUST_STREET CUST_CITY CUST_STATE CUST_ZIP_CODE CUST_BALANCE CUST_CREDIT_LIMIT CUST_SALES_REP_NUM PART PART_NUMBER PART_DESCRIPTION UNITS_ON_HAND…
write following queries
A retailer of computers maintains a record containing the following information for every individual computer sold. • Manufacturer name • Model number • Physical memory size • Processor name • Date of sale • Price sold for Using only the database, which of the following CANNOT be determined? The most popular model of computer sold by the retailer Which models of computer stocked by the retailer have not had a single sale The average price of a computer was sold by the retailer In which months less than 100 computers were sold
Lab #9 – Joining Data From Multiple Tables List the order number and order date for every order that was placed by Mary Nelson and that contains an order line for an iron. Use an INTERSECT operator. Lab #10 – Sub Queries Find the sales rep number, last name, and first name for every sales rep who represents at least one customer with a credit limit of $2000. List the order number and order date for every order that was placed by Mary Nelson and that contains an order line for an iron. Repeat the exercise from the prior step using the ANY operator in the query instead of the ALL operator.