A.Write a query to extract only the zipcode from customers address tables.pdf3 / 575%+must reflect the payment statusfor each booking, including deposit, when the deposit was made,then each of the payments made, and when the entirepayment was completed.CustomerCustIDCustomerName Address1| Lorry Kovacs2 Bonnie Artest3 Bob O'Connor4 Harry SalomonMary CombsCary JonesMary TylerJohny MilanoPhone(603)536-0987(603)819-0387(802)918-7565(603)536-7565(603)536-3632(603)536-8739(603)669-7431 03/16/1969BirthDate13 High Street, Plymouth, NH 0326445 Maple Drive, Concord, NH 0330117 10th Street, Brattleboro, VT 0530167 Boggs Road, Campton, NH 0322348 Main Street, Campton, NH 0322303/16/197207/08/197701/05/196607/13/1965502/17/196712/03/196689 Bobby Lamson10 Henry Lawson47 Broad Avenue, Plymouth, NH 0326471 Main Street, Concord, NH 03301983 Mountain Road, Campton, NH 03223421 Elm Street,Manchester, NH 03308| 92 Main Street, Brattleboro, VT 0530110/16/197406/14/197309/17/1961(603)536-4733(603)347-5592(802)218-7318VehicleCapacity Deposit Rate$100.00$25.00 $100.00$50.00$50.00$45.00%$470.00VehIDLimit66243Make1 Ford F3502 GMC Silverado3 Honda Civic4 Chevrolet MalibuFord TaurusТуреTruckTruckSedanSedan WhiteSedan MaroonColorBlue$25.00WhiteGreen3$15.00$15.00524$20.0024Honda OdisseyFord Explorer8 Nissan SentraToyota Camry10 | Subaru ForesterVanBeige6$15.0024SUVGreen6$10.00$60.0024SedanSilver5$15.00$45.00249Sedan Black$25.00$50.00$55.00$75.00524SUVWhite524BookingBookID CustID VehID DateTimeRentedPaymentPmtID BookIDDateTimeReturnedPmtDatePmtAmt3 07/18/20056 07/04/20058 07/08/20051 07/15/20062 07/15/20063 07/19/200607/07/20065 07/13/20066 07/07/20067 06/26/20068 07/10/20069 07/18/200610 07/14/200611 07/26/200612 07/25/2006$30.00$40.00107/23/2006 10:00 PM07/22/2006 05:00 PM11007/22/2005 07:00 PM207/21/2005 01:00 PM07/21/2005 06:00 PM07/12/2005 10:00 AM07/17/2005 04:00 PM07/10/2006 08:00 PM2107/22/2006 10:00 AM3.$25.0044407/13/2006 09:00 AM4$50.00$100.00$70.00507/18/2006 03:00 PM507/11/2006 10:00 AM07/02/2006 11:00 AM74$15.00207/01/2005 05:00 PM$15.00$75.008907/11/2006 04:00 PM07/12/2006 10:00 PM9907/23/2005 07:00 PM07/24/2006 06:00 PM10$45.0010407/20/2006 05:00 PM07/21/2006 04:00 PM$55.00$50.001111607/31/2006 08:00 PM08/01/2006 06:00 PM1207/30/2005 01:00 PMI07/18/2005 08:00 PM1207/30/2006 05:00 PM1314$60.001307/19/2006 02:00 PM$70.00$100.001407/16/2005 06:00 PM07/17/2006 03:00 PM1515907/25/2005 01:00 PM07/26/2006 11:00 AM11:00 AM2 Type here to search67°F5/5/20222***) ^....II

Q: Answer SQL Query for given table

Answered: Write a query to extract only the…

Engineering

Computer Science

Write a query to extract only the zipcode from customers address

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: 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: Write a query to list the first name and last name of all authors. Concatenate the first and last…

A: The SQL query is: SELECT CONCAT(CONCAT(firstname,' '),lastname) AS FullName FROM author;…

Q: Write a query to display the employee number, first name, last name, and largest salary amount for…

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

Q: Write a query to display the author ID, first and last name for all authors who have never written a…

A: The below query will return the author ID, first name, and last name for all authors who have never…

Q: Write a query to display the author ID, first name, last name, and year of birth for all authors.…

A: A database may be defined in one of these ways it's an organized series of established facts or…

Q: Write a query to get the number of different types of jobs available in the university table.…

A: Functions used in Query: The LIKE operator is used to search for a specified pattern in a column.…

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 current salary for each employee in department 300. Assume that only…

A: In a corporate setting, managing employee information, salary details, and departmental affiliations…

Q: .Write a query to list the first name and last name of all authors. Concatenate the first and last…

A: We need to select the name of both editor and author and do the union. The query for the same as per…

Q: Write a query to display the current salary for each employee in department 300. Assume that only…

A: We must take into account the compensation history kept in the figure 48 table in order to get the…

Q: 7) Write a query to display Unique order dates from the shipper named “Speedy Express”.

A: According to Bartleby Guidelines we need to answer only one question so I have answered first…

Q: Write a query to display the checkout number, book number, patron ID, checkout date, and due date…

A: The query follows the syntax given below. SELECT column1, column2 FROM table1 WHERE condition ORDER…

Q: Write a query to display PUBDATE is after 21st January

A: Note: In this question, No table is given. We are creating a sample table to perform the query on…

Q: ERD:- PK CHECKOUT Check Num FK1 Book_Num FK2 Pat_ID Check Out Date Check_Due Date Check_In_Date…

