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

Np Ms Office 365/Excel 2016 I Ntermed

1st Edition

ISBN:9781337508841

Author:Carey

Publisher:Carey

Chapter7: Developing An Excel Application

Section: Chapter Questions

Problem 3.13CP

See similar textbooks

Similar questions

5. In the OrderItems table, display a count of the number of products where item_price is greater than or equal to $6, grouped by prod_id, but only for those groups having 3 or more of a given prod_id. Display the count with the alias shown. Sort by prod_id in ascending order. BRO3 1 rows returned in 0.03 seconds PROD ID Download 4 NUM PROD ID
PRODUCTS PID DESC PRICE SID QTY 801 Pencil 3 1 10 802 A4 6 2 15 803 Ballpen 4 2 804 Marker 2 3 20 SUPPLIERS SID SNAME STYPE LOCATION 1 Lulu DS Salalah 2 C4 DS Saadah 3 Smile WS Awqad Display the maximum price of all the products in PRODUCTS table for each Supplier ID having a maximum price more than 5.
Show the list of students (all attributes) who were born after 2000-01-01 and are currently in Active status in the alphabetical order of the last and the first name. Hint: To calculate easily, always use the date format YYYY-MM-DD
Display CustomerName and Status as Q2 2020° for every customer who was born during the 2nd quarter of 2020. Then, combine it with CustomerName and Status as 'Q3 2020' for every customer who was born during the 3rd quarter of 2020. (year, datename, union) CustomerName Status Amy Grenkov MsCustomer 1 Q2 2020 CustomerID char(5) 2 Dukey Diano Q3 2020 CustomerName varchar(50) 3 Ingamar Carlin Q3 2020 CustomerGender varchar(10) Javier Drewson Q3 2020 CustomerAddress varchar(50) I CustomerEmail E CustomerDOB varchar(50) Pooh McCutcheon Q3 2020 date 6 Westley Boram Q3 2020 4.
View 4 Seneca Courses Inc. Customer Forms All customer information for SCI is maintained on file forms. The following are sample customer information forms: CUST_ID 78 CUST _ID 54 NAME YORK UNIVERSITY NAME SENECA COLLEGE LOCATION NORTH YORK LOCATION NORTH YORK SALES_REP ANDRE MARTIN SALES_REP PARVEZ RAI CUST _ID 74 CUST _ID 43 NAME RYERSON NAME INDIGO BOOKS LOCATION TORONTO LOCATION TORONTO SALES_REP PARVEZ RAI SALES_REP ANDRE MARTIN Business Rules: NAME must always be different for each customer. SALES_REP must always have a value. SALES_REP must be an existing employee. A customer only has one sales rep, but the sales_rep may have more than one customer. Normalize the above user view. Document all steps including UNF, 1NF, Dependencies, 2NF, and 3NF and explain or list the…
Product_id Product_name Category Mfg_date Exp_Dte Product_price 01 Dairy Milk Choclate Junk 2,Aug, 2019 2aug, 2020 80 02 Lipton Tea Bags Not junk 2,jan 2019 2, jan 2020 160 03 Kurkure junk 2, april 2919 2, april, 2021 30 04 Shezan Juice Junk 3,Aug, 2019 3,aug, 2020 30 06 Olpers Milk Not junk 3,april, 2018 3,april, 2020 350 Canteen_table 1: Write query to create canteen_table. Put check on category values as only “junk” and “Not junk”. Change colum name of product_price to unit_price. Display products manufactured between 1, jan 2019 to 1, May 2019. Display count of only junk food items in canteen_table with alias name as “junk Food Count”. Display Count Of both Junk food and not junk food products whose count is greater then 1.
Problem 1. Using the INVOICE table structure shown in table below do the following: INVOICE Attribute Name Sample Value Sample Value Sample Value Sample Value Sample Value INV_NUM 211347 211347 211347 211348 211349 PROD_NUM AA-E3422QW QD-300932X RU-995748G AA-E3422QW GH-778345P SALE_DATE 15-Jan-2016 15-Jan-2016 15-Jan-2016 15-Jan-2016 16-Jan-2016 PROD_LABEL Rotary sander 0.25-in. drill bit Band saw Rotary sander Power drill VEND_CODE 211 211 309 211 157 VEND_NAME NeverFail, Inc. NeverFail, Inc. BeGood, Inc. NeverFail, Inc. ToughGo, Inc. QUANT_SOLD 1 8 1 2 1 PROD_PRICE $49.95 $3.45 $39.99 $49.95 $87.75 Write the relational schema, draw its dependency diagram, and identify all dependencies, including all partial and transitive dependencies. You can assume that the table does not contain repeating groups and that an invoice number references more than one…
Normalise the data : Table: Administrator Field Name Data Field Constraints Description size type varchar Admin ID 15 Primary Key Contains the Admin id Admin char 50 Not null Contains the Name Admin name Not null Contains email Email varchar 20 the Address char 10 Not null Contains the address Phone int 8 Not null Contains the Number phone number Table: Product Field Name Data type Field size Constraints Description Product ID varchar 20 Primary Key Contains the product id Product Name char 25 Not null Contains product name Category char 13 Not null Contains the category CustomerlD varchar 15 Foreign key Contains the customer id
Display details of employee with ID 150 or 160.
Use the following table to answer the questions below: Table name: Customers Column Name Role Data Type Length Constraint customerID stores the ID of a customer Char 5 Primary key custFName stores the first name of a customer Varchar2 35 Cannot be null custLName Stores the last name of a customer Varchar2 35 Cannot be null custGender Store the gender of a customer Char 1 It should be ‘M’ or ‘F’ custDOB Stores the date of birth of a customer Date custIncome Store the income of a customer Number 4 Write in SQL a command that creates the table Customers according to the above description (2 marks). Write in SQL a statement that adds a new column named accountID of type Char(8). This column should be defined as a foreign key that relates the table Customers to the table Account (1.5 marks). Write in SQL a command that deletes the customers whose date of birth is after 22-Dec-1990 (1.5 Marks).…
Table : PURCHASE_ORDER ORDER_NO AMOUNT ORDER DATE CUSTOMER_ID SALESMAN_ID DELIVERY DATE 1001 300 05-03-2017 2001 3001 05-05-2017 1002 200.20 10-07-2017 2002 3003 10-10-2017 1003 600 12-06-2017 2005 3002 12-08-2017 1004 400.25 10-05-2017 2003 3004 10-07-2017 1005 500.10 03-08-2017 2004 3005 03-05-2017 1006 400 10-07-2017 2005 3006 10-10-2017 Table: PURCHASE _DETAILS ORDER_NO PRODUCT_NAME PRICE QUANTITY 1001 KEYBOARD 56 100 1002 MONITOR 36 200 1003 MOUSE 100 1004 HARD_DISK 58 300 1005 RAM 25 500 1007 CABINET 100 a) Write a SQL query to display PRODUCT_NAME, ORDER DATE and find number of years between the DELIVERY_ DATE from the CURRENT DATE [Hint: Use ON Clause]. b) Write a SQL query to display matched records from PURCHASE_ORDER table and all records from PURCHASE_DETAILS. c) Write an SQL query to display ORDER_NO, PRODUCT_NAME from table ORDER_DETAILS of products where the price is less than average price of products. [Hint: Use Subquery]. d) Write an SQL query to display ORDER_NO,…
View 3 Seneca Courses Inc. Employee Forms All employee information for SCI is maintained on file forms. The following are sample employee information forms: EMP_ID 7839 EMP_ID 7654 EMP_NAME JOHN CHIU EMP_NAME ANDRE MARTIN SOC_INS 123-234-345 SOC_INS 678-345-123 POSITION MANAGER POSITION SALES SUPERVISOR SUPERVISOR JOHN CHIU HIREDATE November 13, 1999 HIREDATE September 24, 1999 EMP_ID 7434 EMP_ID 7435 EMP_NAME PARVEZ RAI EMP_NAME DANIEL CHOY SOC_INS 234-123-432 SOC_INS 345-312-234 POSITION SALES POSITION CLERK SUPERVISOR JOHN CHIU SUPERVISOR HIREDATE June 24, 1980 HIREDATE August 4, 1998 Business Rules: 1. SOC_INS must always be different for each employee. 2. EMP_NAME must always have a value. Normalize the above user view. Document all steps including UNF, 1NF, Dependencies, 2NF, and 3NF…