- Which orders have been placed since October 20, 2010?
CustomerT CustomerID, CustomerName, CustomerAddress, CustomerCity, CustomerState, CustomerPostalCode 1, 'Contemporary Casuals, '1355 S Hines Blvd, 'Gainesville', 'FL, '32601-2871 2, Value Furniture, 15145 S.W. 17th St., Plano, TX, 75094-7743 3, 'Home Furnishings, '1900 Allard Ave., Albany, 'NY, '12209-1125 4, 'Eastern Furniture, '1925 Beltline Rd., Carteret', 'NJ, '07008-3188' 5, Impressions', '5585 Westcott Ct., Sacramento, CA' 94206-4056 6, 'Furniture Gallery. '325 Flatiron Dr. 'Boulder, CO. '80514-4432' 7, "Period Furniture, '394 Rainbow Dr., 'Seattle, WA', 97954-5589 8, 'California Classics, '816 Peach Rd., Santa Clara, 'CA', '96915-7754 9, 'M and H Casual Furniture, '3709 First Street, 'Clearwater, 'FL, '34620-2314 10, 'Seminole Interiors, '2400 Rocky Point Dr., 'Seminole, 'FL. '34646-4423. 11, American Euro Lifestyles, '2424 Missouri Ave N., "Prospect Park, 'NJ', '07508-5621 12, 'Battle Creek Furniture, '345 Capitol Ave. SW", Battle Creek, 'MI;, 49015-3401 13, 'Heritage Furnishings, '66789 College Ave., 'Carlisle', 'PA, '17013-8834 14, 'Kaneohe Homes, '112 Kiowai St., 'Kaneohe, 'Hl, 96744-2537 15, 'Mountain Scenes, '4132 Main Street, 'Ogden, 'UT, '84403-4432
Homework Answers
Select Order_ID from Order_T where OrderDate >= '20/10/10';
or
Select Order_ID from Order_T where day(OrderDate) >= 20 and month(OrderDate) >= 10 and year(OrderDate) >= 2010;
Do ask if any doubt. Please upvote.
Add Answer to:
I need SQL query OrderlD, OrderDate, CustomerlD 1001 21/Oct/10,1 1002, 21/Oct/10,8 1003, '22/Oct/...
Guidelines: The final project (Project 3) is an individual project. It requires writing an individual report...
Guidelines: The final project (Project 3) is an individual project. It requires writing an individual report and a presentation. Your manager at the VPF wants your help to answer the following questions and form your reply as a complete report. The report should be between 5 and 7 single spaced pages in addition to the cover page, table of contents, statement of Academic Honesty, reference page, and any other diagrams or appendices that will enhance your report. Note: Use the...
-- drop tables DROP TABLE REQUEST CASCADE CONSTRAINTS; DROP TABLE FULLORDER CASCADE CONSTRAINTS; DROP TABLE PRODUCT...
-- drop tables DROP TABLE REQUEST CASCADE CONSTRAINTS; DROP TABLE FULLORDER CASCADE CONSTRAINTS; DROP TABLE PRODUCT CASCADE CONSTRAINTS; DROP TABLE CUSTOMER CASCADE CONSTRAINTS; -- create and link tables CREATE TABLE CUSTOMER ( CustomerID INTEGER, Name VARCHAR2(40), City VARCHAR2(20), State CHAR(2), Zip CHAR(5), CONSTRAINT PK_CUSTOMER PRIMARY KEY (CustomerID) ); CREATE TABLE PRODUCT ( ProductID INTEGER, Description VARCHAR2(30), Material VARCHAR2(20), Price NUMBER(5,2), CONSTRAINT PK_PRODUCT...
-- drop tables DROP TABLE REQUEST CASCADE CONSTRAINTS; DROP TABLE FULLORDER CASCADE CONSTRAINTS; DROP TABLE PRODUCT...
-- drop tables DROP TABLE REQUEST CASCADE CONSTRAINTS; DROP TABLE FULLORDER CASCADE CONSTRAINTS; DROP TABLE PRODUCT CASCADE CONSTRAINTS; DROP TABLE CUSTOMER CASCADE CONSTRAINTS; -- create and link tables CREATE TABLE CUSTOMER ( CustomerID INTEGER, Name VARCHAR2(40), City VARCHAR2(20), State CHAR(2), Zip CHAR(5), CONSTRAINT PK_CUSTOMER PRIMARY KEY (CustomerID) ); CREATE TABLE PRODUCT ( ProductID INTEGER, Description VARCHAR2(30), Material VARCHAR2(20), Price NUMBER(5,2), CONSTRAINT PK_PRODUCT...
Using the ch08_saleco database write a T-SQL query to display the customer code, invoice number invoice...
Using the ch08_saleco database write a T-SQL query to display the customer code, invoice number invoice date, and invoice subtotal from invoice conditioned on the invoice subtotal is greater than $100 and from only customer codes 10011 and 10012. (hint: in) /* Database Systems, 8th Ed., Rob/Coronel */ /* Type of SQL : SQL Server */ CREATE TABLE CUSTOMER ( CUS_CODE int, CUS_LNAME varchar(15), CUS_FNAME varchar(15), CUS_INITIAL varchar(1), CUS_AREACODE varchar(3), CUS_PHONE varchar(8), CUS_BALANCE float(8) ); INSERT INTO CUSTOMER VALUES('10010','Ramas','Alfred','A','615','844-2573','0'); INSERT...
On October 1, 2016. Satillo Richey opened an advertising agency. DATE TRANSACTIONS Oct. 1 Satillo Richey...
On October 1, 2016. Satillo Richey opened an advertising agency. DATE TRANSACTIONS Oct. 1 Satillo Richey invested $52,000 cash in the business 2 Paid October office rent of $2,600; issued Check 1001. 5 Purchased desks and other office furniture for $14,200 from Office Furniture Mart, Inc., received Invoice 6704 payable in 60 days. 6 Issued Check 1002 for $2.800 to purchase art equipment 7 Purchased supplies for $1,150; paid with Check 1003. 10 Issued Check 1004 for $520 for office...
On October 1, 2019, Helen Kennedy opened an advertising agency. DATE TRANSACTIONS Oct. 1 Helen Kennedy...
On October 1, 2019, Helen Kennedy opened an advertising agency. DATE TRANSACTIONS Oct. 1 Helen Kennedy invested $62,000 cash in the business 2 Paid 0ctober office rent of $3,100; issued Check 1001 5 Purchased desks and other office furniture for $13, 800 from Office Furniture Mart, Inc.; received Invoice 6704 payable in 60 days 6 Issued Check 1002 for $3,300 to purchase art equipment. 7 Purchased supplies for $1, 650; paid with Ccheck 100:3 10 Issued Check 1004 for $480...
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...
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...
Connect to mySQL DBMS, open a SQL script file, navigate to CityJail.sql file and execute it...
Connect to mySQL DBMS, open a SQL script file, navigate to CityJail.sql file and execute it to create tables and populate with the supplied data. If there are any errors in the script fix them. It is your job to find the errors and correct them. This is important. You will need correct data for future exercises in this module. Then answer all questions. Write the answer below each question then take screen shot of the result. This script builds...
On October 1, 2016. Satillo Richey opened an advertising agency. DATE TRANSACTIONS Oct. 1 Satillo Richey invested $52,000 cash in the business 2 Paid October office rent of $2,600; issued Check 1001. 5 Purchased desks and other office furniture for $14,200 from Office Furniture Mart, Inc., received Invoice 6704 payable in 60 days. 6 Issued Check 1002 for $2.800 to purchase art equipment 7 Purchased supplies for $1,150; paid with Check 1003. 10 Issued Check 1004 for $520 for office...
On October 1, 2019, Helen Kennedy opened an advertising agency. DATE TRANSACTIONS Oct. 1 Helen Kennedy invested $62,000 cash in the business 2 Paid 0ctober office rent of $3,100; issued Check 1001 5 Purchased desks and other office furniture for $13, 800 from Office Furniture Mart, Inc.; received Invoice 6704 payable in 60 days 6 Issued Check 1002 for $3,300 to purchase art equipment. 7 Purchased supplies for $1, 650; paid with Ccheck 100:3 10 Issued Check 1004 for $480...
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.
-
1. What is the meaning of the term communication style?
2. What are the benefits to...
asked 4 minutes ago -
9.) You are buying a car that cost $26,500. You make payments of
$412 each month...
asked 29 minutes ago -
. Suppose a discrete random variable has probability
distribution
P(x) = .2 if x = 0...
asked 1 hour ago -
Problem #1
The area between Z = 0 and Z = 2.50
The area between Z...
asked 45 minutes ago -
Under the influence of its drive force, a snowmobile is moving
at a constant velocity along...
asked 2 hours ago -
Why do organizations decline? What steps can top
management take to halt, decline, and restore organizational...
asked 1 hour ago -
What mechanisms Drive speciation??
(I.e. what was Dawins theory on the orgin of species, and how...
asked 3 hours ago -
The manager at a car assembly plant believes that the mean
assembly time for a car...
asked 4 hours ago -
Which of the following is true of electron capture?
A) It decreases the nuclide's mass number...
asked 6 hours ago -
Assuming an efficiency of 43.10%, calculate the actual yield of
magnesium nitrate formed from 114.9 g...
asked 6 hours ago -
The highly pathogenic bacterium Clostridium
perfringens causes gangrene, a disease that results in the
destruction of...
asked 8 hours ago -
In the context of situation analysis, which of the following is
a category for analysis in...
asked 8 hours ago