A: SOLUTION -In this SQL database we have 5 Tables -CHECKOUTPATRONBOOKAUTHORWRITESFor this Query, we…

Concept explainers

Single Table

In a database management system, a single table is designed to obtain data of heterogeneous items. A single-table design with DynamoDB resolves the issue of raising multiple requests for the relevant data of an entity.

Question

A.Write a query to extract only the zipcode from customers address

tables.pdf
3 / 5
75%
+
must reflect the payment statusfor each booking, including deposit, when the deposit was made,
then each of the payments made, and when the entirepayment was completed.
Customer
CustID
CustomerName Address
1| Lorry Kovacs
2 Bonnie Artest
3 Bob O'Connor
4 Harry Salomon
Mary Combs
Cary Jones
Mary Tyler
Johny Milano
Phone
(603)536-0987
(603)819-0387
(802)918-7565
(603)536-7565
(603)536-3632
(603)536-8739
(603)669-7431 03/16/1969
BirthDate
13 High Street, Plymouth, NH 03264
45 Maple Drive, Concord, NH 03301
17 10th Street, Brattleboro, VT 05301
67 Boggs Road, Campton, NH 03223
48 Main Street, Campton, NH 03223
03/16/1972
07/08/1977
01/05/1966
07/13/1965
5
02/17/1967
12/03/1966
8
9 Bobby Lamson
10 Henry Lawson
47 Broad Avenue, Plymouth, NH 03264
71 Main Street, Concord, NH 03301
983 Mountain Road, Campton, NH 03223
421 Elm Street,Manchester, NH 03308
| 92 Main Street, Brattleboro, VT 05301
10/16/1974
06/14/1973
09/17/1961
(603)536-4733
(603)347-5592
(802)218-7318
Vehicle
Capacity Deposit Rate
$100.00
$25.00 $100.00
$50.00
$50.00
$45.00
%$470.00
VehID
Limit
6
6
24
3
Make
1 Ford F350
2 GMC Silverado
3 Honda Civic
4 Chevrolet Malibu
Ford Taurus
Туре
Truck
Truck
Sedan
Sedan White
Sedan Maroon
Color
Blue
$25.00
White
Green
3
$15.00
$15.00
5
24
$20.00
24
Honda Odissey
Ford Explorer
8 Nissan Sentra
Toyota Camry
10 | Subaru Forester
Van
Beige
6
$15.00
24
SUV
Green
6
$10.00
$60.00
24
Sedan
Silver
5
$15.00
$45.00
24
9
Sedan Black
$25.00
$50.00
$55.00
$75.00
5
24
SUV
White
5
24
Booking
BookID CustID VehID DateTimeRented
Payment
PmtID BookID
DateTimeReturned
PmtDate
PmtAmt
3 07/18/2005
6 07/04/2005
8 07/08/2005
1 07/15/2006
2 07/15/2006
3 07/19/2006
07/07/2006
5 07/13/2006
6 07/07/2006
7 06/26/2006
8 07/10/2006
9 07/18/2006
10 07/14/2006
11 07/26/2006
12 07/25/2006
$30.00
$40.00
1
07/23/2006 10:00 PM
07/22/2006 05:00 PM
1
10
07/22/2005 07:00 PM
2
07/21/2005 01:00 PM
07/21/2005 06:00 PM
07/12/2005 10:00 AM
07/17/2005 04:00 PM
07/10/2006 08:00 PM
2
1
07/22/2006 10:00 AM
3.
$25.00
4
4
4
07/13/2006 09:00 AM
4
$50.00
$100.00
$70.00
5
07/18/2006 03:00 PM
5
07/11/2006 10:00 AM
07/02/2006 11:00 AM
7
4
$15.00
2
07/01/2005 05:00 PM
$15.00
$75.00
8
9
07/11/2006 04:00 PM
07/12/2006 10:00 PM
9
9
07/23/2005 07:00 PM
07/24/2006 06:00 PM
10
$45.00
10
4
07/20/2006 05:00 PM
07/21/2006 04:00 PM
$55.00
$50.00
11
11
6
07/31/2006 08:00 PM
08/01/2006 06:00 PM
12
07/30/2005 01:00 PMI
07/18/2005 08:00 PM
12
07/30/2006 05:00 PM
13
14
$60.00
13
07/19/2006 02:00 PM
$70.00
$100.00
14
07/16/2005 06:00 PM
07/17/2006 03:00 PM
15
15
9
07/25/2005 01:00 PM
07/26/2006 11:00 AM
11:00 AM
2 Type here to search
67°F
5/5/2022
2
***) ^.
...
II

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 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

You have been told that you need to store the zip code for employees. Add a column to the EMPLOYEE table which will be used to store each employee’s zip code Update two rows in the EMPLOYEE table and assign a zip code (must have a WHERE clause). (you MAY use 1 or 2 statements) Write a query that includes each employee's last name, department name (not ID), and salary for each employee whose salary is less than the average for their department
3. Run a query that gives the average grade on the final exam for male students and for femalestudents. Round that number to 1 decimal place only.
The following database will be used in this question: SALESREP SalesRepNo 654 734 345 434 RepName Jones Smith Chen Johnson HireDate 01/02/2005 02/03/2007 01/25/2004 11/23/2004 CUSTOMER CustNo 9870 8590 7840 4870 CustName Winston Gonzales Harris Miles Balance 500 350 SalesRepNo 345 434 654 345 800 100
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
b. Write a query to get the average salary and the total number of employees who work in the History department (in that order). c. Write a query to get the number of employees working in the History department with a job title of Head of Department.