Write Queries For Each Of The Stated Problems In The Steps B
Required skills: Writing, Write
The deliverable for this lab will include:
Your script file with the 13 queries in it. Be sure your name, course number, and lab number are in a comment area at the top of your file.
An output file created using SET ECHO ON showing both the SQL code and the results.
Both documents are to be zipped into a single file before submitting to the iLab Dropbox for Week 4.
L A B S T E P S
STEP 1:
Using the BOOKS table, write a query that will list the categories for the books in inventory. List each category only once in your result set.
STEP 2:
Using the BOOKS table, write a query that will list the title and publisher ID for each book in the table. Use the column heading of "Publisher ID" for the pubid field.
STEP 3:
Using the BOOKS table, write a query that will list the book title, retail price, and the amount of markup for each book. The amount of markup is the retail price minus the cost. Use the column heading “Price Markup” for the arithmetic expression column.
STEP 4:
Using the BOOK_CUSTOMER table, write a query that will list the customer's first name, last name, and city for those customers living in zip code 31206.
STEP 5:
Using the BOOK_ORDER table, write a query that will list everything about the orders placed prior to April 2, 2009.
STEP 6:
Using the BOOK_ORDER table, write a query that will list everything about the orders that have not been shipped yet.
STEP 7:
Using the BOOK_CUSTOMER table, write a query using the AND and OR operators that will list the customer information for those customers living in either Florida or New Jersey who have not been referred by another customer.
STEP 8:
Using the BOOKS table, write a query that will list all information about those books that are not computer books and do not cost more than $ 30.00 retail.
STEP 9:
Using the AUTHOR table, write a query that will list all information about authors whose first name ends with an “A”. Put the results in descending order of last name, and then ascending order by first name. This should be done using a single query.
STEP 10:
Using the BOOK_ORDER table, write a query using the > and < operators that will list the orders that were placed between April 1, 2009 and April 4, 2009. Only show the orders for April 2nd and 3rd in your result set.
STEP 11:
Using the BOOK_ORDER table, write a query that will list the orders that were placed between April 2, 2009 and April 4, 2009 including those placed on the 2nd and 4th. Use a different approach (operator) in writing this query than used in the query for #10, that is, do not use > and < signs in your query.
STEP 12:
Using the BOOKS table, write a query that will list the book title, publisher ID, and published date for all books that were published by publisher 4 or after January 1, 2001. Order the results in ascending order by publisher ID and give the publish date and publisher ID columns meaningful titles.
STEP 13:
Many organizations use percentage of markup (e.g., profit margin) when analyzing financial data. To determine the percentage of markup for a particular item, simply subtract the cost for the item from the retail price to obtain the dollar amount of profit, and then divide the profit by the cost of the item. The resulting solution is then multiplied by 100 to determine the percent of markup. Using a SELECT statement, display the title of each book and its percent of markup. For the column displaying the percent of markup, use “Markup %” as the column heading.
This is the end of lab #4
Your script file with the 13 queries in it. Be sure your name, course number, and lab number are in a comment area at the top of your file.
An output file created using SET ECHO ON showing both the SQL code and the results.
Both documents are to be zipped into a single file before submitting to the iLab Dropbox for Week 4.
L A B S T E P S
STEP 1:
Using the BOOKS table, write a query that will list the categories for the books in inventory. List each category only once in your result set.
STEP 2:
Using the BOOKS table, write a query that will list the title and publisher ID for each book in the table. Use the column heading of "Publisher ID" for the pubid field.
STEP 3:
Using the BOOKS table, write a query that will list the book title, retail price, and the amount of markup for each book. The amount of markup is the retail price minus the cost. Use the column heading “Price Markup” for the arithmetic expression column.
STEP 4:
Using the BOOK_CUSTOMER table, write a query that will list the customer's first name, last name, and city for those customers living in zip code 31206.
STEP 5:
Using the BOOK_ORDER table, write a query that will list everything about the orders placed prior to April 2, 2009.
STEP 6:
Using the BOOK_ORDER table, write a query that will list everything about the orders that have not been shipped yet.
STEP 7:
Using the BOOK_CUSTOMER table, write a query using the AND and OR operators that will list the customer information for those customers living in either Florida or New Jersey who have not been referred by another customer.
STEP 8:
Using the BOOKS table, write a query that will list all information about those books that are not computer books and do not cost more than $ 30.00 retail.
STEP 9:
Using the AUTHOR table, write a query that will list all information about authors whose first name ends with an “A”. Put the results in descending order of last name, and then ascending order by first name. This should be done using a single query.
STEP 10:
Using the BOOK_ORDER table, write a query using the > and < operators that will list the orders that were placed between April 1, 2009 and April 4, 2009. Only show the orders for April 2nd and 3rd in your result set.
STEP 11:
Using the BOOK_ORDER table, write a query that will list the orders that were placed between April 2, 2009 and April 4, 2009 including those placed on the 2nd and 4th. Use a different approach (operator) in writing this query than used in the query for #10, that is, do not use > and < signs in your query.
STEP 12:
Using the BOOKS table, write a query that will list the book title, publisher ID, and published date for all books that were published by publisher 4 or after January 1, 2001. Order the results in ascending order by publisher ID and give the publish date and publisher ID columns meaningful titles.
STEP 13:
Many organizations use percentage of markup (e.g., profit margin) when analyzing financial data. To determine the percentage of markup for a particular item, simply subtract the cost for the item from the retail price to obtain the dollar amount of profit, and then divide the profit by the cost of the item. The resulting solution is then multiplied by 100 to determine the percent of markup. Using a SELECT statement, display the title of each book and its percent of markup. For the column displaying the percent of markup, use “Markup %” as the column heading.
This is the end of lab #4
Posted In:Writing |
Related projects:
Write emails for each of our books and how to videos
Please visit www.fireworksnews.com to see our line of books and how-to videos.
We are looking for someone experienced in selling by email to write an email for each of our 100++ products to be e-blasted to our current mailing list.
This list is small, only 3500 emails at this time. We are small. We are open to new ideas on selling our products worldwide, but we have a limited budget without assured sales.
We are looking for someone experienced in selling by email to write an email for each of our 100++ products to be e-blasted to our current mailing list.
This list is small, only 3500 emails at this time. We are small. We are open to new ideas on selling our products worldwide, but we have a limited budget without assured sales.
Sql Scripting
r all books ordered after April 30, 2009.
STEP 13:
Using the correct tables, create a query using either join operation you wish that will list the order id, order date, quantity ordered, and retail price for every book that has been ordered. Format the date as MM/DD/YYYY with an alias of “Order Date” and format the retail price column using the correct function to show dollars and cents with a dollar sign ( $ ) and a column alias of “Retail”.
STEP 13:
Using the correct tables, create a query using either join operation you wish that will list the order id, order date, quantity ordered, and retail price for every book that has been ordered. Format the date as MM/DD/YYYY with an alias of “Order Date” and format the retail price column using the correct function to show dollars and cents with a dollar sign ( $ ) and a column alias of “Retail”.
Retreiving Data From Multiple Tables 2
ormat the date as MM/DD/YYYY with an alias of “Order Date” and format the retail price column using the correct function to show dollars and cents with a dollar sign ( $ ) and a column alias of “Retail”.
This is the end of lab #5
Additional Info (Added 12/14/2010 at 2:34 EST)...System Message: This is a reposting of project Retreiving data from Multiple Tables (1290801749).
This is the end of lab #5
Additional Info (Added 12/14/2010 at 2:34 EST)...System Message: This is a reposting of project Retreiving data from Multiple Tables (1290801749).
Working With Additional Database Objects
er is and the next sequence number will be.
STEP 7:
Create a unique index on the combined columns ORDERID and CUSTOMERID in the BOOK_ORDER table. Give the index a name of BOOK_ORDER_IDX.
STEP 8:
Determine how many objects you currently own in your schema by querying the USER_OBJECTS view in the Data Dictionary. Your result set should list the different object types that you find and include a count by object type.
STEP 7:
Create a unique index on the combined columns ORDERID and CUSTOMERID in the BOOK_ORDER table. Give the index a name of BOOK_ORDER_IDX.
STEP 8:
Determine how many objects you currently own in your schema by querying the USER_OBJECTS view in the Data Dictionary. Your result set should list the different object types that you find and include a count by object type.
Oracle Single Row And Group Functions
two customers displayed and the exclusion for Jorge Perez must be associated with the upper query).
STEP 13:
Using the BOOKS table, create a query using the correct functions to return the category name, total number books per category with a column alias of "Category Total", and the total cost of all the books per category with an alias of "Cost". Format the cost column using the correct function to show dollars and cents with a dollar sign.
STEP 13:
Using the BOOKS table, create a query using the correct functions to return the category name, total number books per category with a column alias of "Category Total", and the total cost of all the books per category with an alias of "Cost". Format the cost column using the correct function to show dollars and cents with a dollar sign.
Retreiving Data From Multiple Tables
30, 2009.
STEP 13:
Using the correct tables, create a query using either join operation you wish that will list the order id, order date, quantity ordered, and retail price for every book that has been ordered. Format the date as MM/DD/YYYY with an alias of “Order Date” and format the retail price column using the correct function to show dollars and cents with a dollar sign ( $ ) and a column alias of “Retail”.
This is the end of lab #5
STEP 13:
Using the correct tables, create a query using either join operation you wish that will list the order id, order date, quantity ordered, and retail price for every book that has been ordered. Format the date as MM/DD/YYYY with an alias of “Order Date” and format the retail price column using the correct function to show dollars and cents with a dollar sign ( $ ) and a column alias of “Retail”.
This is the end of lab #5
I Need 10 Articles for Each of the following Catagories - Long Term opportunities
be preferred for easier communication.
We currently planned for Q1 2009. We also want new 10 articles every week. So, this project can be continued in future.
Articles must be original and pass copy infringement testing.
Please Provide Samples with you Bid.
If you agree to all terms... Please contact us via PM.
The payment will make via Paypal after you finish each comfirmed article.
PLEASE QUOTE A COST/FEE FOR 100 articles.
We currently planned for Q1 2009. We also want new 10 articles every week. So, this project can be continued in future.
Articles must be original and pass copy infringement testing.
Please Provide Samples with you Bid.
If you agree to all terms... Please contact us via PM.
The payment will make via Paypal after you finish each comfirmed article.
PLEASE QUOTE A COST/FEE FOR 100 articles.
need oracle expert to write queries (simple assignment)
le: none; border-spacing: 0px;">
i need someone very experienced in oracle to write queries for a database i have. i have the .sql program and diagram of tables, you just need to write the queries using select from where and subquery statements. it is very simple, only between 18-20 queries. should take an expert no more than 30 minutes.
100 MANUAL article submissions for each of 2 articles
count and 2 hypertext links in the resource box, these links must be submitted or there will be no payment.
If the submissions are per our guidelines this will result in a long term agreement.
I will require proof of previous work to secure agreement. Please do not bid for this job unless you can clearly demonstrate success in submitting articles to directories with approval and caching.
Payment will be through GAF escrow.
Good luck.
If the submissions are per our guidelines this will result in a long term agreement.
I will require proof of previous work to secure agreement. Please do not bid for this job unless you can clearly demonstrate success in submitting articles to directories with approval and caching.
Payment will be through GAF escrow.
Good luck.
PHP user-friendly interface for admin of a MySQL Database by apuech
ages, we want the following features :
* DELETE,
* MODIFY (i.e. be able to update any field, just like in PhpMyAdmin)
* and INSERT a new records (e.g. a brand, collection, etc.)
When modifying a model / option, we'd like to be able to upload a new picture.
Existing PHP scripts (customer-side scripts) will be provided, as well as samples of the database.
A demo on your site is required. Payment will be made through the escrow account.
* DELETE,
* MODIFY (i.e. be able to update any field, just like in PhpMyAdmin)
* and INSERT a new records (e.g. a brand, collection, etc.)
When modifying a model / option, we'd like to be able to upload a new picture.
Existing PHP scripts (customer-side scripts) will be provided, as well as samples of the database.
A demo on your site is required. Payment will be made through the escrow account.
proposal for brand promotion and product marketing in the States by casebycase
oposal about how to market motorcycles in the States on different media and the estimate cost for each promotion; tag lines to be used for promotion and for different target market...etc.
The proposal should be as thorough as possible.
Please only bid if you agree to the following terms and conditions:
We pay with paypal only and only after you finish the project.
I will send you more details once your bid is considered.
Thanks and happy bidding!
The proposal should be as thorough as possible.
Please only bid if you agree to the following terms and conditions:
We pay with paypal only and only after you finish the project.
I will send you more details once your bid is considered.
Thanks and happy bidding!
list of town and neighborhoods in the top 10 Cities in USA
oach through the details of the project so please only bid if you understand how cities and towns are set up inside of the USA.
Here is the list of the cities:
City, State, Population
New York NY 8,363,710
Los Angeles CA 3,833,995
Chicago IL 2,853,114
Houston TX 2,242,193
Phoenix AZ 1,567,924
Philadelphia PA 1,447,395
San Antonio TX 1,351,305
Dallas TX 1,279,910
San Diego CA 1,279,329
Here is the list of the cities:
City, State, Population
New York NY 8,363,710
Los Angeles CA 3,833,995
Chicago IL 2,853,114
Houston TX 2,242,193
Phoenix AZ 1,567,924
Philadelphia PA 1,447,395
San Antonio TX 1,351,305
Dallas TX 1,279,910
San Diego CA 1,279,329
Design of a Local Directory in the transportation industry
We are coming up with a new an innovative site for the local transportation in the USA.
We are looking for talented graphic designers to come up with the all package of our site from the website to the Directory display to the Logo color scheme etc,,,
Looking for a available designer to be available for a quick start if chosen.
We are looking for talented graphic designers to come up with the all package of our site from the website to the Directory display to the Logo color scheme etc,,,
Looking for a available designer to be available for a quick start if chosen.
C Programming Assignment
er your selection: 1
What is 5 + 4? :What is your answer?: 9
Great job!!
Would you like to solve another problem ? (y/n)y
Make your selection:
Enter 1 to add
Enter 2 to subtract
Enter 3 to multiply
Enter 4 to divide
Enter your selection: 2
What is 67 - 9? :What is your answer?: 56
Try again
What is your answer?: 58
Great job!!
Would you like to solve another problem ? (y/n)n
Press any key to continue
What is 5 + 4? :What is your answer?: 9
Great job!!
Would you like to solve another problem ? (y/n)y
Make your selection:
Enter 1 to add
Enter 2 to subtract
Enter 3 to multiply
Enter 4 to divide
Enter your selection: 2
What is 67 - 9? :What is your answer?: 56
Try again
What is your answer?: 58
Great job!!
Would you like to solve another problem ? (y/n)n
Press any key to continue
Implementation the statistical forecast in the Inventory (INV) module for an Oracle Application by jvital
We need Functional advise and a work shop of training to implement the statistical forecast in the Inventory (INV) module for an Oracle Application V.11i.
A document with the detailed request is Uploaded.
Additional files submitted:
Project Description Statistical Forecast for GF.doc
A document with the detailed request is Uploaded.
Additional files submitted:
Project Description Statistical Forecast for GF.doc
application change flag the time zone in the Msn BB
change flagI want to work the application of application running on the BlackBerry
I can change flag the time zone in the Messenger BlackBerry and chose flag of any country I want to be visible to other contact
That the application serial number to work
Be the is suitable for all software
Please see the attached
the time zone in the Messenger BlackBerry
I can change flag the time zone in the Messenger BlackBerry and chose flag of any country I want to be visible to other contact
That the application serial number to work
Be the is suitable for all software
Please see the attached
the time zone in the Messenger BlackBerry
buy leads
I am looking to buy cheap - recent - data in bulk for each of these Lead types in the following categories:
Education Leads
Insurances Leads
Auto Warranty
Health Insurance
Life Insurance
Payday Loan Consolidation
Payment AFTER leads are checked and Verified.
Education Leads
Insurances Leads
Auto Warranty
Health Insurance
Life Insurance
Payday Loan Consolidation
Payment AFTER leads are checked and Verified.
BUY QUALITY LEADS
I am looking to buy cheap - recent - data in bulk for each of these Lead types in the following categories:
US EDUCATION Leads
UK LOAN Leads
Payment AFTER leads are Verified.
US EDUCATION Leads
UK LOAN Leads
Payment AFTER leads are Verified.
BUY QUALITY LEADS
ravel Leads
Diabetic Leads
Tax Leads
Auto Warranty
Satellite TV
Money for Gold Leads
Timeshare Buy, Rent Sell Leads
Health Insurance
Life Insurance
Payday Loan Consolidation
Education Leads
Debt
debt consolidation
debt management
debt settlement
debt negotiation
credit card debt
debt collection
Payment AFTER leads are checked and Verified.
Diabetic Leads
Tax Leads
Auto Warranty
Satellite TV
Money for Gold Leads
Timeshare Buy, Rent Sell Leads
Health Insurance
Life Insurance
Payday Loan Consolidation
Education Leads
Debt
debt consolidation
debt management
debt settlement
debt negotiation
credit card debt
debt collection
Payment AFTER leads are checked and Verified.
buying BULK leads data
ayday Loans
Diabetic Leads
Tax Leads
Auto Warranty
Satellite TV
Money for Gold Leads
Timeshare Buy, Rent Sell Leads
Health Insurance
Life Insurance
Payday Loan Consolidation
Education Leads
Debt
debt consolidation
debt management
debt settlement
debt negotiation
credit card debt
debt collection
Payment AFTER leads are checked and Verified.
Diabetic Leads
Tax Leads
Auto Warranty
Satellite TV
Money for Gold Leads
Timeshare Buy, Rent Sell Leads
Health Insurance
Life Insurance
Payday Loan Consolidation
Education Leads
Debt
debt consolidation
debt management
debt settlement
debt negotiation
credit card debt
debt collection
Payment AFTER leads are checked and Verified.
