I accidentally selected an answer which I don't know if it's
correct or not
Homework Answers
Coreect answer is
SELECT order#, orderdate DateOrdered FROM orders
The reason being SQL takes parenthesis format where group is followed by subgroup which is further followed by further smaller subgroups to return valid answer.
All the other options directly call for answer without completing the loop which can give compile time error and runtime errors.
Add Answer to:
I accidentally selected an answer which I don't know if it's
correct or not
Question 13...
I need to create a SQL query that displays the names of the customers who purchased...
I need to create a SQL query that displays the names of the customers who purchased the book with the highest retail price in the database. Also I need to capitalize the first and last names. CUSTOMERS Table: CUSTOMER#, LASTNAME, FIRSTNAME, ADDRESS, CITY, STATE, ZIP, REFERRED, REGION, EMAIL ORDERS Table: ORDER#, CUSTOMER#, ORDERDATE, SHIPDATE, SHIPSTREET, SHIPCITY, SHIPSTATE, SHIPZIP, SHIPCOST ORDERITEMS Table: ORDER#, ITEM#, ISBN, QUANTITY, PAIDEACH
Please help me on the SQL queries, thank you so much. Write a query to display the title and publisher as well as the p...
Please help me on the SQL
queries, thank you so much.
Write a query to display the
title and publisher as well as the publisher contact for each book
using JOIN...USING clause.
Write a query to show the
first and last names of customers who have ordered cooking books.
Use the WHERE clause to join the tables.
Write a query to show the
title, cost and ISBN of each book in the books table. If the book
has been ordered,...
Tables: Create table Item( ItemId char(5) constraint itmid_unique primar
Tables: Create table Item( ItemId char(5) constraint itmid_unique primary key, Decription varchar2(30), Unitcost number(7,2)); Create table Customer( custID char(5) constraint cid.unique primary key, custName varchar2(20), address varchar2(50)); Create table Orderdata( orderID char(5) constraint oid_uniq primary key, orderdate date, shipdate date, ItemId char(5) references Item.ItemId, No_of_items number(4), Unitcost number(7,2), Order_total number(7,2), custID char(5) references customer.custID); Insert Into Item values(‘A123’,’Pencil’,2.5); Insert Into Item values(‘B123’,’Pen’,15); Insert Into...
Oracle 12c SQL Chapter 12 Determine which orders were shipped to the same state as order...
Oracle 12c SQL Chapter 12 Determine which orders were shipped to the same state as order 1014. CREATE TABLE Orders (Order# NUMBER(4), Customer# NUMBER(4), OrderDate DATE NOT NULL, ShipDate DATE, ShipStreet VARCHAR2(18), ShipCity VARCHAR2(15), ShipState VARCHAR2(2), ShipZip VARCHAR2(5), ShipCost NUMBER(4,2), CONSTRAINT orders_order#_pk PRIMARY KEY(order#), CONSTRAINT orders_customer#_fk FOREIGN KEY (customer#) REFERENCES customers(customer#)); INSERT INTO ORDERS VALUES (1000,1005,TO_DATE('31-MAR-09','DD-MON-YY'),TO_DATE('02-APR-09','DD-MON-YY'),'1201 ORANGE AVE', 'SEATTLE', 'WA', '98114' , 2.00); INSERT INTO ORDERS VALUES (1001,1010,TO_DATE('31-MAR-09','DD-MON-YY'),TO_DATE('01-APR-09','DD-MON-YY'), '114 EAST SAVANNAH', 'ATLANTA', 'GA', '30314', 3.00); INSERT INTO ORDERS VALUES (1002,1011,TO_DATE('31-MAR-09','DD-MON-YY'),TO_DATE('01-APR-09','DD-MON-YY'),'58...
QUESTION 9 You plan to query data using the TRANS_HIST_V view that was created by another...
QUESTION 9 You plan to query data using the TRANS_HIST_V view that was created by another user in their schema. Which statement is true? A. The Oracle Server will retrieve the view definition from the ALL_VIEWS data dictionary view. B. The Oracle Server will retrieve data, determined by the query criteria, from the TRANS_HIST_V view. C. The Oracle Server will verify whether you have been granted access privileges to the TRANS_HIST_V view. D. The Oracle Server will automatically reset the...
An online company sells hundreds of office supply products on its e-Commerce store. It has asked...
An online company sells hundreds of office supply products on
its e-Commerce store. It has asked you to design and implement a
sales order processing system which will be used by users in our
Operations department to process sales orders. Here is an overview
of the sales order process. Customers make purchases by placing
orders. Each customer has a customer number and profile (such as
name, shipping address). To simplify the matter, each time an order
is placed, only one...
I am using oracle sql developer to create some queries to generated reports and it is...
I am using oracle sql developer to create some queries to generated reports and it is not working. I am not sure how to use count, group by, and order by. Help me fix my query and explain to me how you did, so can do it next time. Also, I have to convert this query to a stored procedure, so can you help me do it too? Here is my query: SELECT COUNT(GUEST.FIRSTNAME), GUEST.FIRSTNAME, GUEST.LASTNAME, GUEST.GUESTTYPE, RESERVATION.RESERVATIONDATE, GUEST.EMAIL, FROM...
Seeking help/ explanation for a SQL question. 1.) How many different customers have made orders? Tables: CLOTHES ClOID, Type, Brand, Descript, Matrial, MadeInCountry, Size, Price, SID, POID) CUSTOMER...
Seeking help/ explanation for a SQL question.
1.) How many different customers have made
orders?
Tables: CLOTHES ClOID, Type, Brand, Descript, Matrial, MadeInCountry, Size, Price, SID, POID) CUSTOMER (CustID, Cname, Cbirthdate, Cemail, Cstreet, Ccity, Cstate, Czip, CreditCard, CsignupDate) ORDER SHIPMENT (OrderShipiD, Ship:D, Po:D) PURORDER (POID, PurchaseDate, Shipoption, Quantity, CustID) SHIPMENT (ShipID, TrackingNum, Shipstreet, Shipcity, Shipstate, Shipzip, EstimateDeliveryDate, CustID) SUPPLIER (SID, Sname, Sstreet, scity, Sstate, Szip, Slicense) E-R Diagram: Implementation Model Quantity CLOTHES H SUPPLIER CUSTOMER Places 여 PURORDER Contains POID...
Plz someone answer my database questions post Exercise I (50 pts): This exercise deals with a...
Plz someone answer my database questions post
Exercise I (50 pts): This exercise deals with a database that stores information abhout Hotel Management System. Customer (C email, name, country) Payment (Invoice id. C email, payment method, date) Invoice (Invoice id, starus, invoice description) Has (Bill id, Invoice id) Bill (Invoice id, Bill id, amount, Bname, type, date, reservation id) Reservation (Hotel id., room id. C email, date, period, reservation id) Rooms(Hotel id, room id. price, category) lotel (Hotel id, H...
Oracle only database: DROP TABLE ORDERITEMS; DROP TABLE Orders; DROP TABLE BOOKAUTHOR; DRO...
oracle only
database:
DROP TABLE ORDERITEMS;
DROP TABLE Orders;
DROP TABLE BOOKAUTHOR;
DROP TABLE BOOKS;
DROP TABLE PROMOTION;
DROP TABLE AUTHOR;
DROP TABLE CUSTOMERS;
DROP TABLE PUBLISHER;
CREATE TABLE Customers
( Customer# NUMBER(4),
LastName VARCHAR2(10) NOT NULL,
FirstName VARCHAR2(10) NOT NULL,
Email VARCHAR(40),
Address VARCHAR2(20),
City VARCHAR2(12),
State VARCHAR2(2),
Zip VARCHAR2(5),
Referred NUMBER(4),
Region CHAR(2),
CONSTRAINT customers_customer#_pk PRIMARY KEY(customer#)
);
INSERT INTO CUSTOMERS
VALUES (1001, 'MORALES', 'BONITA', '[email protected]', 'P.O.
BOX 651', 'EASTPOINT', 'FL', '32328', NULL, 'SE');
INSERT INTO CUSTOMERS
VALUES...
Please help me on the SQL
queries, thank you so much.
Write a query to display the
title and publisher as well as the publisher contact for each book
using JOIN...USING clause.
Write a query to show the
first and last names of customers who have ordered cooking books.
Use the WHERE clause to join the tables.
Write a query to show the
title, cost and ISBN of each book in the books table. If the book
has been ordered,...
An online company sells hundreds of office supply products on
its e-Commerce store. It has asked you to design and implement a
sales order processing system which will be used by users in our
Operations department to process sales orders. Here is an overview
of the sales order process. Customers make purchases by placing
orders. Each customer has a customer number and profile (such as
name, shipping address). To simplify the matter, each time an order
is placed, only one...
Seeking help/ explanation for a SQL question.
1.) How many different customers have made
orders?
Tables: CLOTHES ClOID, Type, Brand, Descript, Matrial, MadeInCountry, Size, Price, SID, POID) CUSTOMER (CustID, Cname, Cbirthdate, Cemail, Cstreet, Ccity, Cstate, Czip, CreditCard, CsignupDate) ORDER SHIPMENT (OrderShipiD, Ship:D, Po:D) PURORDER (POID, PurchaseDate, Shipoption, Quantity, CustID) SHIPMENT (ShipID, TrackingNum, Shipstreet, Shipcity, Shipstate, Shipzip, EstimateDeliveryDate, CustID) SUPPLIER (SID, Sname, Sstreet, scity, Sstate, Szip, Slicense) E-R Diagram: Implementation Model Quantity CLOTHES H SUPPLIER CUSTOMER Places 여 PURORDER Contains POID...
Plz someone answer my database questions post
Exercise I (50 pts): This exercise deals with a database that stores information abhout Hotel Management System. Customer (C email, name, country) Payment (Invoice id. C email, payment method, date) Invoice (Invoice id, starus, invoice description) Has (Bill id, Invoice id) Bill (Invoice id, Bill id, amount, Bname, type, date, reservation id) Reservation (Hotel id., room id. C email, date, period, reservation id) Rooms(Hotel id, room id. price, category) lotel (Hotel id, H...
oracle only
database:
DROP TABLE ORDERITEMS;
DROP TABLE Orders;
DROP TABLE BOOKAUTHOR;
DROP TABLE BOOKS;
DROP TABLE PROMOTION;
DROP TABLE AUTHOR;
DROP TABLE CUSTOMERS;
DROP TABLE PUBLISHER;
CREATE TABLE Customers
( Customer# NUMBER(4),
LastName VARCHAR2(10) NOT NULL,
FirstName VARCHAR2(10) NOT NULL,
Email VARCHAR(40),
Address VARCHAR2(20),
City VARCHAR2(12),
State VARCHAR2(2),
Zip VARCHAR2(5),
Referred NUMBER(4),
Region CHAR(2),
CONSTRAINT customers_customer#_pk PRIMARY KEY(customer#)
);
INSERT INTO CUSTOMERS
VALUES (1001, 'MORALES', 'BONITA', 'Most questions answered within 3 hours.
-
You own a portfolio that has $2709 invested in Stock A and $4387
invested in Stock...
asked 13 minutes ago -
A parameter estimate is said to be statistically significant if
there is sufficient evidence that the...
asked 11 minutes ago -
Based on the following table, calculate the ES, EF, LS, LF and
Slack for each activity...
asked 10 minutes ago -
The Work Breakdown Structure is always created using a phased-in
approach.
True/False
asked 27 minutes ago -
In a thermodynamically sealed container, 30.0 g of 22.0∘ ∘ C
water is mixed with 50.0...
asked 27 minutes ago -
what ate the mechanisms that pseudomonas aeruginosa utilize to
cause disease on skin and in the...
asked 31 minutes ago -
What is the present value of the following? Use Appendix B as an
approximate answer, but...
asked 34 minutes ago -
A 0.500 kg ice puck, moving east with a speed of 5.10 m/s ,
has a...
asked 39 minutes ago -
Draw an EER diagram for the following problem and map it into
tables: the sponsors of...
asked 41 minutes ago -
[C++]
Write a program that reads a list of integers, and outputs those
integers in reverse....
asked 1 hour ago -
Product quality, service, and price were the three factors
identified as being major determinates of a...
asked 1 hour ago -
After performing an EDTA titration experiment on 256 mL of an
unknown water sample you find...
asked 1 hour ago