CREATE TABLE Orders
(Order# NUMBER(4),
Customer# NUMBER(4),
OrderDate DATE NOT NULL,
ShipDate DATE,
ShipStreet VARCHAR2(18),
ShipCity...
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
TILA CIRCLE', 'CHICAGO', 'IL', '60605', 3.00);
INSERT INTO ORDERS
VALUES
(1003,1001,TO_DATE('01-APR-09','DD-MON-YY'),TO_DATE('01-APR-09','DD-MON-YY'),'958
MAGNOLIA LANE', 'EASTPOINT', 'FL', '32328', 4.00);...
For each account of the previous question, compute the Balance,
and return a table that shows...
For each account of the previous question, compute the Balance,
and return a table that shows the account number, type, and balance
for each account (hint: use UNION).
The list of customer names that have transactions greater than
or equal to one thousand dollars.
A) Answer this question using only nested queries (i.e., each
select is over only one table). B) Answer this query using
joins.
Bank.sql is under this statement.
DROP DATABASE IF EXISTS Bank;
CREATE DATABASE Bank;
USE...
Complete the journal entries for each of the transactions.
Transaction
Description of transaction
01.
June 1:...
Complete the journal entries for each of the transactions.
Transaction
Description of transaction
01.
June 1: Byte of Accounting, Inc. issued
2,580 shares of its common stock to Jeremy after $25,200 in cash
and computer equipment with a fair market value of $36,720 were
received.
02.
June 1: Byte of Accounting, Inc. issued
2,488 shares of its common stock after acquiring from Courtney
$46,800 in cash, computer equipment with a fair market value of
$12,000 and office equipment with a...