Reference no: EM13764778
1) Find tables in page 237, 238 and 239. Write SQL CREATE TABLE and SQL INSERT statements data for
1. SQL statements for Table 1 - QACS CUSTOMER
2. SQL statements for Table 2 - QACS EMPLOYEE
3. SQL statements for Table 3 - QACS ITEM
4. SQL statements for Table 4 - QACS SALE
2) Write SQL statements to list all columns for all tables.
3) Write an SQL statement to list ItemID and ItemDescription for all items that cost $1000 or more.
4) Write an SQL statement to list LastName, FirstName, and Phone of the customer who made the purchase with SaleID 1. Use a subquery.
5) Write an SQL statement to list LastName, FirstName, and Phone of the customers who made the purchase with SaleIDs 1, 2, and 3. Use a subquery.
6) Write an SQL statement to list LastName, FirstName, and Phone of customers who have made at least one purchase with SubTotal greater than $500. Use a subquery.
7) Write an SQL statement to list LastName, FirstName, and Phone of customers who have purchased an item that has an ItemPrice of $500 or more. Use a subquery.
8) Write SQL CREATE TABLE statement for table VENDOR (p. 239) and insert the data (the first three rows only) into the VENDOR table.
9) Write an SQL statement to modify the vendor with CompanyName of Linens and Things to Linens and Other Stuff.
|
Reported an ending inventory balance
: On December 31 of the current year, Hewett Company reported an ending inventory balance of $216,500. The following additional information is also available:
|
|
What obstacles can you expect to encounter
: You're a detective working at a local police department. what obstacles can you expect to encounter during this process
|
|
Write a review of literature adversarial criminal law system
: Write a Review of Literature Adversarial Criminal Law System. One reason we conduct a review of the literature is to make sure that our research proposal is original and not just a replication of work already conducted.
|
|
Researching a community corrections program
: Project: Researching a Community Corrections Program, You are to search the Internet for a community-based corrections program operated by any state or county in the United States
|
|
Write sql statements to list all columns for all tables
: Write SQL statements to list all columns for all tables. Write an SQL statement to list ItemID and ItemDescription for all items that cost $1000 or more.
|
|
How the osha 2002 recordkeeping rules affect
: Explain and discuss how the OSHA 2002 recordkeeping rules affect issues dealing with specific disorders and other issues (i.e. privacy, access, fatalities, etc.)
|
|
Characteristics and valuation of stocks and bonds
: Describe the characteristics and valuation of stocks and bonds, and how each is a key component in the financing of corporations.
|
|
Website design html urgent
: It's all about Website design which I am taking as in class. It is going to be web site. 3 web pages, 2 font styles, 2 font sizes, 2 colors minimum.
|
|
Difficulties facing successful innovation
: What are then some of the difficulties facing successful innovation?
|